Senin, 25 Oktober 2010

Mapping Virtual Address Space in T-SQL

The Dynamic Management Views (DMVs) introduced in  SQL Server 2005 provide a comprehensive window into the state of the SQL engine and also the machine it is running on. This post will look at how the SQL Server process uses DMVs to keep track of its own Virtual Address Space (VAS). Querying the sys.dm_os_virtual_address_dump DMV results a map of SQL Server VAS by allocation, effectively

Tidak ada komentar:

Posting Komentar