SqlServer 2016 New Features — Live Query stats

Microsoft has launched SQLSERVER 2016 ctp2 for public view, This can be downloaded from the following link.
http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016.

There are lot of exciting new features in 2016, I would like to post one by one.

Live query statistics.
For demo purpose I have used Adventureworks2014 DB, Select Live query stats icon from the SSMS and execute the query.
It's awesome magic and show's live query cost of each operator. I am still exploring and post updates.

Please watch video here.





Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s