SharePoint Foundation Test

Microsoft SharePoint Foundation is the essential solution for organizations that need a secure, manageable, web-based collaboration platform. It serves as the basis for SharePoint server and offers out of the box elements such as blogs, wikis, team workspaces, and document libraries, providing users with the ideal way to share information and collaborate within a customized website. In addition, it provides services such as Business Data Connectivity services to integrate external data, basic search services and workflow services.

This test auto-discovers the SharePoint processes, and for each process, reports the workload on the process and how efficiently that process handles the load. This way, the test leads you to the processes that are very busy and provides pointers to what could be keeping them busy.

Note:

This test will report metrics only if SharePoint Foundation is available on the target SharePoint server.

Target of the test : A Microsoft SharePoint Server

Agent deploying the test : An internal/remote agent

Outputs of the test : One set of results for each SharePoint Foundation process

Configurable parameters for the test
Parameters	Description
Test period	This indicates how often should the test be executed.
Host	The host for which the test is to be configured.
Port	The port at which the host server listens.

Measurements made by the test
Measurement	Description	Measurement Unit	Interpretation
Active threads	Indicates the number of threads that are currently executing in SharePoint code of this process.	Number	Many active threads is an indicator of a bottleneck.
Incoming page requests	Indicates the number of incoming requests to access a particular page in the last second.	Number	This measure is a good indicator of the workload on this process.
Requests being processed currently	Indicates the requests that are currently processed by this SharePoint process.	Reqs
Avg execution time of requests processed	Indicates the average time taken by this process for executing the requests that are processed in the last second.	Secs	Ideally, this value should be low. If the value of this measure increases steadily, then it indicates a performance bottleneck.
Requests rejected	Indicates the number of page requests that were rejected by this process during the last second.	Number	Ideally, the value of this measure should be zero.
Requests responded to by the SharePoint server	Indicates the number of page requests that were responded by this SharePoint process during the last second.	Number
Throttled page requests	Indicates the number of page requests that have been throttled by this process during the last measurement period.	Number
Executing SQL queries	Indicates the number of SQL queries that are currently executing on this SharePoint server.	Number
Query execution time	Indicates the average time taken by this SharePoint server to execute the SQL queries.	Secs	If the time taken to execute a query is high, it indicates that the query is unoptimal or there may be a database slowdown.
Native heaps in use	Indicates the number of native heaps that are currently in use by this SharePoint process.	Number
Native heaps allocated by process	Indicates the number of native heaps that are allocated by this SharePoint process.	Number
Global heap size	Indicates the size of the global heaps that are used by this SharePoint process for cache related activity.	MB
Size of all per thread native heaps	Indicates the size of the native heaps that are used by all the threads that are being executed by this SharePoint process.	MB