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.

Tags:

No comments yet.

Leave a Reply

%d bloggers like this: