MSSQL monitoring in OpManager

MSSQL Services and Parameters can be monitored using WMI. OpManager detects the SQL servers by itself and MSSQL related resource metrics are added automatically.

Configuring monitors for MSSQL services

• Individual device level configuration
• Bulk configuration for multiple devices

Device level configuration

1. Open the "Device snapshot" page by navigating to "Inventory -> Devices" and then clicking on a device.
2. Head to the "Monitors" tab and under the "MSSQL Monitors", select the instance at the drop-down box in the top right corner.
3. A list of all MSSQL monitors, available for that instance will now be listed down.
4. Now, click on the "Actions" button at the top-right corner of the page, and then select "Add Monitor".
5. Now, select the service and the relevant monitors.
6. Click on the "Save" button at the bottom.
7. Now, select the databases to which the changes must be carried out, and click on "Save".

The monitors are now successfully associated to the device. Ensure that you have used the right credentials for the device association, since OpManager uses the credentials to communicate with devices.

Bulk Configuration

1. To associate monitors to multiple devices at a time, navigate to "Settings -> Monitoring -> Application Monitors".
2. Under the "MSSQL", select the monitors you want to associate. You can even modify the monitoring interval and thresholds under the respective columns.
3. Once the monitors are selected, click on "Apply Configuration" at the top right corner. Clicking on "Save Configuration" will save the configuration changes, but won't apply it to the devices.
4. Select the devices you want to associate from the "Available Devices" section and then move them to the "Selected Devices" section.
5. Click on "Save".

Proactively monitor your MSSQL services by setting suitable thresholds

You can monitor the MSSQL services in your network by configuring thresholds. In case of threshold violation, alerts will be generated. By configuring relevant notification profiles and associating them with the respective devices, alerts will be sent out to the corresponding person at the earliest. Furthermore, users can also automate the discovery process by using the discovery rule engine feature.

Visualize your MSSQL monitoring efforts

In the device snapshot page, click on the more icon found at the top-right corner of the page. Now, select "MSSQL" to view your MSSQL monitoring dashboard. By selecting a specific instance, users can view all the monitors listed, along with their buffer and resource pool stats. Furthermore, users also have the option to add and delete databases from MSSQL dashboards by clicking on the menu option at the top right corner of the page.