Follow these steps to enable SQL Diagnostic Manager Performance Counters:
- Go to the SQLDM installation folder path: C:\Program Files\Idera\Idera SQLdiagnostic manager
- Open SQLdmManagementService.exe or SQLdmCollectionService.exe as Administrator (depending on which SQLDM Performance Counters you want to enable)
- Edit it and add the following parameter: publishPerformanceCounters=”true” , restart the services.
Review the following examples:
<configuration> <Idera.SQLdm> <Services> <CollectionService instanceName="Default" managementServiceAddress="ServerName" publishPerformanceCounters="true"/> </Services> </Idera.SQLdm> </configuration>
<configuration> <Idera.SQLdm> <Services> <ManagementService instanceName="Default" repositoryServer="SQLInstanceName\Name" servicePort="5166" repositoryDatabase="SQLdmRepositoryName" publishPerformanceCounters="true"/> </Services> </Idera.SQLdm> </configuration>
If you no longer want to publish the SQLDM Performance Counters, set the parameter as follows publishPerformanceCounters=”false” or delete the property from the configuration and restart the services.
Review the available internal SQLDM PerfMon counters list for the SQLdmManagementService and SQLdmCollectionService: Internal SQLDM perfmon counters.