For applications which create reports by mining through Databases, the main component that needs to be tested from performance point of view is the database itself.
Performance testing in these cases can be started quite early in the development life cycle, even without waiting for the User Interface to be ready. The stored procedures / SQL queries can be tested for response time, DB CPU & memory usage, etc, by simulating the calling of the queries directly to the DB server through LoadRunner with multiple Vusers. This will provide the developers early information on the performance of the queries and these tests can be conducted iteratively with the development fixes to fine-tune the SQL queries.
While testing the DB, care should be taken to have production-size database with similar number of records available. Also, volume testing can be done to test the degradation in response times for different volumes of data by increasing the volumes of data in a phased manner.
Also, the parameters in the queries should be varied enough to simulate different queries each time.
* For recording scripts to directly run queries on SQL Server, record using ODBC protocol through the SQL Query Analyzer.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment