Video upload date:  · Duration: PT1H46M27S  · Language: EN

Identify the missing word(s) in the following azure video

dp-300-database-admin-assoc video for identify the missing word(s) in the following sentence within the context of Microsoft Azure. Collecting data in any

This is a dedicated watch page for a single video.

Full Certification Question

Identify the missing word(s) in the following sentence within the context of Microsoft Azure. Collecting data in any system has an execution cost of CPU cycles, memory, and disk utilization that is known as observer overhead. The Query Store is designed to minimize the impact of its data collection. Data for the Query Store is written to memory for each new query, and each execution of an existing query. If this information was written to disk for each execution, the performance overhead would be significant, so SQL Server uses a setting called DATA_FLUSH_INTERVAL_SECONDS to control the frequency of flushing the Query Store data to disk. By default, the data is flushed every 15 minutes, but this value is a user configurable setting per database The other important setting to note in the Query Store options is Max Size (MB), which sets the amount of storage for the data collected. The default value is [A] and is commonly increased to around [B] depending on the volume of queries executed against a database.