Follow these steps to enable SQL Diagnostic Manager Performance Counters:

  1. Go to the SQLDM installation folder 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 following parameter publishPerformanceCounters=”true” and restart the services.

Review the following examples:

SQLdmCollectionService.exe
<configuration>
<Idera.SQLdm>
<Services>

<CollectionService
instanceName="Default" managementServiceAddress="ServerName"
publishPerformanceCounters="true"/>

</Services>
</Idera.SQLdm>
</configuration>
SQLdmManagementService.exe
<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.

IDERA |  Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels