SQLServer-DBA.com Links

Subscribe to newsletter

Dba_db2_button

Powered by TypePad
SQL Server - sys.dm_os_loaded_modules

10 October,2011 by Jack Vamvas

sys.dm_os_loaded_modules  is a SQL Server OS Dynamic Management View (DMV). It  returns a list each module loaded into the server address space

When executing the t-sql statement below – a recordset is returned . I’ve included some output further down the page :

select file_version,product_version,company,[description],name from sys.dm_os_loaded_modules  

 

I find this dmv useful when troubleshooting corruption .

An example , is to  check if there is any anti-virus module which is getting loaded in the SQL memory area. Normally , I’m looking for non-Microsoft Corporation modules .

Returns a row for each module loaded into the server address space.

 

2005.90:4340.0	9.0:4340.0	Microsoft Corporation	SQL Server Windows NT
5.2:3790.4789	5.2:3790.4789	Microsoft Corporation	NT Layer DLL
5.2:3790.4480	5.2:3790.4480	Microsoft Corporation	Windows NT BASE API Client DLL
8.0:50727.3053	8.0:50727.3053	Microsoft Corporation	Microsoft® C Runtime Library
7.0:3790.3959	6.1:8638.3959	Microsoft Corporation	Windows NT CRT DLL
8.0:50727.3053	8.0:50727.3053	Microsoft Corporation	Microsoft® C++ Runtime Library
5.2:3790.4455	5.2:3790.4455	Microsoft Corporation	Advanced Windows 32 Base API
5.2:3790.4759	5.2:3790.4759	Microsoft Corporation	Remote Procedure Call Runtime
5.2:3790.4530	5.2:3790.4530	Microsoft Corporation	Security Support Provider Interface
2005.90:4035.0	9.0:4035.0	Microsoft Corporation	SQLOS Hosting DLL

 Related Posts

SQL Server – Download the Perfstats script

How to report a SQL Server performance problem

SQL Server Performance Killers


Author: Jack Vamvas (http://www.sqlserver-dba.com)

******** *******

Subscribe to SQLServer-DBA.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer