SQL Server 2016 comes with another great feature to debug and troubleshoot the running queries in Management Studio.It provides you a live execution plan and it displays all information in real time. You can turn it on by clicking the following icon in the Management Studio tool bar.
To demo this new feature, I need to find a large table and run a decent query on it. I was going to use famous Adventure Works database but I realized Microsoft suspended Adventure Works sampling database with SQL Server 2016 release. Instead of Adventure works database, Microsoft published a new database named "Wide World Importers" now.
When you execute the query, you will notice the new tab named Live Query Statistics in the bottom window. Dotted lines mean that SQL Server is still working on that item. You can see the overall completion of the whole query in the left bottom of the screen.
You can still click on any operator to see its real time properties data.
This is a great addition and I know it will make many developers happy when they need to debug the queries.
No comments:
Post a Comment