Worst Queries by Average Reads
Run the Health Check Tool and select Generate Usage Statistics. Worst Queries by Average Reads retrieves the most expensive queries on the system as determined by the average reads per execution.
To see information about the worst queries:
- Select the Generate Usage Statistics check box when you Run the Health Check Tool.
You see the Worst Queries by Average Reads in the report.
- Focus on the queries with the highest execution_count and the highest MaxReads (10th column to the right). Then look at the queries and compare them to the Missing Indexes section.
A query being at the top of the list doesn't necessarily mean it is a bad query.