Performance Analysis Baselining

Applies to: SQL Sentry, Win Sentry, BI Sentry, V Sentry, and DB Sentry

 

Baselines are created and managed from the History view of the Performance Analysis Dashboard.  There are two distinct baseline types available. The first type of baseline is the predefined type. SentryOne includes several predefined baselines that are based on the historical metrics gathered in your monitored environment. The second type of baseline is the custom type. SentryOne also allows you to define your own custom baselines.

Once a baseline has been selected, it's overlaid on the various Performance Analysis Dashboard charts, giving you information that can help you to manage change in your monitored environment. Custom baselines can also be used in Advisory Conditions, allowing the comparison of baseline values to current metrics, as they are captured.

Note:  At this time, you can't display a baseline created by one type of target overlaid on a different type of target. For example, creating a baseline against a SQL Server instance running on a Windows target can't be overlaid on an Azure SQL Database dashboard.

Predefined Baselines

Predefined baselines are available without any custom configuration. They can be accessed from the Baseline drop-down menu on the Dashboard while in History view.

SentryOne Performance Analysis Dashboard Baseline drop-down list

The different predefined baselines are available based on the historical time range you are viewing on the Dashboard. For more information, see the following table: 

BaselineTime Range AvailabilityRange Option Availability (detail data)
Previous PeriodThis baseline is always available. Corresponds to the immediate preceding timeframe.Yes
Previous DayZero <= 24 hrsYes
Previous WeekZero  <= 168 hrsYes
Previous Month36 <= 720 hrsNo
Previous Quarter480 <= 2160 hrsNo
Previous Year960 <= 8760 hrsNo

Average and Range Modes

It's important to understand that predefined baselines are based on the historical data collected in your monitored environment. The granularity of the data-points that make up a baseline is entirely dependent on the time range you are viewing.   

Average

By default, predefined baselines are shown with data-points that show the average value over that sample period.

SentryOne Performance Analysis Dashboard Average Baseline

Range

When viewing certain predefined baselines, and within a time range that has a resolution of detail data, an additional option is available, allowing you to view that baseline with a range of values (reference the Range Option Availability column in the previous chart). This range includes both a minimum and maximum observed value during the respective sample period.

SentryOne Performance Analysis Dashboard Range Baseline

Custom Baselines

Custom baselines can be created on demand using the Dashboard user interface while in History view. To create a custom baseline, left-click on any Dashboard chart and drag to highlight your desired timeframe. 

SentryOne Performance Analysis Dashboard Create Baseline context menu

Note:  Create a custom baseline for a more specified time frame by adjusting the start and end time on the calendar toolbar to the time frame you'd like to baseline.  

Select Create Baseline from the context menu to display the Create Baseline form.

SentryOne Create Baseline form

Note:  By default, a baseline is tied to the server and instance where it's created. Enable your Custom Baseline Globally by selecting the Global Baseline check-box.
SentryOne Dashboard Create Baseline Global Baseline check-box 

Create Baseline Form

The Create Baseline form contains information about all of the metrics  captured as part of a custom baseline. For more information, see the following table:

FieldDescription
MetricThe name of the metric captured in the baseline.
DefaultDefines which metric in the chart is used when displaying the baseline.

Note:  This can be changed at any time.

Average

The value that's used for that metric in the baseline. This controls both the actual line displayed on the respective chart and the value used for comparison purposes in Advisory Conditions. Average is calculated based on the observed values for the metric within the baseline's time range.

Note:  To define custom values to be used with the baseline, simply edit the pre-calculated average value.

MinThe minimum value captured during the baseline's time range.
MaxThe maximum value captured during the baseline's time range.
Standard DeviationThe standard deviation for the values captured during the baseline's time range.


Note:  You can change the Min, Max, Average, and Standard deviation values for any metric in the Create Baseline or Edit Baseline forms. Select the desired metric, change it to your desired value, and then select Ok to save your changes.

SentryOne Create Baseline changing a metric 

