Follow these steps to enable SQL Diagnostic Manager Performance Counters:
1. Go to the DM installation path: C:\Program Files\Idera\Idera SQLdiagnostic manager
2. Open SQLdmManagementService.exe.config or SQLdmCollectionService.exe. config as Administrator (depending on which SQLDM Performance Counters you want to enable)
3.Edit it, and add the publishPerformanceCounters=”true” as following for example:
<configuration> <Idera.SQLdm> <Services> <CollectionService instanceName="Default" managementServiceAddress="ServerName" publishPerformanceCounters="true"/> </Services> </Idera.SQLdm> </configuration>
SQLdmCollectionService.exe.config file
<configuration>
<Idera.SQLdm>
<Services>
<CollectionService
instanceName="Default" managementServiceAddress="ServerName"
publishPerformanceCounters="true"/>
</Services>
</Idera.SQLdm>
</configuration>
SQLdmManagementService.exe.config file
<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 DM Performance Counters, set
publishPerformanceCounters=”false” or just delete the property from the
configuration and restart the services.