Updated March 11th, 2016
Some of the SQL Server database resource metrics require access to the WMI performance counters on the server running the monitored SQL Server instance. There are a number of configuration issues which can prevent access to these counters by DPA.
All DPA versions
The account running the SQL Server intance must have the necessary permissions to access the WMI counters in the root\cimv2 namespace. The user must have at least the Execute Methods and Enable Account permissions.
After modifying these privileges, it may be necessary to restart the Windows Management Instrumentation service.
1. Enable WMI counters.
The SQL Server database resource metrics rely on two WMI performance counters: PerfOS and PerfDisk. You must enable these counters for DPA to access the necessary resource data. You can check if these counters are disabled by using the Extensible Performance Counter List tool from Microsoft.
2. Select the counters named PerfOS and PerfDisk in the Extensible Performance Counters list. If the Performance Counters Enabled check box is not checked, then the counter is disabled.
You can also check if these counters are disabled using the Registry Editor.
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\PerfDisk\Performance\Disable Performance Counters = 0x1
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\PerfOS\Performance\Disable Performance Counters = 0x1
The 0x1 value means disabled. If this key is not present, or is set to 0x0, then the counter is enabled.
3. Run SQLServer and SQLAgent under a domain account.
When running SQLServer and SQLAgent Windows services under a domain account:
After making these changes, restart the SQL Server and SQL Agent services.