How to enable the Sqldumper.exe utility to generate dump files for processes that are related to SQL Server 2005 Integration Services with Service Pack 2

Article translations Article translations
Article ID: 941151 - View products that this article applies to.
Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
Expand all | Collapse all

INTRODUCTION

This article describes how to configure the settings of the registry entries for the Sqldumper.exe utility. These registry entries are related to Microsoft SQL Server 2005 Integration Services (SSIS). By configuring these settings, you can obtain a dump file if a fatal exception occurs. These settings let you obtain a full dump file or a partial dump file of these SSIS related processes.

The settings apply only to SQL Server 2005 Integration Services with Service Pack 2 (SP2) or later versions. These settings do not apply to earlier versions of SQL Server 2005 Integration Services.

The settings control the information that the Sqldumper.exe utility includes in the memory dump files of SSIS related processes. By default, when the settings of these registry entries are not present, the Sqldumper.exe utility is configured to generate a minidump file when a fatal exception occurs in an SSIS related process. The minidump file contains limited information about the SSIS related process that has failed.

If an SSIS related process on your computer fails, and you contact Microsoft Customer Support Services (CSS), we may ask you to enable these settings. Therefore, we can obtain a full dump file of the SSIS related process if the SSIS related process fails again. The full dump of the SSIS related process can help us to better diagnose the problem.

Not all SSIS related processes are affected by these settings. These settings affect the following SSIS related processes:
  • DTExec.exe
  • DtsDebugHost.exe
  • Dtshost.exe
  • Dtutil.exe
  • MsDtsSrvr.exe
These settings do not affect the following SSIS related processes:
  • Dtsinstall.exe
  • DTSMigrationWizard.exe
  • DTSWizard.exe

MORE INFORMATION

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

You can enable the SSIS related process to internally call the Sqldumper.exe utility to generate a dump file. To do this, follow these steps.

Note The Sqldumper.exe utility generates the dump file in the "%ProgramFiles%\Microsoft SQL Server\90\Shared\ErrorDumps" folder.
  1. Click Start, click Run, type regedit, and then click OK.
  2. Locate and then right-click the following registry subkey:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTS
  3. Point to New, and then click DWORD Value.
  4. Type SqlDumperFlags, and then press ENTER.
  5. Right-click the MSDTS entry, point to New, and then click DWORD Value.
  6. Type SqlDumperMinidumpFlags, and then press ENTER.
Important For 64-bit SQL Server 2005 Integration Services, these steps only affect the 64-bit SSIS related processes. For example, processes from the following folder are affected:
Program Files\90\DTS\binn
However, you may want to obtain a full dump file for the 32-bit SSIS related processes in 64-bit SQL Server 2005 Integration Services. For example, you want to obtain a full dump filr for the DTExec.exe process from the following folder:
Program Files (x86)\90\DTS\binn
In this case, you should locate the following registry subkey in step 2:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSDTS
To enable the SSIS related process to generate a full dump file, set the value of the SqlDumperFlags registry entry to 0x01100.

To enable the SSIS related process to generate a minidump file, set the value of the SqlDumperMinidumpFlags registry entry to 0x0120.

The following table lists the full dump flags that the Sqldumper.exe utility uses. You can also use a combination of the various flags that are listed in the table to include specific information in the full dump file. You specify the value of a full dump flag by using the SqlDumperFlags registry entry.
Collapse this tableExpand this table
Full dump flagValue
Dbgbreak0x0001
Nominidump0x0002
Validate_image0x0004
Referenced_memory0x0008
All_memory0x0010
Dump_all_threads0x0020
Match_file_name0x0040
No_longer_used_flag0x0080
Verbose0x0100
Wait_at_exit0x0200
Send_to_watson0x0400
Defaultflags0x0800
Maximumdump0x1000
Mini_and_maxdump0x2000
Force_send_to_watson0x4000
Full_filtered_dump0x8000
The following table lists the minidump flags that the Sqldumper.exe utility uses. You can also use a combination of the various flags that are listed in the table to include specific information in the minidump file. You specify the value of a minidump flag by using the SqlDumperMinidumpFlags registry entry.
Collapse this tableExpand this table
Minidump flagValue
Normal0x0000
WithDataSegs0x0001
WithFullMemory0x0002
WithHandleData0x0004
FilterMemory0x0008
ScanMemory0x0010
WithUnloadedModules0x0020
WithIndirectlyReferencedMemory0x0040
FilterModulePaths0x0080
WithProcessThreadData0x0100
WithPrivateReadWriteMemory0x0200
WithoutOptionalData0x0400
WithFullMemoryInfo0x0800
WithThreadInfo0x1000

REFERENCES

For more information about how to use the Sqldumper.exe utility to generate a dump file in SQL Server 2005, click the following article number to view the article in the Microsoft Knowledge Base:
917825 How to use the Sqldumper.exe utility to generate a dump file in SQL Server 2005
For more information about how to configure SQL Server 2005 Analysis Services to generate dump files, click the following article number to view the article in the Microsoft Knowledge Base:
919711 How to configure SQL Server 2005 Analysis Services to generate memory dump files
For more information about how to use Sqldumper.exe to generate dump files for Windows-based applications, click the following article number to view the article in the Microsoft Knowledge Base:
827690 How to use Sqldumper.exe to generate dump files for Windows applications

Properties

Article ID: 941151 - Last Review: May 1, 2008 - Revision: 3.1
APPLIES TO
  • Microsoft SQL Server 2005 Standard Edition, when used with:
    • Microsoft SQL Server 2005 Service Pack 2
  • Microsoft SQL Server 2005 Developer Edition, when used with:
    • Microsoft SQL Server 2005 Service Pack 2
  • Microsoft SQL Server 2005 Enterprise Edition, when used with:
    • Microsoft SQL Server 2005 Service Pack 2
  • Microsoft SQL Server 2005 Workgroup Edition, when used with:
    • Microsoft SQL Server 2005 Service Pack 2
Keywords: 
kbsql2005tool kbsql2005ssis kbexpertiseadvanced kbhowto kbinfo KB941151

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