SQL Server Memory Dumps

On 02 Oct, 2015

MS SQL DBA

By : Charith Silva

No Comments

Memory dumps are a copy of what contain in the RAM during SQL or system crash or even a manual dump. Memory dumps are useful when working with any SQL server troubleshooting because it helps to identify exactly what was running on a system when the problem occurred. A Memory dump is basically the contents of Memory written out to a file.

Below query returns one row for each memory dump file generated by the SQL Server Database Engine.

SELECT [filename], creation_time, size_in_bytes/1048576.0 AS [Size (MB)]
FROM sys.dm_server_memory_dumps WITH (NOLOCK)
ORDER BY creation_time

SELECT [filename], creation_time, size_in_bytes/1048576.0 AS [Size (MB)]

FROM sys.dm_server_memory_dumps WITH (NOLOCK)

ORDER BY creation_time

Previous Post Next Post

About The Author

Charith Silva

Charith Silva is a Microsoft certified SQL Server developer and database administrator who was graduated at Buckinghamshire New university in the UK. His career was started in 1998, primarily into Web application development, and later diversified into database development. He has got a vast experience in SQL Server database development, Database administration and Business Intelligence development. He believes that sharing the knowledge is key to the success.

Number of Posts : 87

All Posts by : Charith Silva