NetCrunch provides a predefined dedicated monitoring pack for Microsoft SQL Server: Tools->Alerting & Reporting->Settings-> Microsoft->MS SQL Server.
You can check the list of predefined alerts and reports, add nodes and modify rules of this pack in the Monitoring Pack Settings window.
MS SQL Server with NetCrunch can be monitored in several ways:
- Adding the MSSQL network service to the monitored list for the node (running MS SQL). If this is done, you can setup an alert for this network service (either network service state event or service availability threshold) so that appropriate actions are taken when the service goes down, is responding too slowly or too many of its sent packets are lost.
- Setting up an alert for Windows service related to MS SQL Server (i.e. MSSQLSERVER or MSSQLServerAdHelper service) so that if it stops or pauses you are notified or an appropriate preventive action is taken.
- Setting up Windows Application Performance Threshold alert from the Windows tab in the Add Monitoring Event window for counters of one of several performance objects related directly to MS SQL Server (such as SQLServer:Databases, SQLServer:GeneralStatistics, SQLServer:SQLStatistics, SQLServer:AccessMethods).
