Getting Started Using SQL Server Monitor
Basic steps to using the SQL Server
: 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)
- Determine which SQL parameters to monitor.
- Determine which SQL
services to monitor.
- 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.
- Configure a SQL Server Monitor with your selected
parameters and/or services.
- Add the SQL Monitor to the device that
represents your SQL server.
- Set up an action to tell you when the
monitor goes Down or comes back Up.
the monitor will be reported Down if any of the parameters or
services that you selected to monitor in Step 4 are down.
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