ASP SQL Clients Test

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

Target of the test : The 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
  1. TEST PERIOD - How often should the test be executed.
  2. Host - The host for which the test is to be configured.
  3. Port - The port to 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.