Continuous Monitoring and Alerting
Teratrax Performance Agent has a very low footprint on the server. It is designed to
monitor SQL Server instances permanently and not only during periods of slow
performance. You can control how much data you want Agent to collect by
simply changing the threshold values in the Monitoring tab. Agent creates an
optimized trace and, by default, accesses the server only
once every five minutes to retrieve performance counters. If the "Capture
SQL Server blocks that exceed x milliseconds" option is enabled, Agent will
check for blocks every twenty seconds.
Permanent monitoring allows you to ensure that all of your enterprise
servers are up and running. If any of your servers is not reachable,
Agent will send you an e-mail message indicating that the server could
not be reached.
Permanent monitoring also allows you to view the history of SQL
Server performance counters and cache hit ratios and compare it over
time. It also allows you to take preemptive actions to correct
performance problems before they escalate. For example, an UPDATE
statement taking 100 ms today, could require more time as
the table grows. With permanent monitoring, you can configure Agent to alert
you when a query exceeds a certain duration. It can even send you an
e-mail message indicating which SQL queries are performing slower than expected.
E-mail alerts indicating that the server is not responding (Server
Down Alerts) are configured in the Alerts tab in Teratrax Performance
Agent. All other e-mail alerts can be created and managed from
Teratrax Performance Viewer. |
