SQL Server Administration: Using sys.dm_server_memory_dumps to find SQL memory dumps.
When SQL experiences a serious issue, it will often dump the contents of its memory to disk. This is known as a memory dump, and it does generate files that are usually located in the Logs folder. I often find that many SQL DBA's are unaware that SQL may be experiencing issues until they start seeing some scary looking messages in their error logs. It is possible for SQL to have a serious issue but not bad enough to cause it to shut down. I have also found that the memory dump files can be quite large, and may need to be cleaned up periodically. If you query the dynamic management view sys.dm_server_memory_dumps, you will get a list of memory dumps along with the location of the files.
SELECT [filename], creation_time, size_in_bytes
FROM sys.dm_server_memory_dumps
___________________________________________________________________________
SQLRx has worked hard to minimize the impact of monitoring SQL Servers to the point that we are able to monitor high transaction systems with little impact (1% load) on the target system. Contact us today to help you monitor your SQL servers!
|
