August 23, 2013 at 12:52 am
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.
August 23, 2013 at 1:49 am
any reply pls...
File names are ####.mdmp
August 23, 2013 at 2:05 am
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.
August 23, 2013 at 3:28 am
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply