SQL Analysis Processing Test

Processing bottlenecks are a deterrent to the peak performance of the SQL Analysis Services server. It is therefore important that administrators capture a processing delay, before users notice and complain. This is where the SQL Analysis Processing test!

This test reports the rate at which the SSAS server reads, writes, and converts rows when processing. In the process, the test warns administrators of potential processing bottlenecks, and pinpoints where such delays are more pronounced - when reading? writing? or converting rows?

Target of the test : A Microsoft SQL Analysis Services Server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for the SSAS server being monitored

Configurable parameters for the test
Parameters Description

Test Period

How often should the test be executed.

Host

The host for which the test is to be configured.

Port

The port at which the specified Host listens.

Instance

The name of a specific SQL Analysis Services Server instance to be monitored. The default value of this parameter is “default”. However, if the Microsoft SQL Server hosting SSAS uses named instances, then do the following:

  • Configure the Instance parameter with the name of the SQL Server instance that hosts SSAS.

  • Do not change the default value of the Port parameter

SSAS Version

Specify the SSAS version being monitored. By default, 11 is displayed here, indicating that version 11 of SSAS is monitored by default.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Rows read

Indicates the total number of rows read during processing.

Number

 

Rows written

Indicates the total number of rows written during processing.

Number

 

Rows Converted

Indicates the total number of rows that were converted during processing.

Number

 

Rows read rate

Indicates the rate at which rows were read.

Reads/Sec

In the event of a process slowness, compare the values of these measures to know what is delaying processing.

 

 

Rows written rate

Indicates the rate at which rows were written.

Writes/Sec

Rows converted rate

Indicates the rate at which rows were converted.

Number/Sec