Microsoft Office SharePoint Servers

Office SharePoint - Overview

Applications Manager provides comprehensive monitoring for key SharePoint performance indicators. Monitor underlying server resources for CPU, memory, and disk constraints as well as SharePoint services, requests queued and infrastructure performance for virtual machines and server hardware health. The monitoring details of Microsoft Office SharePoint Servers are represented graphically that helps to understand the parameters with ease. Administrators can configure thresholds to the attributes monitored, pinpoint and fix problems before users notice performance issues.

Office SharePoint - Adding a new monitor

Microsoft Office SharePoint Server Versions Supported: 2007, 2010, 2013, 2016, and 2019

Prerequisites for monitoring Microsoft Office SharePoint Server: Click here to know the prerequisites for monitoring MS Office SharePoint server. To use Powershell for data collection, make sure the proper steps have been followed to enable powershell remoting.

Attributes Monitored: Refer SharePoint Server Parameters to know more about the attributes monitored.

To create a Office SharePoint Server Monitor, follow the steps given below:

Click on New Monitor link.
Select MS Office SharePoint.
Give the Display Name.
Enter the Hostname of the host where Office SharePoint Server runs.
Select the Version of Microsoft Office SharePoint Server - 2007, 2010, 2013, 2016 or 2019.
Choose the Features to be monitored for the different versions (Click on the Features textbar to display a drop-down features menu).
Select the Mode of Monitoring as either Powershell or WMI.
While choosing Powershell as mode of monitoring, you can select Use CredSSP Authentication option to delegate the users credentials from one computer to another remote computer.
While choosing Powershell mode for data collection, select the Installation Typefrom the below options:
- SharePoint Farm Server: Select this option if server has Farm setup. If the monitor is added as a SharePoint Farm Server setup, Applications Manager will discover all other servers in the farm and will add them automatically as separate monitors. A monitor group will be created for the farm and all discovered monitors will be added in the monitor group with the name same as the Farm name. PowerShell is required for discovering servers in the farm.
- SharePoint Server: Select this option if server has Stand-Alone setup.
You can enter your own credential details or select preconfigured credentials details in Credentials Manager. If you wish to enter your own credentials, specify username and password details for this monitor.
Enter the Username and Password for the server.
Provide the Timeout period. By default, it is 300 seconds.
Set the Poll interval.
If you are adding a new monitor from an Admin Server, select a Managed Server.
Choose the Monitor Group from the combo box with which you want to associate MS Office SharePoint server (optional). You can choose multiple groups to associate your monitor.
Click Add Monitor(s). This discovers MS Office SharePoint server from the network and starts monitoring them.

Note: Monitoring of SharePoint server is possible only if Applications Manager is running on a Windows system. The SharePoint server monitor supports data collection in two ways:

WMI
- For users who have not installed/do not require Powershell
- To choose this mode, select the WMI Mode of Monitoring in the new monitor page.
- The metrics under the SharePoint Services, Web Applications, Databases, and Timer Jobs tabs are not available for this setting.
Powershell
- In the new monitor page, choose the Powershell Mode of Monitoring.
- To use Powershell for data collection make sure the proper steps have been followed to enable powershell remoting.

Monitored Parameters

Go to the Monitors Category View by clicking the Monitors tab. Click on MS Office SharePoint under the Middleware/Portal Table. Displayed is the MS Office SharePoint bulk configuration view distributed into three tabs:

Availability tab gives the Availability history for the past 24 hours or 30 days.
Performance tab gives the Health Status and events for the past 24 hours or 30 days.
List view enables you to perform bulk admin configurations.

Click on the monitor name to see all the server details listed under the following tabs:

Performance Overview
SharePoint Services
Web Applications
Databases
Timer Jobs
Access Services
Visio Web Access Services
InfoPath Services
Excel Services (For Versions 2007, 2010 and 2013)
Office Search Gatherer (For Versions 2007, 2010 and 2013)
Search Services (For Version 2016 and 2019)

Performance Overview

