SQL 2016 CTP2 – New SSMS Feature – Live Query Statistics
This is a neat new feature in SSMS, Live Query Statistics. Not entirely useful, but it helps visualize how query execution. This generates a live action query plan so to speak and can be helpful in troubleshooting query development. The query running will naturally occur some overhead by having to generate live query plans, so do not expect tip top performance when using this feature, and certainly take your normal precautions when running this…don’t do this on a highly active production system.
I recorded a brief video of this in action:
There are a few limitations to Live Query Statistics. Queries using columnstore indexes and memory optimized tables are not supported. Additionally, Natively compiled stored procedures are not supported.
Jeff Shurak is an Anexinet SQL Server Architect focused on Disaster Recovery and Cloud Migration with over 14 years of data technology experience in ETL development, three-dimensional cube development, and database administration.