This metric returns the number of non-Microsoft modules loaded into the SQL Server address space.
Having a lot of modules loaded into the address space can cause performance issues in SQL Server. This metric lets you keep an eye on how many modules you have, other than those created by Microsoft.
Thanks to Nicolaas Botes for submitting this custom metric
Non-Microsoft loaded modules
The number of non-Microsoft modules loaded into the SQL Server address space.
The T-SQL query that will collect data
Instances to collect from
The instance that you're interested in.
Databases to collect from
Use collected or calculated values
Leave the Use a calculated rate of change between collections check box unchecked
An alert is not required