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
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar