Monitoring MSSQL Parameters

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 :

  1. Go to the snapshot page of a device that has MSSQL running.

  2. Click on Monitors > Performance Monitors > Add MSSQL Monitor

  3. The monitors of all the MSSQL parameters are displayed.

  4. From this list, select the required MSSQL Monitors and click Add to associate it to the Server.

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.