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 and 2016

Prerequisites for monitoring Microsoft 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:

  1. Click on New Monitor link.
  2. Select MS Office SharePoint.
  3. Give the Display Name.
  4. Enter the Hostname of the host where Office SharePoint Server runs.
  5. Select the Version of Microsoft Office SharePoint Server - 2007, 2010, 2013 or 2016.
  6. Choose the Features to be monitored for the different versions (Click on the Features textbar to display a drop-down features menu).
  7. To use powershell for data collection, tick the Use Powershell checkbox. Checking this option will display Installation Type option:
    • 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.
  8. 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.
  9. Enter the Username and Password for the server.
  10. Set the Poll interval.
  11. If you are adding a new monitor from an Admin Server, select a Managed Server.
  12. 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.
  13. Click Add Monitor(s). This discovers MS Office SharePoint server from the network and starts monitoring them.

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

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.

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, 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, 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)

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.