SSMS: Your one-stop-shop for SQL Server Performance Troubleshooting | Data Exposed

This post has been republished via RSS; it originally appeared at: Channel 9.

Today's guest on the Data Exposed show is Pedro Lopes, a PM in the SQL Server TIGER team, and he's in the studio today to show off some of the things his team has been working on over the last year to help improve the tooling around SQL Server performance troubleshooting built right into SSMS. 

[03:00] - Microsoft SQL Server Performance Dashboard

[06:00] - Activity Monitor Active Expensive Queries and Show Live Execution Plan

[09:20] - Show Query Text

[11:10] - Compare Showplan and Showplan Analysis

[22:20] - New Query Reports, including Queries with Forced Plans and Queries with High Variation

[23:13] - Plan Comparison - the ability to compare the plans for a selected query.

 

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.