Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Mdmp files Expand / Collapse
Author
Message
Posted Friday, August 23, 2013 12:52 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 3:16 AM
Points: 666, Visits: 900


Hi All,
In my production server , SQL Error log file size is growing by creating mdmp (memory dum files in c drive ).

How i can stop them.

Post #1487651
Posted Friday, August 23, 2013 1:49 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 3:16 AM
Points: 666, Visits: 900
any reply pls...

File names are ####.mdmp
Post #1487663
Posted Friday, August 23, 2013 2:05 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 7:12 AM
Points: 2,255, Visits: 2,717
Can you check in the SQL Error logs what is causing these memory dumps? Also check the Windows Event logs. I expect some severe error messages just before the dumps are created.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1487673
Posted Friday, August 23, 2013 3:28 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:30 AM
Points: 42,756, Visits: 35,847
Figure out what problems are causing the stack dumps that generate the files. Fix whatever the root cause is.

To be honest, the priority shouldn't be stopping the file generation, it should be fixing whatever critical problem is causing SQL to stack dump in the first place.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1487708
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse