SqlServer 2016 New Features — Live Query stats

Microsoft has launched SQLSERVER 2016 ctp2 for public view, This can be downloaded from the following link.

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s