Schedule Performance
Event performance graphs clearly illustrate how schedule collisions may be impacting server and database performance. Any Windows performance counters, including any SQL Server counters, can easily be "linked" to a SQL Agent job, Windows task or Reporting Services report, and performance data will be automatically collected whenever the scheduled event runs. Combination Gantt / Bar graphs are used to visually correlate schedule activity and performance data in an easy to read format.
Runtime Graphs
Event runtime graphs provide both historical and aggregate views, making it easy to spot runtime trends that can be an indicator of underlying scheduling and/or resource contention issues. For example, you can see how your nightly backups are trending over the past 3 months to determine if and when they'll fall outside of your desired backup window.
Conflicts Viewer
The conflicts viewer shows all scheduled events on a server with overlapping runtimes, sorted descending by “Total Conflict Time” by default (the total time one event overlaps with all other events). This measure is extremely valuable in determining which events may be causing the most resource contention. You simply double-click any conflict instance to immediately jump to that spot on the calendar, then quickly resolve the conflict using drag-and-drop.
|
