Get all the modules loaded in SQL Server Virtual Address Space:
--Total SQL Server Modules Loaded Size
SELECT
CONVERT(Decimal(18,1),SUM(dmva.[region_size_in_bytes])/1024.0/1024.0) [Total SQL Server Modules Loaded Size (MB)]
FROM sys.dm_os_virtual_address_dump dmva
INNER JOIN sys.dm_os_loaded_modules dmlm ON dmlm.base_address = dmva.region_allocation_base_address
--SQL Server Modules Loaded Size, Aggregrated Per Module/DLL File
SELECT
dmlm.[name] as 'Module Name', count(*) as '# Files', SUM(dmva.[region_size_in_bytes])/1024 [SQL Server Module Loaded Size (KB)],
dmlm.[Description], dmlm.[File_Version], dmlm.[Product_Version], dmlm.[base_address]
FROM sys.dm_os_virtual_address_dump dmva
INNER JOIN sys.dm_os_loaded_modules dmlm ON dmlm.base_address = dmva.region_allocation_base_address
GROUP BY dmlm.[name], dmlm.[description], dmlm.[file_version], dmlm.[product_version], dmlm.[base_address]
ORDER BY [SQL Server Module Loaded Size (KB)] DESC
--SQL Server Modules Loaded
SELECT
dmlm.[name] as 'Module Name', dmlm.[Description], dmlm.[File_Version], dmlm.[Product_Version],
dmva.[Region_Size_In_Bytes]
--, dmlm.[base_address], dmva.[region_base_address], dmva.[region_type]
FROM sys.dm_os_virtual_address_dump dmva
INNER JOIN sys.dm_os_loaded_modules dmlm ON dmlm.base_address = dmva.region_allocation_base_address
ORDER BY name
|
|
|
|
|
|