Page History
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
...
- Open SQLdmManagementService.exe.
...
- Config or SQLdmCollectionService.exe.
...
- Config as Administrator (depending on which SQLDM Performance Counters you want to enable)
...
- Edit it
...
- and add the following parameter publishPerformanceCounters=”true” and restart the services.
Review the following examples as following for example:
| Code Block | ||||
|---|---|---|---|---|
| ||||
<configuration> <Idera.SQLdm> <Services> <CollectionService instanceName="Default" managementServiceAddress="ServerName" publishPerformanceCounters="true"/> </Services> </Idera.SQLdm> </configuration> |
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
<configuration>
<Idera.SQLdm>
<Services>
<ManagementService |
<configuration>
<Idera.SQLdm>
<Services>
<CollectionService
instanceName="Default" managementServiceAddress="ServerName"
publishPerformanceCounters="true"/>
</Services>
</Idera.SQLdm>
</configuration>
SQLdmManagementService.exe.config file
<configuration>
<Idera.SQLdm>
<Services>
...
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. |
| Info |
|---|
Review the available internal SQLDM PerfMon counters list for the SQLdmManagementService and SQLdmCollectionService: Internal SQLDM perfmon counters. |