Sunday, June 30, 2013

0 Sqldumper and winDbg

Sqldummper.exe is the SQL Server utility that can take the memory dump for the SQL server. After taking the memory dump, we can load it using the winDbg to see the internal call for trouble shooting.

Sqldummper comes with the sql server install and you can find it in the common shared folder.

SQLServerInstallDrive:\Program Files\Microsoft SQL Server\number\Shared

Note In this folder path, number is a placeholder for one of the following:

  • The folder name is 110 for SQL Server 2012.
  • The folder name is 100 for SQL Server 2008.
  • The folder name 90 for SQL Server 2005.

Here is the example to take the mini memory dump and put the dump file in the C:\temp

image

  • Full dump file :

    Sqldumper.exe ProcessID 0 0x01100

  • Mini-dump file

    Sqldumper.exe ProcessID 0 0x0120

  • Mini-dump file that includes indirectly referenced memory

    Sqldumper.exe ProcessID 0 0x0120:40

  • Filtered dump file

    Sqldumper.exe ProcessID 0 0x8100

By default, if we don’t specify the dump directory, it will put the dump file in the current folder.

Windbg

Windbg is the application that we can use to attach to the process or open the memory dump.

http://msdn.microsoft.com/en-US/windows/hardware/hh852363#InstallationInstruction

image

Setup symbol file source

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

image

open Crash dump

image

The file I open here is just a mini dump therefore it does not have much information .

image

 

Reference

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates