---
title: "sys.dm_server_memory_dumps (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "06/10/2016"
ms.prod: sql
ms.reviewer: ""
ms.technology: system-objects
ms.topic: "language-reference"
f1_keywords: 
  - "sys.dm_server_memory_dumps_TSQL"
  - "dm_server_memory_dumps_TSQL"
  - "dm_server_memory_dumps"
  - "sys.dm_server_memory_dumps"
dev_langs: 
  - "TSQL"
helpviewer_keywords: 
  - "sys.dm_server_memory_dumps dynamic management view"
ms.assetid: 41782719-f54d-4e11-941a-c050c7576e23
author: stevestein
ms.author: sstein
---
# sys.dm_server_memory_dumps (Transact-SQL)
[!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)]

  Returns one row for each memory dump file generated by the [!INCLUDE[ssDEnoversion](../../includes/ssdenoversion-md.md)]. Use this dynamic management view to troubleshoot potential issues.  
 
|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.