Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Baseline Statistics report Period indicates the date range for which you want to see results. If you select Today or Custom Range , SQL Diagnostic Manager displays additional fields that allow you to filter results by the start and end hours.

Tip

If you select Custom Range as the Period , and the start and end dates are both for the same day, SQL Diagnostic Manager calculates the selection the same as if you select Today as the Period .

How SQL Diagnostic Manager calculates metric values on this report

The baseline values are the most recent calculations for the selected period. Note that the Metric Value is an average of all data for the selected metric. For example, if you select Hours from the Sample drop-down list, the Baselines Statistics report grid includes 24 rows for a single day, one row for each hour from 00:00 to 23:00. Each row displays a metric value which is the average of the selected metric for that hour, such as 05:00 to 05:59:59, and the baseline values which are calculated for the entire 24-hour day. As a result, SQL Diagnostic Manager displays 24 rows of different metric values but equal baseline values.

You can access our 

Newtablink
aliasCustomer Service Portal
urlhttp://www.idera.com/support/

...

productsupport
for more information about the algorithm used to calculate a specific metric.

  • How does SQL Diagnostic Manager gather statistics from monitored SQL Servers? - Solution #00000055

...