The project also included people management, learning content management, assignment management, analysis results, etc. This project had developed several years and its codes and logics were more complex with development. Project based on C#, SQL Server and used too many stored procedures to query, calculate, and filter data.

such as long response time in everywhere of the system, system threw a timeout exception with not too much data, feel bad about user experience, etc. Performance issues made troubles to their clients, so they decided to find out and fix related performance problems such as where load with long time, where throw a timeout exception, where should improve the speed, etc.

After enough communications, Nova made test preparation. Nova built an appropriate performance test environment (client and server) that simulated the clients', and generated a quantity of test data requested from this client.

Since client wanted to know the application's response time and find out bottlenecks, testers listed the time of every general action, conditions of actions, and made different acceptable time of these actions.

Some actions that needed longer response time than their acceptable time were filtered from the whole list. Testers used SQL Server Profiler to track the stored procedures that used by these time-consuming actions. Testers analyzed the track logs and found some stored procedures ran several times per one action, and some stored procedures took much time to run completely.

Performance test report and suggestions provided by Nova helped our client find out the performance problems and improve project to be an acceptable project.