Need help to analyse mini dump

Question

Need help to analyse mini dump

kokila-416295

Say Hey Kid

Points: 663
More actions
November 11, 2008 at 10:32 pm

#132077

Dear All
In my database sever , there are mini dump files(SQL*.mdmp) created under log folder. Some log file and txt also which explains the information about the execption.
Can anybody provide link/doc which will help to anaylze the minidump created by SQL Server.
Thanks in advance.
Regards
Kokila K

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

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

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 1

kokila (11/11/2008)
Dear All
In my database sever , there are mini dump files(SQL*.mdmp) created under log folder. Some log file and txt also which explains the information about the execption.
Can anybody provide link/doc which will help to anaylze the minidump created by SQL Server.
Thanks in advance.
Regards
Kokila K

Hi Kokila,

If SSAS crashes, these files will be created. See the below links:

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=2009532&SiteID=1

http://www.lazydba.com/sql/1__22615.html

http://sql-server-performance.com/Community/forums/p/18683/107408.aspx#107408

Regards,

Kishore.P

kokila-416295 Say Hey Kid Points: 663 More actions · Answer 2

Thanks for reply

but in my server it was generated by SQL Server Database engine.

Regards

Kokila K

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

They're produced by a crash of the DB engine or an illegal operation by one of the processes. The best thing to do if you're getting frequent stack dumps is to contact Microsoft's Customer Support. They will charge, but they're the best people to speak to about stack dumps. They have tools to analyse them and find the root causes.

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

kokila-416295 Say Hey Kid Points: 663 More actions · Answer 4

Hi friend,

I was waiting for ur reply.thanks

Is there any other way so that we can only analyze and find out the problem.

Regards

Kokila K

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

kokila (11/12/2008)
Is there any other way so that we can only analyze and find out the problem.

You can download a debugger (http://www.microsoft.com/whdc/devtools/debugging/default.mspx), point it's symbols path at MS's public symbols (http://msdl.microsoft.com/download/symbols) and try to debug yourself, but unless you have a great deal of familiarity with a debugger (assembly level) you probably aren't going to get far.

The text file that accompany the mdmps contain some readable info, but not in an easy to understand way.

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