You are currently offline, waiting for your internet to reconnect

SQL Server Integration Services is Generating Debug Dump Files

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:

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: 04/02/2012 22:45:00 - Revision: 2.0

  • KB2027727
Feedback