Case Study: Improve Performance via Measures

Abstract

A US based company engaged Nova to generate a performance test report about their project. We help them find performance bottlenecks and reasons caused these bottlenecks.

Situation

This company produced a learning management system. 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.

This company got many feedbacks about this project 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.

Solution

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.

Benefits to the Client

• Reduction in client's time spent for producing a stable project.
• Project has a acceptable quality and user experience.

Contact us

To find more details of our technical expertise and previous experience, please fill in the form below and our sales will contact you as soon as possible. Any enquiries from you are welcome, we will respond to you as soon as possible.