Performance Analysis Dashboard Retention & Resolution

Applies to: SQL Sentry, Win Sentry, BI Sentry, V Sentry, DB Sentry, DW Sentry, and APS Sentry.

Dashboard Resolutions

The Performance Analysis Dashboard displays metrics at different resolution levels, depending on the historical time range that's selected in the toolbar. Whenever you're viewing the Dashboard in either Sample mode or in History mode, for ranges of 30 minutes or less, the raw samples collected (detail data) display. This detail level data has a collection frequency of anywhere from 10 seconds to one minute, depending on the metric. As you expand the time range you are viewing, averages over the indicated resolution interval are shown.

Time RangeResolution
Zero  <= 30 minDetail Data
30 min <= Eight hrsTwo min
Three hrs 20 min <= 36 hrs10 min
12 hrs <= Five days30 min
Two days <= 20 daysTwo hrs
Three days Eight hrs <= 40 daysFour hrs
10 days <= One yearOne day
20 days <= Two yearsTwo day
30 days <= Three years+Three day

Historical Data Retention

Performance Analysis uses the SentryOne database to store all of the performance data it collects. Performance data is rolled up, or averaged based on the age of the data. Once data becomes old enough to move into the next range, it's represented by an average over the time. The default settings for data retention for the different resolutions are as follows:

ResolutionRetention Length
Detail DataThree days
Two minFive days
10 min10 days
30 min20 days
Two hours40 days
Four hours60 days
One dayOne year
Two daysTwo years
Three daysThree years

Example One

A database administrator comes into work on Monday and wants to investigate a performance related issue that happened late Friday afternoon. Because detail data is retained for Three days (72 hours), they can access it using the most granular detail resolution ( Zero <= 30 min).

Example Two

A database administrator wants to compare performance data for the last two months (60 days). The data needs to be compared using the values for the four-hour resolution, because that's the resolution available at 60 days by default.

Note:  The data retention period can be customized for specific needs. For more information, see the SentryOne Data Capacity Planning topic.

Note:  Data viewed under the Processes tab follows the same data retention and resolution policies as outlined above.