Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sys.dm_server_memory_dumps (Transact-SQL)

sys.dm_server_memory_dumps (Transact-SQL)


Applies To: SQL Server 2014, SQL Server 2016 Preview

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

Applies to: SQL Server (SQL Server 2008 R2 through current version).

Column name

Data type




Path and name of the memory dump file. Cannot be null.



Date and time the file was created. Cannot be null.



Size (in bytes ) of the file. Is nullable.

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

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.

Requires VIEW SERVER STATE permission.

Community Additions

© 2015 Microsoft