SQL server 2014 introduced new DMV that tracks execution
statistics while the query is executed though DMV(sys. dm_exec_query_profiles) .
Prior to SQL 2014 you can see an estimated execution plan or actual execution
plan. SQL 2016 moved a bit further and
you should now be able to see live execution plan.
LQS allows you to view a list of active queries and
associated statistics like current CPU, query progress percentage in every plan
tree, memory usage and etc. This enables rapid identification of potential
bottlenecks for troubleshooting issues. You can even see if your system is
waiting for query plan (see fig 1 below). You can see live percentage of
execution completion of each execution (see figure 2 below).
Figure 2
Figure 2
No comments:
Post a Comment