How to Create a Dump File from Task Manager for SSMS and Integrated Add-ins

In cases where SSMS (SQL Server Management Studio) or any integrated add-ins freeze or stop responding, a dump file can be generated for debugging purposes. This applies to both SSMS and the following dbForge add-ins for SQL Server:

1. dbForge SQL Complete
2. dbForge Source Control for SQL Server
3. dbForge Unit Test for SQL Server
4. dbForge Index Manager for SQL Server
5. dbForge Data Pump for SQL Server
6. dbForge Search for SQL Server
7. dbForge Monitor for SQL Server

Steps to Create a Dump File from Task Manager:

1. Reproduce the Issue:
   • Ensure the issue has occurred before creating the dump file (e.g., SSMS or an add-in has stopped responding but is still visible in Task Manager).
2. Open Task Manager:
   • Press Ctrl + Alt + Del and select Task Manager from the menu.
3. Switch to the 'Details' Tab:
   • In Task Manager, click on the Details tab to view the running processes.
4. Select the SSMS Process:
   • Find the ssms.exe process, which corresponds to SQL Server Management Studio.
5. Create the Dump File:
   

Right-click on ssms.exe and choose Create Dump File from the popup menu.

Example:

If you are using dbForge SQL Complete within SSMS and the application becomes unresponsive, follow the steps above to generate a dump file for ssms.exe. This file is useful for identifying the cause of the issue and can be shared with technical support.

Note: This method is compatible with SSMS versions 18, 19, 20, and 21.

• Related Articles

• How to Create a Dump File from Task Manager for Studios, Standalone Tools, and MiniTools

  If you encounter issues with Studios, Standalone Tools, or MiniTools, you can generate a dump file using Task Manager for further troubleshooting. Follow these steps to create a dump file. Steps to Create a Dump File from Task Manager: Reproduce the ...

• How to generate "dump_crash" for SSMS , including ADD-in Tools

  In case SSMS (SQL Server Management Studio) crashes, you can set up your system to automatically create a dump file for debugging purposes. Follow these steps to create the necessary registry keys. Steps to Configure Automatic Dump File Creation for ...

• How to Automatically Create a Dump File on Crash for Studios, Standalone Tools, and MiniTools

  If a crash occurs, you can configure the system to automatically create a dump file for debugging purposes. Follow the steps below to create the required registry keys for different products, such as dbForge Studio, Standalone Tools, and MiniTools. ...

• How to Enable Logging for SSMS Add-ins Without Built-in Logging

  Logging is necessary to capture detailed information about failures and issues in the program. When it's difficult to identify, reproduce, or diagnose a problem, logging helps in performing a deeper investigation. This guide applies to the following ...

• What is the difference between Standalone applications and Add-Ins?

  dbForge offers a suite of powerful MiniTools designed to streamline database development and administration. These tools come in two primary forms: standalone applications and add-ins, each catering to distinct user needs and workflows. 1. dbForge ...