Using Custom Baselines in Advisory Conditions

The values defined for metrics that make up a custom baseline can be used in Advisory Conditions. To access a baseline in an Advisory Condition, define the Advisory Condition at that same instance level for which the baseline is defined. For example, if you create a baseline on the server named LONDON.UK.COM, to access the baseline in an Advisory Condition, create the Advisory Condition from the context of the LONDON.UK.COM server in the Navigator pane. For more information about Advisory Conditions, see the Advisory Conditions topic.   

Editing Baselines

Edit baselines in the Edit Baseline form. Open the Edit Baseline form by right clicking the graph next to the baseline,

SentryOne Performance Analysis Dashboard Edit Baseline context menu option

 or by selecting SentryOne Ellipsis button by the Baseline drop-down menu.

SentryOne Performance Analysis Dashboard Edit Baseline (...) button

Deleting Baselines

Delete a baseline by selecting Delete Baseline from the Edit Baseline form, and then selecting Ok from the Delete Baseline window.

SentryOne Delete Baseline

Baselines and Performance Counter Mapping

When using baselines in Advisory Conditions,  reference the following tables that include mapping between the metrics captured in baselines and their associated friendly performance counter names.

SQL Server Baseline Mapping

ChartMetricAssociated Exposed Performance Counter (Advisory Condition format)
Backup/Restore

Backup MB/secSQL Server Database Engine: SQL Server: Databases: Backup/Restore MB/sec
Cache Hit Ratios

Page Life Expectancy (sec)SQL Server Database Engine- Buffer Node - PLE : Equals : "Node Name"

SQL PlansSQL Server Database Engine Plan Cache Hit Ratio: Equals: SQL Plans

Object PlansSQL Server Database Engine Plan Cache Hit Ratio: Equals: Object Plans
Checkpoint pgs | Lazy writes

Checkpoint pages/secSQL Server Database Engine SQL Server Buffer Manager: Checkpoint pgs

Lazy writes/secSQL Server Database Engine SQL Server Buffer Manager: Lazy writes/sec
CPU Usage

Total CPU Usage PercentWindows: Processor Information: Percentage Processor Time: Total
Database Latency

Total ms/ReadSQL Server Database Engine: SQL Server Virtual File Statistics: ms/Read

Total ms/WriteSQL Server Database Engine: SQL Server Virtual File Statistics: ms/Write
Disk IO

Total ms/ReadWindows: PhysicalDisk: ms/Read

Total ms/WriteWindows: PhysicalDisk: ms/Write
Faults (Read | Write)

Faults: ReadWindows: Memory: Faults: Read

Write Faults: WriteWindows: Memory: Faults: Write
Key lookups | Forwarded recs

Key lookups/secSQL Server Database Engine: SQL Server:Access Methods: Key lookups/sec

Forwarded records/secSQL Server Database Engine: SQL Server:Access Methods: Forwarded Records/sec
Log Flushes

Log Flushes/secSQL Server Database Engine: SQLServer:Databases: Log flushes/sec: Total
Network In

In PercentWindows: Network Interface: Received percentage: Total
Network out

Out PercentWindows: Network Interface: Sent percentage: Total
Pages

Page reads/secSQL Server Database Engine: SQLServer:Buffer Manager: Page reads/sec

Page writes/secSQL Server Database Engine: SQLServer:Buffer Manager: Page writes/sec
SQL Activity

Batches/secSQL Server Database Engine:SqlServer: SQL Statistics: Batches/sec

Transactions/secSQL Server Database Engine:Databases: Transactions/sec: Total

Compiles/secSQL Server Database Engine: SQLServer:Statistics: Compiles/sec

Recompiles/secSQL Server Database Engine: SQLServer:Statistics: Recompiles/sec
SQL Server Memory

Total SQL Memory Usage (MB)SQL Server Database Engine:SQLServer: Buffer Node: Database pages: Total
SQL Server Waits

Total Wait Time (ms)SQL Server Wait Statistics: Waits by Category: Total
System Memory

