The Baseline Configuration tab of the Monitored SQL Server Properties window allows you to configure your server baseline options. SQL Diagnostic Manager calculates a baseline out of a pool of collected data based on the selected period and collection interval, and is represented by mean, standard deviation, minimum, maximum, and count statistics.

Some benefits of using this feature include:

User accounts with the View privilege can access the Baseline Configuration window, but cannot make any changes. User accounts with the Modify privilege can make changes to the baseline configuration of their monitored SQL Server instances.

Access the Baseline Configuration tab

You can access the Baseline Configuration tab of the Monitor SQL Server Properties window by right-clicking the appropriate monitored SQL Server instance, and then selecting Baseline Configuration.


Select a baseline period

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

 Dynamic

Calculates a dynamic baseline based on a moving window of the past seven days of collected data.

Custom

Allows you to set a specific time range that does not change.

Select days and time periods 

SQL Diagnostic Manager allows you to select the date range used to calculate the performance baseline for one or more selected SQL Server instances. The day and time period fields allow you to select the days and times on which to base your alert baseline calculations. These settings apply to both the Automatic and Custom baseline selections.

When your SQL Server instances are not busy, clear the days and times to remove them from the calculation and provide a more realistic and accurate baseline.

Add multiple baselines

SQL Diagnostic Manager allows you to add and schedule multiple baseline periods in addition to the default one. Open the Add baseline window by clicking the Manage Baseline button. For more information, see Schedule multiple baselines.

Apply the baseline to more than one instance

You can apply the baseline configuration from a specific server to additional instances not included when you originally created the baseline configuration.

To add a baseline configuration to additional instances:

  1. Click Apply Baseline Configuration to display the Select Monitored SQL Server Instances dialog.
     
  2. Select the appropriate instances from the Available Servers list, and then click Add > to move them to the Added Servers list.
  3. Click OK to confirm your selection and allow SQL Diagnostic Manager to apply this configuration to other instances.

When verifying your baseline configuration changes for more than one instance in the Change Log view, note that instance property changes are logged only once. In comparison, baseline configuration changes are logged as many times as the number of instances affected by the change.

Metrics used in baseline calculations

SQL Diagnostic Manager uses the following metrics when calculating a baseline for a monitored SQL Server instance:

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources Legal