Advanced SearchSearch Tips
A Case Study for Improving Performance of A Banking System Using Load Test
facebook(new window)  Pirnt(new window) E-mail(new window) Excel Download
 Title & Authors
A Case Study for Improving Performance of A Banking System Using Load Test
Kim, Tai Suk; Lee, Jong Yun; Kim, Jong Soo;
  PDF(new window)
In this paper, we describe a case study to improve performance through the load testing of multi-tired system for financial accounts before the system opening. The load test was conducted after the data collection tools(Performance Monitor, DB PSSDiag) were installed. By analyzing the collected log, we were able to identify the main sector requiring performance improvements among the presentation tier, web tier, business logic tier and data tier. The ASP.NET server-down on the web tier could be improved by modifying the parameter values in the configuration file. Some server downs occurred on the business logic tier when a large number of users access at the same time, were more difficult to be solved. By analyzing the hang-dump at the server-down time, we were able to find a process that caused the problem. and we had to modify the relevant codes. For major performance improvements of the data-tier, indices of some queries was optimized by using the built-in DBMS query analyzer, after analyzing the log of long-response-time queries. The problems and solutions considered in this case study will be a reference for the performance improvement of a multi-layer system with the similar structure.
Load Test;Multi Tier;Server;Performance;Counter;
 Cited by
S. Duttagupta and M Nambiar, "Performance Extrapolation using Load Testing Results," Proceeding of International Journal of Simulation Systems, Science & Technology, pp. 66-74, 2008.

T.H.D. Nguyen, B. Adams, Z. Jiang, and A.E. Hassan, "Automatic Load Test Verification using Control Charts," Proceedings of the 18th Asia-Pacific Software Engineering Conference, pp. 282-289, 2008.

D.A. Menascé, "Load Testing of Web Sites," IEEE Internet Computing, pp. 70-74, July.August 2002.

S.W. Lee, J.S. Kim, and T.S. Kim, “Optimization of DB Server and Web Server to Enhance the Performance of ECM,” Journal of Korea Multimedia Society, Vol. 16, No. 12, pp. 1446-1453, 2013. crossref(new window)

J.W. Kim, “Bandwidth Requirement and Priority-based Synchronization Methods in Hybrid Client-Server Architecture for Mobile Multiplayer Games,” Journal of Korea Multimedia Society, Vol. 17, No. 4, pp. 526-534, 2014. crossref(new window)

J. Park, J. Kim, and T. Kim, “Analyzing Operation Deviation in the Deasphalting Process using Multivariate Statistics Analysis Method,” Journal of Korea Multimedia Society, Vol. 17, No. 7, pp. 858-865, 2014. crossref(new window)

Windows Sysinternals, (accessed Apr., 20, 2015).

PSSDIAG Data Collection Utility,;en-us;830232 (accessed Feb., 14, 2012).

Debugging Tools for Windows(WinDbg, KD, CDB, NTSD), 85).aspx (accessed Feb., 12. 2014).

SQL Server Disk Performance Metrics-Part 2-other Important Disk Performance Measures, formance-metrics-part-2-important-disk-perf ormance-measures/ (accessed May., 12, 2014).

How To: Use SQL Profiler, https://msdn. (accessed Feb., 12, 2014).

Microsoft TechNet-Evaluating Memory and Cache Usage, (accessed Jan., 12, 2014).

Microsoft TechNet, Library, Server Object, (accessed Jan., 12, 2004).

MSDN Library - Memory Object, https://msdn. (accessed Mar., 08, 2015).