Runtime Stats

The Runtime Stats node displays an active event object's historical runtime information. The following two views are provided:

  • Runtime History
  • Runtime Aggregates.

Right-click on the event object, select Jump to > Runtime Stats, and the Runtime Statistics graph appears. Select from the drop-down menu to choose between the Aggregate and History graph. These graphs make it easy to identify runtime trends that can be indicators of or eventually lead to performance issues with the event or server.

SentryOne Runtime Stats

Runtime History Graph

This graph shows a job’s actual runtime and status over the specified interval. A red bar indicates that the instance failed.  

SentryOne Runtime History Graph

Runtime Aggregates Graph

This graph shows the distribution of the job’s actual runtime over the specified interval. This data can be valuable when deciding where to place a job in the schedule to minimize contention.

SentryOne Runtime Aggregates Graph

Graph Controls

SentryOne Graph Controls

Use the Navigation toolbar to change the start date/time and interval for the graph. The Days control can go up to 60 days. Whenever the selected interval is less than one-day (1 minute through 4 hours), the Days control changes to one-day.

ItemDescription
Min/Max Y ValWhen a runtime graph is first displayed, SentryOne tries to determine the most appropriate interval and maximum Y-axis value. You can change either of these settings at any time.
Auto-scale To MaxChecking this box automatically selects the appropriate Max Y Value of the data being shown in the current view.
Interval TypeChanges the interval used for the Y-axis.
Show Value LabelsDeselect this checkbox to hide the bar value labels. This can become necessary for broader ranges with hundreds or thousands of bars to reduce the noise on the graph.


Note:  For information on the Top SQL runtime stats, see Top SQL runtime stats.

See the SentryOne blog post Have You Been Using Runtime Statistics? for an in-depth look at this feature.