SQL Server 2014 news – sys.dm_exec_query_profiles

Oopps! Upgrade your browser pretty please.Oopps! Upgrade your browser pretty please.

Have you ever wanted to monitor your queries in Real time? Well, I have, but it has been a fantasy until now! SQL Server 2014 contains a new DMV that you can use for realtime monitoring. You can use sys.dm_exec_query_profiles to get:

  • Estimated number of rows
  • Number of rows this far
  • Physical operator
  • CPU time this far
  • Logical & physical reads this far
  • Table and/or index beeing queried
  • Elapsed time
  • etc
You can get this figures for each thread in each node in the execution plan.
 
Read more about sys.dm_exec_query_profiles here.