Item: SQL Server memory dumps
What are the SQL Server dump files?
They are memory dumps files generated when SQL hits a bug, or something “unexpected” happens.
The size and contents of which are dependent on the problem that occurred.
Note: Memory dump files may contain sensitive information.
Should you care about SQL Server dumps?
It’s equivalent to Windows bluescreening, so it isn’t typical behavior of SQL Server.
These files may be consuming a Lot of Disk Space too.
How can I find the dump files?
You can use the query below to list all SQL Server dump files.
SELECT * FROM sys.dm_server_memory_dumps ORDER BY creation_time DESC
How can I fix the issue?
- Patch your SQL Server, upgrade to the latest SP & CU.
- If the memory dumps continue and you are familiar with a debugger, you can try to understand the issue troubleshooting the files.
- If you’re not comfortable, open a support case with Microsoft.