sys.dm_server_memory_dumps (Transact-SQL)

Applies to: SQL Server

Returns one row for each memory dump file generated by the SQL Server Database Engine. Use this dynamic management view to troubleshoot potential issues.

Introduced in SQL Server 2008 R2 (10.50.x) Service Pack 1.

Column name	Data type	Description
filename	nvarchar(256)	Path and name of the memory dump file. Cannot be null.
creation_time	datetimeoffset(7)	Date and time the file was created. Cannot be null.
size_in_bytes	bigint	Size (in bytes ) of the file. Is nullable.

General Remarks

The dump type may be a minidump, all-thread dump, or a full dump. The files have an extension of .mdmp.

Security

Dump files might contain sensitive information. To help protect sensitive information, you can use an access control list (ACL) to restrict access to the files, or copy the files to a folder that has restricted access. For example, before you send your debug files to Microsoft support services, we recommend that you remove any sensitive or confidential information.

Permissions

Requires VIEW SERVER STATE permission.

Permissions for SQL Server 2022 and later

Requires VIEW SERVER PERFORMANCE STATE permission on the server.