Parameter	Description
Active Server Pages
Errors/sec	The total number of errors per second including runtime, preprocessor and script compilation errors.
Requests Queued	The number of requests waiting for service from the queue.
Requests Rejected	The total number of requests not executed due to insufficient resources.
Requests/sec	The number of requests executed per second.
Current Sessions	The current number of sessions being serviced.
Transactions/sec	Transactions started per second.
Pending Transactions	The number of transactions still in progress.
Server Stats
Free Memory in MB	The physical memory available for allocation.
Page Faults Per Sec	The number of times that data was not found in memory per second.
Percentage of Committed Bytes In Use	The ratio committed to commit limit.
Percentage of Processor Time	The percent processor time.
SharePoint Server Services
Service Name	The name of the SharePoint Server Service.
Status	The status of the service.
Availability	The availability status of the service
Office Search Archival Plugin (For Versions 2010 and 2013)
Queries Commiting	The current number of queues that are committing changes and completing uploads.
Queues Filtering	The current number of queues that are being used by the filter threads.
Queues Waiting	The current number of queues that are waiting to flush data to the property store.
Retried Microsoft Office SharePoint Serverss	The number of documents which were marked for retry from the plugin.
Total Microsoft Office SharePoint Serverss	The total number of documents which have used the first queue.
Blocked Microsoft Office SharePoint Serverss	The number of documents waiting for a queue.
Active Queue	The currently active queue.
Bulk Insert Sessions	The number of active bulk insert sessions to the database server.
Office Search Archival Plugin (For Version 2007)
Active Docs in First Queue	The number of documents actively using the first queue.
Total Docs in First Queue	The total number of documents which have used the first queue.
Active Docs in Second Queue	The number of documents actively using the second queue.
Total Docs in Second Queue	The total number of documents which have used the second queue.
Total Microsoft Office SharePoint Serverss	The number of documents processed.
Error Microsoft Office SharePoint Serverss	The number of documents which returned errors from the plug-in.
Active Queue	The currently active queue.
Bulk Insert Sessions	The number of active bulk insert sessions to the database server.
Web Content Management-Publishing Cache
Publishing Cache Hit Ratio	The ratio of hits to misses on the Publishing cache.
Total Object Discards	The total number of items that have been removed from the Publishing cache due to cache compaction.
Publishing Cache Hits / sec	The hit rate on the Publishing cache.
Publishing Cache Misses / sec	The miss rate on the Publishing cache.
Publishing Cache Flushes / sec	The rate that we are updating the cache due to site changes.

SharePoint Services

Parameter	Description
SharePoint Services
Name	The name of the SharePoint service.
Status	The status of the SharePoint service; indicates if it is online or offline.

Web Applications

Parameter	Description
SharePoint Web Applications
DisplayName	The display name of the web application.
URL	The URL to access the web application.
Content database	The number of Content Databases processed during profile synchronization.
Jobs Succeeded	The number of timer jobs succeeded related to the web application
Jobs Failed	The number of timer jobs failed related to the web application
Status	The status of the web application; indicates if it is online or offline.

Databases

Parameter	Description
SharePoint Content Databases
Name	The name of the content database
Server	The server in which the database is stored
Disk Size Required (GB)	The size allocated by the database on disk
Web Application	The web applications which use the database
Current Site Count	The number of sites that are stored in the database
Status	The status of the content database; indicates if it is online or offline

Timer Jobs

Parameter	Description
Timer Jobs
Jobs Succeeded	The total number of timer jobs succeeded
Jobs Failed	The total number of timer jobs failed
SharePoint Failed Timer Jobs
DisplayName	The name of the timer job
Status	The status of the content database (online or offline).
LastRunTime	The last time when the timer job was executed
ErrorMessage	The error due to which the timer job failed.

Access Services

Parameter	Description
Access Data Services Applications Server
Active Requests	The total number of active requests being processed by Excel Calculation Services at sampling time.
Active Sessions	The number of active sessions by Excel Calculation Services at sampling time.
Average Request Processing Time	The average processing time for a request by Excel Calculation Services between sampling times.
Access Services Data Access Layer
Average Data Fetch Duration	The average time (in seconds) that is spent to retrieve data.
Average Delete Duration	The average time (in seconds) that is spent to delete data.
Average Insert Duration	The average time (in seconds) that is spent to insert data.
Average Update Duration	The average time (in seconds) that is spent to update data.
Failed Insert Requests / sec	The current number of insert requests that failed per second.
Failed Delete Requests / sec	The current number of delete requests that failed per second.
Get Data Requests / sec	The current number of data query requests per second.
Delete Requests / sec	The current number of delete requests per second.
Insert Requests / sec	The current number of insert requests that are active.
Update Requests / sec	The current number of update requests per second.

