Using Db Maint, Working with…

Import and Export Performance Counters

Deciding and configuring which performance can be a time consuming task. You might want to re-use such a configuration. Hence the Db Maint “Export and Import Performance Counters” feature.

You get to this dialog from the “Performance monitoring configuration” dialog, the Counters tab. Right click in the white area and select Export or Import.

Export

You might have configured counters for several servers (if you have the Multiple server edition of Db Maint). Select which servers’ counter that you want to save and the file name to which you want to save it.

(You can import the saved file manually, without using the Import dialog. The file is stored as a TSQL script. Adjust the line where the @@SERVERNAME is inserted into the #server_name temp table. Replace @@SERVERNAME with the name of the server which counters you want to monitor.)

Import

Write the server name that you want to apply the counters in the file for and select Import.

You might want to check http://www.dbmaint.com for files with performance counter configuration files. Over time, files will be available for typical performance monitoring for the most common back office applications.