MSSQL Services and Parameters can be monitored using WMI. OpManager detects the SQL servers by itself and MSSQL related resource metrics are added automatically.
Here are the steps to manually associate the MSSQL monitors to a device :
Go to the snapshot page of a device that has MSSQL running.
Click on Monitors > Performance Monitors > Add MSSQL Monitor
The monitors of all the MSSQL parameters are displayed.
These monitors are associated to the device. Ensure to associate the correct WMI credential to the device. OpManager uses these credentials to connect to the device using WMI.