Monitor Schedule Performance
Event Manager makes it simple to link any Windows performance counter directly to any job, task, or report and see exactly what impact it's having on performance throughout its run lifetime. Event Manager automatically enables and disables counters as needed, minimizing server and network overhead.
You can easily link performance counters from different servers to a job, which can be extremely valuable for troubleshooting jobs that do work on multiple servers such as for replication, log shipping, DTS, etc.
Runtime Thresholds
Never again get burned when a job hangs and runs for 5 days instead of 5 minutes, and you're never alerted. Event Manager continuously monitors job and task runtimes and generates alerts based on defined minimum or maximum runtime thresholds, which can be set at the global, server, or job-level. You can easily be alerted whenever any job, task, report, or DTS package in your enterprise runs above or below a certain percentage of its "average" runtime, as well as an explicit threshold such as "1 hour".
Block Detection
Event Manager detects whenever a SQL Agent job is involved in a blocking condition (blocked or blocking), and alerts you with the full SQL statements, host names, and application names in the blocking chain.
Chaining and Queuing
Advanced scheduling features such as event chaining and queuing can help ensure that schedule conflicts and resource contention are prevented, even when runtimes fall outside of the norm. Event Manager is the first system enabling automation and integration across different scheduling systems, ensuring precise control over which events run and when.
See Shared Resource Views for more info on increasing performance of shared resources such as SAN and NAS devices, and Monitoring Disk Contention to see how jobs can dramatically impact performance through heavy
contention for disk resources.
Read the review Event Manager - SQL Server Performance Optimization by Stephen Wynkoop, Microsoft SQL Server MVP.
|
|
