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.