Total Memory Usage (MB)Windows: Memory: Total used Memory (MB)

SSAS Baseline Mapping

ChartMetricAssociated Exposed Performance Counter (Advisory Condition format)
CPU Usage

Total CPU Usage PercentWindows: Processor Information: Percentage Processor Time: Total
Disk IO

Total ms/ReadWindows: PhysicalDisk: ms/Read

Total ms/WriteWindows: PhysicalDisk: ms/Write
Faults (Read | Write)

Faults: ReadWindows: Memory: Faults: Read

Faults: WriteWindows: Memory: Faults: Write
Network In

In PercentWindows: Network Interface: Received Percentage: Total
Network out

Out PercentWindows: Network Interface: Sent Percentage: Total
SSAS Activity: Rows Transferred

Query rows sent/secSSAS: Storage Engine Query rows sent/sec

Processing rows read/secSSAS: Processing: Processing rows read/sec
SSAS Activity: Threads Formula Engine

Query pool busy threadsSSAS: Threads: Query pool busy threads

Query pool job rateSSAS: Threads: Query pool job rate

Query pool job queue lengthSSAS: Threads: Query pool job queue length
SSAS Activity: Threads Storage Engine

BusySSAS: Threads: Processing pool busy I/O job threads

Processing pool job rateSSAS: Threads: Processing pool I/O  job completion rate

QueuedSSAS: Threads: Processing pool I/O job queue length
SSAS General : Avg Time

Total Wait Time (ms)SSAS Trace Waits: Total Wait Time (ms)
SSAS General: MDX

Cells calculated/secSSAS: MDX : Cells calculated/sec

Calculation covers/secSSAS: MDX : Calculation covers/sec

Sonar subcubes/secSSAS: MDX : Sonar subcubes/sec

Recomputes/secSSAS: MDX : Recomputes/sec

NON EMPTY unoptimized/secSSAS: MDX : NON EMPTY unoptimized/sec

NON EMPTY for calculated members/secSSAS: MDX : NON EMPTY for calculated members/sec
SSAS General: Processing

Processing rows written/secSSAS: Processing: Processing rows written/sec

Index rows created/secSSAS: Proc Indexes: Index rows created/sec

Aggregation rows created/secSSAS: Proc Aggregations: Aggregation rows created/sec
SSAS Mem Usage (MB)

Total Cleaner Memory (MB)SSAS: Memory: Total Cleaner Memory (MB)

Total Category Memory (MB)SSAS: Memory: usage by Category: Total memory Usage (MB)
SSAS Memory: Cache Activity

Cache inserts/secSSAS: Cache: Cache inserts/sec

Cache evictions/secSSAS: Cache: Cache evictions/sec

Flat cache inserts/secSSAS: MDX: Flat cache inserts/sec

KB added/secSSAS: Cache: KB added/sec

KB shrunk/secSSAS: Memory: KB shrunk/sec
SSAS Memory: Cache Lookups

Dimension cache hits/secSSAS: Cache: Lookups/sec

Measure group cache lookups/secSSAS: Storage Engine Query: Measure group cache lookups/sec

Calculations cache lookups/secSSAS: Storage Engine Query: Calculations cache lookups/sec

Flat cache lookups/secSSAS: Storage Engine Query: Flat lookups/sec
SSAS Storage: Current Partitions

IndexesSSAS: Proc Indexes: Current partitions (indexes)

AggregationsSSAS: Proc Aggregations: Current partitions (aggregations)
SSAS Storage: File Queries

Total queries from file/secSSAS: Storage Engine Query: Total queries from file/sec

Aggregation hits/secSSAS: SSAS Trace: Aggregation hits/sec: Total
SSAS Storage: File Read KB

Total System File Read KBWindows:System:Total System read KB/Sec
SSAS Storage: File Write KB

Total System File Write KBWindows:System:Total System write KB/Sec
System Memory

Total Memory Usage (MB)Windows: Memory: Total used Memory (MB)