VlbDatabases Test
This test reports statistics relating to a VLB’s database.
Target of the test : The TP server
Agent deploying the test : An internal agent
Outputs of the test : One set of outputs for every VLB database instance monitored.
| 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. |
| Measurement | Description | Measurement Unit | Interpretation |
|---|---|---|---|
|
Current VLB database requests |
Indicates the number of database requests currently executing in this VLBinstance. |
Number |
A consistently large value indicates a bottleneck at the database tier |
|
VLB database request execution time |
Indicates the average time it took to execute database requests which completed in the past minute. Response time includes the time for parsing the request, to get the cached stored procedure (SP)information, executing the SAP, and the reading/parsing of the SP results. |
Secs |
A very high value of this measure indicates a performance bottleneck that requires further investigation. |
|
VLB database requests handled |
Indicates the number of requests to the database that have begun to execute in the past minute. |
Number |
|
|
VLB SP execution time |
Indicates the average time the ADO.NET took to execute a stored procedure in the past minute. |
Secs |
|
