This chapter covered the important topic of tracking query progress, and how to use either LQS 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 the 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 complete.
The Query Profiling Infrastructures available in SQL Server depend on the Database Engine version. The following table summarizes the available options to enable either of the Query Profiling Infrastructures and the minimum required version for each option:
| Where to enable | Standard Profiling | Lightweight Profiling |
|
Globally
|
XEvent session with query_post_execution_showplan XE; |
XEvent session with... |
