Post reply

Reading the .mdmp files

  • August 24, 2015 at 9:48 am

    #303657

    Hello Experts,

    Can you please suggest a best way to read the .mdmp files in sql server?

    Thanks.

  • August 24, 2015 at 10:03 am

    #1822024

    You need Windbg (the windows debugger), the public symbols files for the version of SQL, and a good amount of internals knowledge (windows and SQL)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 24, 2015 at 10:29 am

    #1822030

    Is there any handy document to perform the task (opening .mdmp in windbg) and reading the error?

    Thanks.

  • August 24, 2015 at 11:07 am

    #1822047

    I went to the location via cmd: C:\Program Files (x86)\Windows Kits\8.1\Debuggers\x64>

    Then I ran this cmd

    dumpchk -y srv*c:\symbols*http://msdl.microsoft.com/download/symbols "C:\Users\Desktop\Dumper\SQLDump0001.mdmp"

    I can see that the dump is loaded successfully, but can you suggest a good way to start reading the data and also if I can export the data to a .txt file to read it? I tried to redirect the value but no luck.

    Thanks.

  • August 24, 2015 at 11:09 am

    #1822048

    I now manage to redirect the value to a .txt file, but trying to understand how to read from public symbol library. Please suggest.

    Thanks.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply