"Establishing a Baseline You Can Prove Against"

1. What is the primary reason for capturing average logical reads when establishing a database tuning baseline?

It reflects server load conditions accurately. It is least affected by other activities on the server. It shows the total execution time. It indicates the number of rows returned.

2. What command should you use to ensure a fresh compile of the query plan on a development or test server?

CHECKPOINT; DBCC FREEPROCCACHE; DBCC DROPCLEANBUFFERS; SET STATISTICS IO, TIME ON;

3. Why is it important to run a query three times and take the median when testing in a development environment?

To avoid server noise affecting the measurements. To get the maximum performance of the query. To ensure the plan cache is cleaned before each run. To confirm that the database is functioning properly.

4. What should you prioritize recording when establishing a tuning baseline from the Query Store?

Total duration of the query execution. Average logical reads and plan details. Total number of users accessing the database. Change logs of previous query executions.

Continue: "Getting a Plan and Reading It Right to Left" → Review this lesson Retake quiz