Visio Web Access Services

Parameter	Description
Visio Web Access Services
Request Processing Time	The average processing time for a request to Excel Web Front End component. Large value indicates high response time.
Requests Received / Sec	The total number of requests per second to Excel Web Front End component.
Requests with Errors / Sec	The number of requests that are returned with errors. Higher rate of errors indicate unexpected behavior of an Excel Calculation Services that directly affects the performance.

InfoPath Services

Parameter	Description
Infopath Forms Services
Average Session Duration	The average time to complete a form-filling session, summed up over all transactions in the form-filling session.
Data Connection Submit Failure Rate	The rate of failures for data connection submits in form-filling sessions.
Session Completed Rate	The rate at which form-filling sessions completed.
Transactions Completed Rate	The rate at which transactions completed in form-filling sessions.

Excel Services (For Versions 2007, 2010 and 2013)

Parameter	Description
Excel Services Web Frontend
Active Requests - Excel Web FrontEnd	The number of active requests being processed on Excel Calculation Services at sampling time
Requests Per Second	The number of requests received per second on Excel Calculation Services between sampling times
Excel Webaccess
Excel Web Access Request Time	The Excel Web Access Average Request time between the last two samples
Chart Image Requests per Second	The number of requests for chart images served by Excel Web Access per second
Average Chart Image Request Time	The average time it takes between the request for a chart image and the issuance of the response to the web browser by Excel Web Access
Excel Calculation Services
Requests With Errors / Sec - Excel Calculation	The number of requests that are returned with errors per second on Excel Calculation Services between sampling times
Sessions Per Second	The average number of sessions opened per second between the last two samples
Cached Charts Requested Per Sec	The number of charts that are provided from a cached image
Active Sessions	The number of active sessions on Excel Calculation Services at sampling time
Rendered Charts Requested Per Sec	The number of chart requests per second
Active Requests	The number of active requests being processed on Excel Calculation Services at sampling time
Requests Received per Sec	The number of requests received per second on Excel Calculation Services between sampling times

Office Search Gatherer (For Versions 2007, 2010 and 2013)

Parameter	Description
Office Search Gatherer
Delayed Microsoft Office SharePoint Serverss	The number of documents delayed due to site hit frequency rules.
Threads Accessing Network	The number of threads waiting for a response from the filter process.
Idle Threads	The number of threads waiting for documents.
Microsoft Office SharePoint Serverss Delayed Retry	The number of documents that will be retried after time-out.

Search Services (For Version 2016 and 2019)

Parameter	Description
Office Search Gatherer
Delayed Microsoft Office SharePoint Serverss	The number of documents delayed due to site hit frequency rules.
Threads Accessing Network	The number of threads waiting for a response from the filter process.
Idle Threads	The number of threads waiting for documents.
Microsoft Office SharePoint Serverss Delayed Retry	The number of documents that will be retried after time-out.
Search Query Processor
Query Client Failures	The number of client failures per second.
Query Consecutive Failures	The number of consecutive query failures per second.
Query Direct Probe Failures	The number of Probe Failures per second.
Query Load Balancer Errors	The number of Load Balancer Errors per second.
Query Load Balancer Retries	The number of Load Balancer Retries per second.
Query Network Failures	The number of Network Failures per second.
Query Server Failures	The number of Server Failures per second.

Note: To fetch data in the following tabs 'Web Applications', 'Databases', 'Timer Jobs' & 'SharePoint Services', make sure you have selected the Use Powershell checkbox when adding the monitor. Data for these tabs cannot be collected using 'WMI' mode. To view the above said tabs for an existing monitor, click Edit Monitor and select the Use Powershell option for datacollection. For more help on enabling Powershell Remoting, click here.