Getting Started Using SQL Server Monitor

Basic steps to using the SQL Server Monitor:

Important: To use some parameters, you need to configure your System Data Source (ODBC) name for the SQL Server. This is done in the Windows Data Sources (ODBC) Administrator.

1. Determine which SQL parameters to monitor.
2. Determine which SQL services to monitor.
3. Decide whether to create a single monitor with multiple parameters and services, several monitors with one parameter or service, or some combination thereof. Whether you set up one monitor or many has an effect on how the information is reported in WhatsUp logs and notifications. For example, if you create a single monitor to check disk usage, you can name it SQLDisk and it will be reported in logs with this name.
4. Configure a SQL Server Monitor with your selected parameters and/or services.
5. Add the SQL Monitor to the device that represents your SQL server.
6. Set up an action to tell you when the monitor goes Down or comes back Up.

Note: The the monitor will be reported Down if any of the parameters or services that you selected to monitor in Step 4 are down.

Examples

If you have created other monitors or services in WhatsUp, you'll find that the SQL Monitor works in much the same way. This topic takes you through some examples of how to set up an SQL Monitor. We'll create three monitors, add them to the SQL server device, and set up notifications for each monitor.

Monitoring users on your SQL Server

Monitoring system parameters