April 10, 2009 at 8:25 am
Hello. I'm still relatively new to the DBA role. I was looking through some of our maintenance logs, and found three files that I'm not sure how to interpret, what created them, or what they're used for. The three files are "SQLDumpxxx.mdmp", "SQLDumpxxx.log", and "SQLDumpxxx.txt".
Forgive me if this is a newbie question, but I was wondering if anyone can describe these files and/or point me to some resources about these files? I've done google searches, but haven't come up with much.
Thanks!
April 10, 2009 at 8:29 am
Those files are the result of a stack dump by SQL Server. As to the cause, very hard to say, if you're getting them frequently I would suggest that you call Microsoft's customer support people as they can interpret the memory dumps (which is what the .mdmp files are) and advice you on correcting them.
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
April 10, 2009 at 9:00 am
We also ran into this a few months ago. It turns out there was a "torn page" in our database. In our case the 3 files had corresponding messages in the log file and occured whenever someone tried to access the bad page.
We did a "dbcc checkdb" and that let us know what was wrong.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply