Page History

SQL Diagnostic Manager, by default, displays a wide variety of the most common SQL Server and Operating System performance metrics, by default. In addition to providing these common metrics, custom counters provide the ability to add additional performance metrics to the SQL Diagnostic Manager Console used for historical trending, on-demand monitoring, and schedule refresh alerting.

...

You can add the following types of metricscounters:

• All Windows System Counters, including all Perfmon and WMI countersWMI counters
• Any SQL Server SQL Server System Counter stored in the sysperfinfo system table
• Any numerical value you would like to return from a custom SQL scriptSQL script
• VM and VM and host server performance counters accessible through the host Server
• Azure Server System Counter to monitor counters collected using API supplied by Azure.

...

To open the Custom Counters view, click Administration > Administration > Custom Counters from the navigation pane.

Image RemovedImage Added

Create a custom counter

To add a custom counter:

1. Select Administration in the navigation pane.Select the Administration tab and click Custom Counters.
2. If this is your first time to access this page, click Click here to add a new custom counter now. If you have accessed this page before, click AddClick Add to create a Custom Counter.
3. Click Next on the Add Custom Counter wizard Welcome page.
4. Select a counter type, and then click Next.
5. Select the counter you want to monitor, and then click Next.
6. Select the counter calculation type and scale factor, and then click Next.
7. Type a name for the custom counter, select a Category, add a Description, and then click Next.
8. Configure your alert settings related to the new custom counter, and then click Next.
9. Click Finish.

Using custom SQL scripts SQL scripts

Use custom SQL scripts SQL scripts to monitor metrics that are not connected to the system or SQL countersSQL counters, under-utilized SQL 2005 SQL 2005 DMVs, or metrics that are very specific to your environment, such as row count for a production table.

...

Your new custom counters appear in the Alert Configuration and the Default Alert Configuration windows in the Custom category. You can edit the alert thresholds , and even decide whether you want an alert associated with the new counter.

...

The Server Details view lists all the metrics monitored by SQL Diagnostic Manager, including all your new custom counters. You can filter this view to display only your custom counters by selecting the Custom Counters radio - button in the Filter ribbon. You can access this window by selecting details on the Server view or by double-clicking Custom Counters in the Servers tree.

...

SQL Diagnostic Manager provides a list of all your custom counters in the Custom Counters table on the Administration window. In addition to viewing a list of custom counters, you can add a new counter, edit a counter, delete a counter, test a counter, or link a counter to a SQL Server an SQL Server instance for monitoring.