Microsoft just released a community technological preview for the next release of SQL Server. Download…
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.