Monitoring MSSQL Parameters

MSSQL Services and Parameters can be monitored using WMI. OpManager Plus 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 Plus uses these credentials to connect to the device using WMI.

Video Zone
OpManager Customer Videos
Michael Senatore, Operations Manager, Rojan Australia Pty Ltd.
  
  •  Venkatesan Veerappan, IT Consultant
     Mohd Jaffer Tawfiq Murtaja, Information Security officer from Al Ain sports club
  •  Jonathan ManageEngine Customer
     IT Admin from "Royal flying doctor service", Australia
  •  Michael Senatore, Operations Manager, Rojan Australia Pty Ltd.
     Michael - Network & Tech, ManageEngine Customer
  •  Altaleb Alshenqiti - Ministry of National Guard - Health Affairs
     Donald Stewart, IT Manager from Crest Industries
  •  John Rosser, MIS Manager - Yale Chase Equipment & Services
     David Tremont, Associate Directory of Infrastructure,USA