MS SQL Server Database Monitoring
The SQL Server Monitoring Probe constantly monitors the internal
performance and space allocation throughout the SQL Server database and feeds
essential information based on pre-defined criteria to the Availability Manager
for appropriate alert notification when required. An extensive range of pre-defined
alerts are delivered with the SQL Server Monitoring Probe and these can quickly
be extended to meet the needs of specific monitoring requirements.
Fig. 1 The SQL Server Monitoring Probe allows you to easily
define monitoring intervals, prioritize alarms and set the level of logging
detail.
Fig2. Status reports can be generated according to your specific
requirements.
Fig3. You can easily set up or modify monitoring profiles
to meet your changing needs.
|
Features:
- Local and/or remote monitoring of SQL Servers
- Server uptime
- Size of database
- Buffer cache-hit ratio
- Log-file cache-hit ratio
- Free log-file space
- Number of:
- databases
- active users
- logged-in users
- deadlocks per second
- transactions per second
- database reads
- database writes
- flush waits
- latch waits
- full scans
- Transaction log growth
- Transaction log shrinking
|
|
