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:
| Code Block |
|---|
| language | text |
|---|
| title | SQLdmCollectionService.exe |
|---|
|
<configuration>
<Idera.SQLdm>
<Services>
<CollectionService
instanceName="Default" managementServiceAddress="ServerName"
publishPerformanceCounters="true"/>
</Services>
</Idera.SQLdm>
</configuration> |
| Code Block |
|---|
| language | text |
|---|
| title | SQLdmManagementService.exe |
|---|
|
<configuration>
<Idera.SQLdm>
<Services>
<ManagementService instanceName="Default"
repositoryServer="SQLInstanceName\Name"
servicePort="5166" repositoryDatabase="SQLdmRepositoryName"
publishPerformanceCounters="true"/>
</Services>
</Idera.SQLdm>
</configuration> |
| Note |
|---|
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. |