Taiob Ali walks us through lightweight query profiling:
With the release of lightweight profiling, you can monitor real-time query progress while the query is in execution. There are a few ways to do this.
– Using System dynamic management view sys.dm_exec_query_profiles which monitors real-time query progress while the query is in execution.
– Using System dynamic management view sys.dm_exec_query_statistics_xml which returns returns query execution plan for in-flight requests.
Click through for more details, including how to enable it.