This article was previously published under Q279113
This article has been archived. It is offered "as is" and will no longer be updated.
Understanding the virtual memory layout of a SQL Server 7.0 or SQL Server 2000 process space can help to understand memory leaks and virtual fragmentation that occur on the server. The xp_DumpVM extended stored procedure in the Xpvmlog component provides a way to dump the virtual memory layout of the SQL Server process.
The following file is available for download from the Microsoft Download Center:
The Xpvmlog.exe self-extracting executable contains the following files:
The Readme.txt file describes how to install the extended stored procedure on SQL Server 7.0 or SQL Server 2000. The name of the extended stored procedure is xp_DumpVM. If you pass no arguments, the virtual memory dump (which is a text file) is dumped into the C:\Vmlog_*.log file. The file name will contain the date and time. You can specify a folder and a prefix for the log file. For example, the following command:
would generate a Vmlog_datetime.log file in the C:\Logs folder where datetime is the actual date and time.
A sample of some of the output is shown below. The output lists each VM region (address, type of memory, and size) and the blocks within each region.