Using Db Maint, Working with…

Performance Monitoring Configuration

In order to perform performance monitor logging, you first have to specify the database to log to. Do this in the Server properties dialog.

You will then select which counters to log etc in the “Performance monitoring configuration” dialog. Enter this dialog by right clicking the “Performance monitor” folder in the main window and select “Configure…”. If the option is disabled, make sure that the database is specified in the Server properties dialog.

In this dialog, you configure various aspects of Db Maints performance monitoring logging functionality. There are three tabs in the dialog:

Counters tab

Here, you can select which counters that Db Maint will capture values for at each capture occasion.

Add a counter by right clicking in the white section and select “Add…”. Here you will be presented a (standard Windows) dialog where you select the machine, object possible instance and counter that you want to add.

Remove a counter by right clicking on a counter and select “Remove”.

You can also toggle on and off display of the counters explain text.

For explanation of the “Import…” and “Export” options, see Import and Export Performance Counters.

Alerts tab

Db Maint can alert you when a counter goes over or under a certain value. Configure such Alerts in this tab.

To add an alert, browse and select the counter for which you want to add the alert. The counter name will be presented in the “Selected counter” text box.

Select of you want to alert if the value is “Over” or “Under” a certain threshold.

Enter the value (you can browse for currently logged values for this counter).

Select which type of message, which Db Maint is to write to the Db Maint log (Information, Warning or Error).

You can optionally select a SQL Server message that Db Maint will raise (using the TSQL RAISERROR statement). This means that you can raise a message that can be handled by SQL Server Agent’s alert handling, even for non-SQL Server messages. You also have an option to create a SQL Server error message from here.

Error log tab

If the Db Maint accounts any error when it collects performance counter values, it will log the error messages to a performance collection system table. This table will be cleared at each execution, so only the last runs error messages are kept here. You can see those messages in this dialog.