Tag Archives: StackTrace

Using SQL Server Diagnostics (Preview)

Posted on by
12

Update – December 2020 – Feature no longer supported by Microsoft. It was good while it lasted.

I was VERY excited when I read the following tweet (below) from Bob Ward regarding SQL Server Diagnostics capability. What is it you are asking? It is an extension to SQL Server Management Studio (SSMS) where it gives you the ability to Upload / Analyse dump files created by SQL Server.

bobsql.JPG

Continue reading →

Advertisement

WinDbg and SQL Server Fun

Posted on by
2

I have a SQL Server that is constantly producing “dump” files (with a MDMP File type), these are named SQLDumpxxxx (xxx = numerical value). They are located in the following directory: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log\ – sound familiar?

Have a look at this screen shot – it’s messy!

Continue reading →