SQL Server Integration Services is Generating Debug Dump Files

Article ID: 2027727
Expand all | Collapse all

SUMMARY

By default, memory dumps are generated when a fatal exception occurs in a SQL Server Integration Services related process. The information in these memory dump files (SQLDmpr*.mdmp) and related tmp files (ISD*.tmp) can help you in troubleshooting these issues.

Working with Debug Dump Files

MORE INFORMATION

For more information about the products or tools that automatically check for this condition on your instance of SQL Server and on the versions of the SQL Server product, see the following table:

Collapse this tableExpand this table
Rule softwareRule titleRule descriptionProduct versions against which the rule is evaluated 
SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA)
Check for memory dump and .tmp files

The SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA) provides a rule to detect whether memory dump files exist in the Error Dumps folder. The SQL Server 2008 R2 BPA supports both SQL Server 2008 and SQL Server 2008 R2. If you run the BPA tool and encounter a Warning with the title of Integration Services memory dump(s) detected, you may want to investigate further.SQL Server 2008
SQL Server 2008 R2


SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA)
Check for memory dump and .tmp files
The SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA) provides a rule to detect whether memory dump files exist in the Error Dumps folder.If you run the BPA tool and encounter a Warning with the title of Integration Services memory dump(s) detected, you may want to investigate further.SQL Server 2012 





Properties

Article ID: 2027727 - Last Review: April 2, 2012 - Revision: 2.0
Keywords: 
KB2027727

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com