WinDbg & mdmp files

Often you see mdmp files in the Log folder from when SQL Server has an issue.

The below steps, which use WinDbg, may be able to assist you find the cause of the issue.

1. Download and install Microsoft .NET Framework 4 (Standalone Installer) http://www.microsoft.com/downloads/en/confirmation.aspx?FamilyID=0A391ABD-25C1-4FC0-919F-B21F31AB88B7

2. Download Windows SDK http://msdn.microsoft.com/en-us/windows/bb980924

3. Install the below option

4. Open WinDbg and add path to symbol files

SRV*c:\symbols*http://msdl.microsoft.com/download/symbols

5. Open the mdmp file

6. Run !analyze -v

The FAULTING_IP field shows the instruction pointer at the time of the fault and is the most probable cause for the issue.

7. Use lmvm to get more information on the module and then search the net for issues with the object e.g. for above you would use lmvm msvcrt

 

More information on the various outputs from ‘!analyze  -v’ can be found here http://msdn.microsoft.com/en-us/library/ff560201%28v=vs.85%29.aspx