

Requests for basic MS SQL and Oracle counters are predefined in the product.

Database performance parameters are obtained directly from the database by sending corresponding SQL requests through the ODBC interface. WAPT Pro can use either WMI or SNMP protocol to get the mentioned performance counters data from the web server. Same idea can be applied to CPU or HDD utilization as well as to any other limited system resource. This means that you can improve the performance of the web application by adding more RAM, because that resource is insufficient in the current configuration when the load is peaking. For example, you notice that a peak in the server response time coincides with a 100% peak in the RAM utilization on the server. This feature is especially useful to determine bottlenecks in the server performance.

The obtained data is included in the test results along with other parameters. You can also measure various parameters of the database performance, which is essential for web applications that use databases. This way you can see how your web application responds to the increasing load in terms of CPU, RAM or network usage. WAPT Pro can measure various parameters of the web server performance during the test.
