NetCrunch provides a predefined dedicated monitoring pack for Microsoft SQL Server:
Monitoring->Monitoring Packs & Policies->Monitoring Packs->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:
Setting up alerts for the MSSQL network service
This service should be added to the monitored list for the node with running MS SQL. Then you can setup an alert for this network service for example when its state changes to DOWN or UP, or it is responding slowly and/or too many packets are lost. This is done by selecting either the Network Service State Event, Network Interface State Rule or the Event Trigger for Network Service Counter class during actual event definition.
Setting up an alert using the Event Trigger for Windows Performace Counter class
This class is available on the Windows tab of the Add Monitoring Event window. Counters of one of several performance objects related directly to MS SQL Server can be set (such as SQLServer:Databases, SQLServer:GeneralStatistics, SQLServer:SQLStatistics, SQLServer:AccessMethods).
Setting up an alert using the Windows Services
Setting up an alert for Windows service related to MS SQL Server (MSSQLSERVER or MSSQLServerAdHelper service) so that if it stops or pauses you are notified or an appropriate preventive action is taken.
