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

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

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s