Yesterday I wrote blog post based on my latest Pluralsight course on learning SQL Server 2014. I discussed newly introduced live plans. For query before you execute it, you can see the estimated execution plan and after you executed you can see the actual execution plan – however, how to see a query plan while the query is still being executed. This is a very interesting question. In SQL Server 2014 we have now a new DMV, which tracks execution stats at each operator level while the query is still running. The DMV for the same issys.dm_exec_query_profiles.
I hope my earlier blog post clearly explained how live plan for executing query works. If not, I suggest you watch following quick video where I explain this concept in extremely simple words.
You can download the code used in this video from Simple Demo of New Cardinality Estimation Features of SQL Server 2014.
Here are the blog posts I have previously written. You can read it over here:
You can subscribe to my YouTube Channel for frequent updates.
Reference: Pinal Dave (http://blog.sqlauthority.com)