SharePoint Diagnostic Studio SQL Overview Report Missing Performance Counters
Problem
You view the SQL Overview Report in SharePoint Diagnostic Studio and get the following message:
It appears the Performance Counter diagnostic providers have not been provisioned. Please provision them to view this report.
Solution
You need to provision the required performance counters. This can be done using PowerShell.
Run the following commands in order:
Add-SPDiagnosticsPerformanceCounter –category SQLServer:Locks –counter "Average Wait Time (ms)" –allinstances -databaseserver Add-SPDiagnosticsPerformanceCounter –category LogicalDisk –counter "Disk Reads/sec" –allinstance -databaseserver Add-SPDiagnosticsPerformanceCounter –category LogicalDisk –counter "Disk Writes/sec" –allinstance –databaseserver |
Restart the SharePoint Timer Service on your SharePoint servers.
Restart SharePoint Diagnostic Studio
You should now be able to view the SQL Overview Report without getting any errors.