info@techdevops.com
TechDevOps.com
Explore Tools
Experts in Microsoft SQL Server Operations, Performance, Migrations, Replication & Cloud



Get SQL Server Modules loaded
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
2019-05-24








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