Posted on

SQL Server Diagnostics: New “Analyze Dumps” feature

There’s a brand new add-in in town

Microsoft’s new free add-in allows you to upload stack dumps to the cloud for automated diagnosis.

See a demo of this tool (currently in preview), in this 8 minute video:

Ready to get started and test this out yourself?

Read this post to get a list of supported SQL Server versions and more (currently SQL Server 2008+).

You must have a recent version of the SSMS client tools to use the add-in.

Download SQL Server Diagnostics (Preview) from Microsoft here.

Get more tips on using SQL Server Management Studio

This video is part of my free course, SQL Server Management Studio Shortcuts & Secrets. The course has a cheat sheet, a desktop wallpaper, a quiz, and 90 minutes of free videos – enroll today and have more fun with SSMS.

If you’ve enrolled in this course in the past, the new materials are all there waiting for you. Just log in and you’re all set!

3 thoughts on “SQL Server Diagnostics: New “Analyze Dumps” feature

  1. If anyone wants to do this form the command line – I have written a PowerShell Module called SQLDiagAPI

    1. That sounds awesome!

  2. Thanks for this post and all your insightful posts. I also look forward to your Weekly Quizletter.

    I’ve used this to analyze dumps from a SQL 2012 instance. The results of one of the dumps was useful and directed me to a solution that seems to work as those dumps did not recur. From a different SQL 2012 instance, I analyzed a dump file and the results said I should install a KB that I cannot find (internal or does not exist). My post to the Microsoft blog site on this result was not addressed. It’s a preview product, so I understand that results may not be as desired until it is RTM.

Leave a Reply

Your email address will not be published. Required fields are marked *

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