Versions Compared

Key

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

SQL Diagnostic Manager allows you to define and schedule any number of baseline periods in addition to the default one.

Image RemovedImage Added

To add a new baseline:

  1. Click Manage Baseline to display the Manage Baseline window. Image Removed Image Added
  2. Type a name in the Baseline Name field. 
  3. Select Dynamic Select Dynamic to use the default options or select Custom to set the date range, the days, and the time period to calculate the baseline performance for the server.
  4. Select the days and time period periods to schedule when to apply baseline to the server.
  5. Click Add to save the created baseline, click Edit to edit the baseline, or click Delete.
  6. Click Save.

Tip

The baseline period you specify should represent a typical operation of the monitored SQL Server instances to which this baseline applies.

...

  1. Click Manage Baseline to display the Add baseline window.
  2. Select the baseline you want to update from the Baseline Name list.
  3. Modify days and time period periods as desired.
  4. Click Save.
Note

When you schedule a new baseline, the changes are applied to the next day or when the baseline is refreshed (test this behavior when the feature is available).

...