The Select Windows System Counter window of the Add Custom Counter wizard allows you to select the counter you want from a list populated from those currently available on an existing monitored SQL Server instance, or you can enter the counter information manually.
Access the Add Custom Counter wizard
You can open the Add Custom Counter wizard by clicking Administration > Custom Counters, and then clicking Add in the Custom Counters view.
Select a counter from the list
As you select from a populated list from those currently available on an existing monitored SQL Server instance, the next drop-down list populates (filtered by your selection). This allows you to quickly find the specific counter you want to add to SQL Diagnostic Manager.
- Select whether you want to populate the list with counters that are contained in PerfMon, or populate it with every WMI counter.
- Pick the SQL Server instance to populate counter information from the drop-down list.
- Select the object name from the drop-down list.
- Select the name of the specific counter you want to add from the drop-down list.
- Select the instance from the drop-down list. The instance name is used to distinguish objects of a given type. For example, _Total refers to all instances, a drive letter such as C: for a specific disk drive, or the name of an application.
Click the Details button for information on the object name and counter name you have selected.
Manually add a counter
If you have the counter information available, you can enter the information quickly by simply pasting or typing the Object Name, Counter Name, and Instance name into their associated fields. The counter information entered must be the exact complicated name or the counter does not work correctly.
For example, to enter the Processor object name (as seen in PerfMon), use the following programmatic name entry depending on the system configuration:
You can find custom counter programmatic names on Microsoft TechNet.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >