Get a full memory dump to troubleshoot SSMS
Applies to:
SQL Server
Azure SQL Database
Azure Synapse Analytics
Analytics Platform System (PDW)
In this article, you learn how to capture diagnostic information to troubleshoot a crash or an unresponsive system that you experience in SQL Server Management Studio (SSMS).
Get a full memory dump after an unresponsive system or crash
Get a full memory dump of SQL Server Management Studio (SSMS) when it stops responding or crashes.
To capture diagnostic information to troubleshoot a crash or an unresponsive SSMS, use the following steps:
Download ProcDump.
Unzip the download into a folder.
Open a Command Prompt (such as
cmd.exe
), and run the following command.<PathToProcDumpFolder>\procdump.exe -e -h -ma -w ssms.exe
It should prompt you to accept a license agreement, select Agree.
Start SQL Server Management Studio (SSMS) if not started already.
Reproduce your issue.
Wait as the text appears in the cmd prompt about writing the dump file, don't proceed until it finishes.
Create a new folder and copy the *.dmp file that is written out to that folder.
Copy the following files into the same folder.
- "C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscordacwks.dll"
- "C:\Windows\Microsoft.NET\Framework\v4.0.30319\SOS.dll"
- "C:\Windows\Microsoft.NET\Framework\v4.0.30319\clr.dll"
Zip up the folder.
OutOfMemoryException
You can also get the Full Memory Dump of SSMS when it throws an OutOfMemoryException (can be any managed exception).
To capture diagnostic information to troubleshoot an OutOfMemoryException from SSMS, use the following steps:
Download ProcDump.
Unzip the download into a folder.
Open Command Prompt and run the following command.
<PathToProcDumpFolder>\procdump.exe -e 1 -f System.OutOfMemoryException -ma -w ssms.exe
It should prompt you to accept a license agreement, select Agree.
Start SQL Server Management Studio if not started already.
Repro the issue.
Wait as the text appears in the cmd prompt about writing the dump file, don't proceed until it finishes.
Create a new folder and copy the *.dmp file that is written out to that folder.
Copy the following files into the same folder.
- "C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscordacwks.dll"
- "C:\Windows\Microsoft.NET\Framework\v4.0.30319\SOS.dll"
- "C:\Windows\Microsoft.NET\Framework\v4.0.30319\clr.dll"
Zip up the folder.
Share the information
To share the information with the SSMS Team, log the issue at https://aka.ms/sqlfeedback.
Then share the memory dump file collected to OneDrive (or equivalent) where the file can be collected.
Important
Memory dump files may contain sensitive information.
Next steps
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for