Atc Database Test

This test reports statistics relating to the authentication database, which is a SQL database that contains data used in processing requests and responses. The authentication database consists of authentication data and authorization data, though there is no direct sharing of tables.

Target of the test : The TP server

Agent deploying the test : An internal agent

Outputs of the test : One set of outputs for every authentication database that is monitored.

Configurable parameters for the test
Parameter Description

Test period

How often should the test be executed

Host

The host for which the test is to be configured.

Port

Refers to the port at which the specified host listens to.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Average ADO response time

Indicates the average ADO response time over the last minute.

Secs

A significant increase in the value of this measure denotes a slowdown of the ATC database.

Average connections used

Indicates the average number of database connections used in the last minute.

Number

 

Database pool size

Indicates the number of connections that are available in the DBManager Connection Pool to execute transactions through ADO.

Number

Compare the pool size with the connections in use. If the connections is use approaches the pool size, you may want to resize the pool.

Pool availability

Indicates whether the pool is available or not.

Percent

If the value of this measure is 0, it indicates that the pool is not available. The value 100, on the other hand, indicates that the pool is available.

Request execution rate

Indicates the rate of requests currently being executed through ADO.

Reqs/Sec

 

Requests waiting rate

Indicates the rate at which requests are waiting to get executed.

Reqs/Sec

Ideally, this value should be close to 0. An increase in requests waiting for database execution could result in the login process being slow.

Error rate of SQL queries to ATC DB

Indicates the number of SQL errors thrown per second.

Errors/Sec

 

Average transaction response time

Indicates the average transaction response time during the last minute.

Secs