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:
| Code Block | ||||
|---|---|---|---|---|
|
...
<configuration> |
...
<Idera.SQLdm> |
...
<Services> |
...
<CollectionService |
...
instanceName="Default" managementServiceAddress="ServerName" |
...
publishPerformanceCounters="true"/> |
...
</Services> |
...
</Idera.SQLdm> |
...
</configuration> |
| Code Block | ||||
|---|---|---|---|---|
|
...
<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. |
| Info |
|---|
Review the available internal SQLDM PerfMon counters list for the SQLdmManagementService and SQLdmCollectionService: Internal SQLDM perfmon counters. |