Use the Query Execution Statistics grid to diagnose workload issues by displaying SQL statements that match particular criteria.
The columns in the Query Execution Statistics grid correspond to the data returned by sys.dm_exec_query_stats. For more information on sys.dm_exec_query_stats, see the Transact-SQL Reference section in Microsoft SQL Server Books Online.
To reduce the load when querying the SQL Server, Spotlight determines the top statements using the ‘by’ criteria before applying the other filters. For example, if you want to find statements using a particular index, and the top n filter was set to top 50 statements by average worker time, Spotlight first finds the top 50 statements by average worker time and then looks for the use of the specified index within this top 50.
Tip: Select a statement in the grid to see the complete SQL statement and the query plan.
Note: Optimizer Plan Visualization and display of the SQL Statement - Not available in Playback mode.
Note: The Query Plan column is empty for longer query plans (plans exceeding 43679 characters). As a workaround, right click on the blank query plan cell and select to copy the current cell to the clipboard.