Tag Archives: SharePoint Diagnostic Studio

No Usage and Health data available

Problem

You enable the Usage and Health Data collection service but no data is displayed when you try to access it via SharePoint Diagnostic Studio.

Solution

Check that the Health Logging Schedule and Log Collection Schedule jobs are not disabled.

  1. Open Central Administration -> Monitoring -> Reporting -> Configure usage and health data collection
  2. Click on Health Logging Schedule followed by Log Collection Schedule

The jobs that you want to ensure are not disabled are:

Comments ( 0 )

SharePoint Diagnostic Studio not displaying reports

Problem

Your region / date format is not in the US format, i.e. dd/MM/yyyy and find that SharePoint Diagnostic Studio is unable to display charts in reports.

Solution

To fix this problem, I had to change the date format to English (United States) – MM/dd/yyyy.

Comments ( 0 )

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 (ms)" -DatabaseServer 
Add-SPDiagnosticsPerformanceCounter -Category "NIC" -Counter "Bytes Total/sec" 
Add-SPDiagnosticsPerformanceCounter -Category "LogicalDisk" -Counter "Avg. Disk Queue Length" -Instance "_Total" 
Add-SPDiagnosticsPerformanceCounter -Category "LogicalDisk" -Counter "Disk Writes/sec" -Instance "_Total" 
Add-SPDiagnosticsPerformanceCounter -Category "LogicalDisk" -Counter "Disk Reads/sec" -Instance "_Total" 
Add-SPDiagnosticsPerformanceCounter -Category "Memory" -Counter "Cache Faults/sec" 
Add-SPDiagnosticsPerformanceCounter -Category "Memory" -Counter "Pages/sec" 
Add-SPDiagnosticsPerformanceCounter -Category "ASP.NET" -Counter "Request Wait Time"

Give it some time and try running the reports again.

Comments ( 0 )

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.

Comments ( 0 )