Data Collection: Troubleshoot data collection issues in MS Office SharePoint monitor

Data Collection: Troubleshoot data collection issues in MS Office SharePoint monitor

Notes
Note: Before troubleshooting, ensure that you have met all the required prerequisites for the SharePoint Server monitor.

Troubleshooting no data collected for some or all metrics in the SharePoint Server monitor

If no data is collected for some or all metrics in the SharePoint Server monitor, follow the steps based on the data collection mode:
  1. WMI mode: Use the Self Help tools or the troubleshooting bat file to verify if data is being collected properly. Refer to this KB for detailed instructions.
  2. PowerShell mode: Run the PowerShell scripts manually to check if they return data. Refer to this KB for more information.

Error: "Unable to collect data ------- Reason: Timeout exceeded during script execution"

This typically occurs in the SharePoint Server monitor configured in PowerShell mode, when the script to be executed or the individual command takes too long to be executed.
To troubleshoot this error, use the following Measure-Command to determine how much time the script or command is taking to run:
Quote
Syntax:
            Measure-Command{ <script-or-command> }
Example - Full Script:
            Measure-Command{ .\SPMaster.ps1 'hostname' 'username' 'password' 'WebApplication,TimerJobs,ContentDB,SharepointServices' 'CredSSP' }
Example - Individual Command:
            Measure-Command{ Invoke-Command -Session $session -ScriptBlock{ Get-SPServiceInstance } }
Upon receiving the results:
  1. Note the total execution time.
  1. Go to the SharePoint Server monitor settings in Applications Manager.
  1. Adjust the Polling Interval and Timeout value to allow sufficient time.

Error: "Unable to collect data for SharePoint Service / Web Applications / Databases / Timer Jobs"

This error indicates that data collection failed for specific SharePoint metrics.
Refer to the steps mentioned in this KB to run the individual data collection script or execute specific PowerShell commands to verify data availability.

Error: "Unable to create remote PowerShell session":
This error usually occurs when a remote session to the SharePoint Server cannot be established.
  1. Ensure all the prerequisites are met.
  2. Refer to this KB for the verification steps and the scripts to run for collecting metrics affected by this issue.