10. Graphical Reporting
You believe your database environment is running slower than normal but how do you present the details to management?
SQL Sentry Event Manager's schedule performance and event runtime graphs enable quick trend analysis, and Gantt-style performance graphs highlight the events competing for resources and causing end-user performance problems.
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.
"Our team has been impressed with the range of functionality, the ease of use and the comprehensive job management capabilities of Event Manager. To put it in a short form...a first class application."
-- Markus Kottwitz, EMP Lingen, Germany
|