Documentation forSQL Sentry

SQL Sentry Runtime Stats

Introduction

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

  • Runtime History
  • Runtime Aggregates

Opening Runtime Stats

  1. Open the Event Calendar.
  2. Right-click on an event object.
  3. Select Jump To > Runtime Stats to open the Runtime Statistics graph.
    Runtime Stats graph displaying data for a 3 day period from the Event Calendar selection.

You can also view Runtime Stats graphs for individual jobs. 

  1. Open the Navigator pane
  2. Expand the local jobs node for the desired instance
  3. Expand the desired job
  4. Double click Runtime Stats to open the Runtime stats graph for your selection

Navigator Pane with an expanded Local Jobs node and a selected Runtime Stat node on the left, and the graph on the right.

Aggregate vs. History

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.

Runtime stats graph with the graph view drop-down menu selected and highlighted displaying the History and Aggregate options.

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.  

Runtime Stats graph in the history view displaying stats across a specified interval.

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.

Runtime Stats graph in the aggregate view displaying stats across a specified interval.

Graph Controls

Runtime Stats graph settings at the bottom left of the page.

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.

Item Description
Min/Max Y Val When a runtime graph is first displayed, SQL Sentry 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 Max Checking this box automatically selects the appropriate Max Y Value of the data being shown in the current view.
Interval Type Changes the interval used for the Y-axis.
Show Value Labels Deselect 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.
Additional Information: See the blog post Have You Been Using Runtime Statistics? for an in-depth look at this feature.