Performance Metrics for SharePoint
Monitor and keep a check on SharePoint's server metrics, services, queued requests, and its overall health - all in one console. The SharePoint monitor uses the Site24x7 Windows agent for monitoring. Install the Windows agent and get your SharePoint servers auto-discovered.
Supported versions: 2007, 2010, 2013, and 2016
Once the SharePoint server monitor is successfully added to your Site24x7 account,
- View performance metrics for SharePoint monitors. Log in to Site24x7 and go to Server > Microsoft SharePoint Server.
- Add a Threshold and Availability profile to declare a specific resource as critical or down.
- Analyze trends and identify performance issues with exclusive performance reports.
- View key metrics in a single glance with the inventory and health dashboards, or create your own.
Interpret SharePoint Performance Metrics
- Monitor Overview: Lists down information on the SharePoint server details, along with graphical data on apps, access, and excel requests per second
- Web Transactions: Gives the status of the various web applications on the SharePoint server with its associated content databases
- Content DB: Data on the various content databases are given
- Service Applications: Various service applications on the SharePoint server are given
- Service Instance: Parameters related to every service instance is noted under this section
- Office: Metrics for monitoring the office app are given
- Excel Service: Metrics for monitoring the excel service are provided
- Access Service: Metrics for monitoring the access service are listed
- Search Trends: Available only for SharePoint versions 2013 and 2016. Metrics showing the search trends are provided.
Monitor Overview
| Parameters | Description |
| SharePoint Server Details | Gives us details on the host name, IP address, successful/failed timer jobs and the version of the SharePoint server |
| Access Requests per second | Requests per second to the Access Service at sampling time |
| SharePoint Services | Status of all the SharePoint Windows services |
| Apps Requests per second | The total number of requests to the Application Services executed per second |
| Excel Requests per second | The number of requests received on Excel Calculation Services per second between sampling times |
Web Transactions
| Parameters | Description |
| Application Name | Name of the web application |
| URL | The url for that particular application is listed |
| Status | Tells us if the web application is online or offline |
| Action | Configure threshold for a particular web application |
Content DB
| Parameters | Description |
| DB Name | Name of the content database |
| Application Name | Name of the application that use the database |
| Current Site Count | The number of current sites stored in the database |
| Warning Site Count | The number of site count before a warning is created |
| Max Site Count | The maximum number of site collections in the database |
| Disk Size Required (GB) | The size allocated by the database on the disk in GB |
| Status | Tells us if the content database is online or offline |
Service Applications
| Parameters | Description |
| InfoPath Form Services: | |
| Average Session Duration | The average time taken to complete a form filling session |
| Data Connection Submit Failure Rate | The failure rates of the data connections during the form filling sessions |
| Form Filling Session Completed Rate | The rate at which the form filling sessions are completed |
| Transaction Completed Rate | The rate at which the transactions are completed in a form filling session |
| ASP Stats: | |
| Current Sessions | The number of current sessions being serviced |
| Transactions Started per second | The total number of transactions started per second |
| Pending Transactions | The number of pending transactions |
| Requests/second | The total number of requests executed per second |
| Requests in Queue | The total number of requests waiting from the queue for service |
| Rejected Requests | The total number of rejected requests due to insufficient resources |
| Errors per second | The total number of errors occurring per second |
| Visio Web Access: | |
| Request Processing Time | The time taken for processing a request to Excel web front end component |
| Requests/second | The total number of requests reaching the Excel web front end component per second |
| Error Requests per sec | The number of requests returned due to errors |
| Publishing Cache Stats: | |
| Cache Hit Ratio | The ratio of hits to misses on the publishing cache |
| Cache Misses per second | The miss rate on the publishing cache |
| Cache Flushes per second | The update rate of the cache due to site changes |
| Total Object Discards | The total number of items removed due to cache compaction from the publishing cache |
Service Instance
| Parameters | Description |
| Instance Name | Name of the service instance |
| Status | The status of the service instance |
| Action | Configure threshold to get alerts when the service instance goes Down |
Office
| Parameters | Description |
| Office Server Search Gatherer Stats: | |
| Idle Threads | The number of threads waiting for the documents |
| Threads Waiting for Plugin | The number of threads waiting for plugins to complete an operation |
| Threads Accessing Network | The number of threads awaiting a response from the filter process |
| Active Queue Length | The number of documents waiting for robot threads |
| Server Objects | The number of servers accessed by the system recently |
| Delayed Documents | The number of documents delayed |
| Office Server Search Archival Plugin: | |
| Committing Queues | The number of queues currently undergoing changes and completing uploads |
| Filter Thread Queues | The number of queues currently used by the filter threads |
| Available Upload Queues | The queue that is currently active |
| Queues Waiting | The current number of queues waiting to send data to the property store |
| Active Bulk Insert Sessions to DB | The number of active bulk insert sessions to be sent to the database server |
| Documents Marked for Retry | The number of marked documents for retry by the plugin |
| Documents Waiting for Queue | The number of documents waiting to be queued |
| Total Documents Processed | The total number of documents used in the first queue |
| Office Server Search Indexer Catalog: | |
| Index Size | Size of index |
| Documents Filtered | Numner of documents filtered |
| Queries Succeeded | Number of queries succeeded |
| Queries Failed | Number of queries failed |
| Total Queries | Total number of queries |
| Office Server Search Schema Plugin: | |
| Total Documents Processed | The total number of documents processed |
| Total Properties Processed | The total number of properties processed by the plugin |
| Loaded Aliases | The number of currently loaded aliases |
| Mapped Aliases | The number of aliases mapped |
| Ignored Duplicate Aliases | The number of aliases ignored due to duplicity |
| Alias Refresh Count | The number of refreshed aliases from the database |
Excel Service
| Parameters | Description |
| Excel Calc Requests and Session | The number of acitve requests, sessions, and chart requests per second for Excel Calculation Service |
| FrontEnd Requests per sec | The number of requests being processed by Excel Calculation Services at sampling time |
Access Service
| Parameters | Description |
| Average Request Duration | Average time in seconds to request data |
| Failed Access Requests per sec | The number of access requests failed per second |
| Access Service - Data Access Layer: | |
| Get Data Requests per sec | The number of data query requests per second |
| Insert Requests per second | The number of insert requests that are active |
| Update Requests per second | The number of update requests per second |
| Delete Requests per second | The number of delete requests per second |
| Failed Insert Requests per second | The number of insert requests that failed per second |
| Failed Delete Requests per second | Number of failed delete requests that failed per second |
| Average Data Fetch Duration | Average time in seconds to retrieve data |
| Average Insert Duration | Average time in seconds to insert data |
| Average Update Duration | Average time in seconds to update data |
| Average Delete Duration | Average time in seconds to delete data |
| Access Service - Application Server: | |
| Active Sessions | The number of sessions active by Excel Calculation Services at sampling time |
| Active Requests | The number of requests actively processed by Excel Calculation Services at sampling time |
Search Trends
This tab would be visible only for SharePoint versions 2013 and 2016.
| Parameters | Description |
| Search Gatherer: | |
| Search Threads in Plugin | The number of threads waiting for the plugins to complete an operation |
| Search Documents Delayed | The number of documents that are delayed due to site hit frequency rules |
| Search Server Objects | The number of servers recently accessed by the system |
| Filtered Search Threads | The total number of filtering threads in the system. This is calculated based on the system resources |
| Documents Filtered Rate | The number of documents filtered per second |
| Idle Threads | The number of threads waiting for documents |
| Search Gatherer Projects: | |
| Crawls in Progress | The number of crawls in progress |
| Deleted Documents | The number of delete notifications |
| Error Rate of Documents | The number of filtered documents which returned an error per second |
| Processed Rate of Documents | The number of documents processed per second |
| Success Rate of Documents | The number of successfully filtered documents per second |
| Retries | The total number of times a document access has been retried. Having a higher value indicates an issue with accessing data |
| Rate of Retries | The number of retries per second |
| Search Host Controller: | |
| Restarted Components | The number of restarts of a search component since the start of the host controller |
| Component Uptime | Component uptime in minutes since the start of the host controller |
| Search Gatherer Content Plugin | Displays metrics including the number of documents lost, failed, the average document count, and the timeout exceptions |
| Search Index: | |
| Bad Content Messages | The number of unparsable messages delivered to indexing |
| Bad Query Messages | The number of unparsable messages delivered to querying |
| Search Index Router: | |
| Indexing Rate | The average number of documents indexed per second over the last minute |
| Indexing Blocked | The total time (in ms) when indexing has been blocked, waiting for checkpoint to complete |
Related Articles
- Add a SharePoint server
- Other supported Microsoft applications
- Add a Windows monitor
- Server monitoring architecture
- Other OS platforms supported: Linux | FreeBSD | OS X
- Troubleshooting Tips