Controlling and managing SQL Server error dumps in SQL Server 2012

• pmscorca

  SSCrazy

  Points: 2349

  More actions

  October 28, 2015 at 3:03 am

  #312599

  Hi,

  in the SQL Server machine that I use, the SQL installation has been made with the default settings.

  I've noticed many dump files (*.mdmp) in the folder C:\Program Files\Microsoft SQL Server\110\Shared\ErrorDumps.

  None has generated any wanted dump files for SQL Server Agent jobs and deployed SSIS projects, so I think that

  these dump files can only be generated automatically by SQL Server.

  Is it possible to disable or control this dump generation?

  Is it possible to reduce the info saved in the tmp files and in the mdmp files?

  Do I need to investigate a system error to detect the possible reasons for these dump files?

  Many thanks