What is a dump file?
They are memory dumps files generated when SQL hits a bug, or something "unexpected" happens. This is the same as Windows OS bluescreening.
The size and contents of which are dependent on the problem that occurred.
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.
