Excel Services Web Front End Test

The core components of Excel Services - the Excel Web Access, Excel Web Services, and Excel Calculation Services components - can be divided into components on the Web front-end server and those that live on a back-end application server. The Web front end includes Excel Web Access and Excel Web Services.

Excel Web Services is the Excel Services component that provides programmatic access to its Web service. You can develop applications that call Excel Web Services to calculate, set, and extract values from workbooks, as well as refresh external data connections. Using Excel Web Services, you can incorporate server-side workbook logic into an application, automate the updating of Excel workbooks and create application-specific user interfaces around server-side Excel calculation.

Using the Excel Services Web Front End test, you can track the number and rate of requests to the Excel Web Services component.

Note:

This test will report metrics only if Excel Web Services component is available on the target SharePoint server.

Target of the test : A Microsoft SharePoint Server

Agent deploying the test : An internal agent

Outputs of the test : One set of results each for the Microsoft SharePoint server that is being monitored

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 requests

Indicates the current number of requests to the Excel Web Services component.

Number

 

Requests rate

Indicates the rate at which requests were received by the Excel Web Services component.

Requests/Sec