Windows Process Monitor

Windows Proccess Monitor – https://docs.microsoft.com/en-gb/sysinternals/downloads/procmon


Debugging SQL Server crashes with windbg

Download windows sdk

https://developer.microsoft.com/en-us/windows/hardware/windows-driver-kit

Install just debugging tools for windows

UPDATE:  Now you can go to directly install Debugging Tools for Windows:

https://developer.microsoft.com/windows/hardware/download-windbg

 

Check for updates

All Apps -> Windows Kits -> Windbb (X64)

File->Open Crash dump->

C:\Program Files\Microsoft SQL Server\<instance>\Log\SQLDump0001.mdmmp

Point to Symbols

.sympath srv*c:\Websymbols*http://msdl.microsoft.com/download/symbols;

Load symbols

.reload /f

Switch to exception context

.ecxr

Dump stack

kC 1000

Advertisement