SQL Server Health Check

Is Your SQL Server Generating Dump Files?

Updated July 13, 20261 min read

What is a SQL Server dump file? Ploom pokes out of a metal skip full of crumpled paper.

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.

Their size and contents depend 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.

T-SQL
SELECT *
FROM sys.dm_server_memory_dumps
ORDER BY creation_time DESC
Figure 1 - SQL Server dump files
Figure 1 -SQL Server dump files

How can I fix the issue?

  1. Patch your SQL Server.
  2. Upgrade to the latest SP & CU.
  3. If the memory dumps continue and you are familiar with a debugger, you can try to understand the issue troubleshooting the files.
  4. If you're not comfortable, open a support case with Microsoft.

More information

Check Red9's SQL Server Services

SQL Server Consulting

Perfect for one-time projects like SQL migrations or upgrades, and short-term fixes such as performance issues or SQL remediation.

Discover More ➜

SQL Server Managed Services

Continuous SQL support, proactive monitoring, and expert DBA help with one predictable monthly fee.

Discover More ➜

Emergency SQL Support

Take the stress out of emergencies with immediate access to a SQL Server Sr. DBA 24x7x365

Discover More ➜

Explore All Services ➜