ASP SQL Clients Test

This test reports metrics pertaining to client connections to the ASP .Net server.

Target of the test : An ASP .Net server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for the ASP .Net server being monitored.

Configurable parameters for the test
Parameter Description

Test Period

How often should the test be executed

Host

The IP address of the host for which this test is to be configured.

Port

The port at which the specified Host listens.
Measurements made by the test
Measurement Description Measurement Unit Interpretation

Connection pool size

Indicates the number of connection pools that have been created.

Number

If the connection pool maxes out while new connection requests are still coming in, you willl see connection requests refused, apparently at random. The cure in this case is simply to specify a higher value for the Max Pool Size property.

Number of connections

Indicates the number of connections currently in the pool.

Number

 

Pooled connections

Indicates the number of connections that have been pooled.

Number

 

Pooled connections peak

Indicates the highest number of connections that have been used.

Number

If the value of this measure is at the Max Pool Size value, and the value of the Failed connects measure increases while the application is running, you might have to consider increasing the size of the connection pool.

Failed connects

Indicates the number of connection attempts that have failed.

Number

If the connection pool maxes out while new connection requests are still coming in, you willl see connection requests refused, apparently at random. The cure in this case is simply to specify a higher value for the Max Pool Size property.