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

Play SSMS: Your one-stop-shop for SQL Server Performance Troubleshooting
Sign in to queue


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.

Be sure to follow the Data Exposed show on Twitter at @DataExposed!



Download this episode

The Discussion

Add Your 2 Cents