Page History
Follow these steps to enable SQL Diagnostic Manager Performance Counters:1.
- Go to the
...
- SQLDM installation 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 publishPerformanceCounters=”true” 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>
<CollectionService
instanceName="Default" managementServiceAddress="ServerName"
publishPerformanceCounters="true"/>
...
|
...
<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 DM Performance Counters, set |
...
publishPerformanceCounters=”false” or just delete the property from the |
...
configuration and restart the services. |