Summary
This chapter covered the important topic of tracking query progress, and how to use either Live Query Statistics to see the live progress of a single query in SSMS, or Activity Monitor to access the live progress of any running query. We also covered how these tools and underlying Database Engine features are invaluable to troubleshoot and solve query performance issues, namely for those queries that take hours to complete, or never do.
The Query Profiling Infrastructures available in SQL Server depend on the Database Engine version. The following table summarizes the options to enable either of the Query Profiling Infrastructures and the minimum required version for each option:
|
Standard Profiling |
Lightweight Profiling |
|
|
Globally |
XEvent session with |
...
