SQL Diagnostic Manager allows you to define and schedule any number of baseline periods in addition to the default one.
To add a new baseline:
- Type a name in the Baseline Name box.
- Click Add Baseline to display the Add Baseline dialog.
Specify the date range and time period to be used to calculate the new baseline.
- Type again your selected baseline name and click Add.
- To add more baselines, click Add Baseline.
- Assign a new name to distinguish from your prior baselines in the Baseline Name box.
- Follow step 3 again and click Add.
SQL Diagnostic Manager allows only one baseline in effect at any time.
To edit a baseline:
- Select the baseline that requires an update from the Add Baseline list.
- Modify days and time period as desired.