SharePoint Diagnostic Studio Performance Counters missing

Problem You install and configure SharePoint Diagnostic Studio and realise that some counters are missing. You may also get the failure message: Performance counter not found Solution Open SharePoint Management Shell and run the following commands: Add-SPDiagnosticsPerformanceCounter -Category "SQLServer:Locks" -Counter "Lock Wait Time (ms)" -Instance "_Total" -DatabaseServer Add-SPDiagnosticsPerformanceCounter -Category "SQLServer:Latches" -Counter "Average Latch Wait Time […]

Continue Reading...

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: […]

Continue Reading...