Browse > Article
http://dx.doi.org/10.9717/kmms.2015.18.12.1501

A Case Study for Improving Performance of A Banking System Using Load Test  

Kim, Tai Suk (Dept. of Computer Software Engineering, Dong-Eui University)
Lee, Jong Yun (Dept. of Computer Software Engineering, Dong-Eui University)
Kim, Jong Soo (Dept. of System Management, Korea Lift College)
Publication Information
Journal of Korea Multimedia Society / v.18, no.12, 2015 , pp. 1501-1508 More about this Journal
Abstract
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.
Keywords
Load Test; Multi Tier; Server; Performance; Counter;
Citations & Related Records
Times Cited By KSCI : 3  (Citation Analysis)
연도 인용수 순위
1 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.   DOI
2 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.   DOI
3 Windows Sysinternals, http://www.microsoft.com/technet/sysinternals (accessed Apr., 20, 2015).
4 PSSDIAG Data Collection Utility, http://support.microsoft.com/default.aspx?scid=kb;en-us;830232 (accessed Feb., 14, 2012).
5 Debugging Tools for Windows(WinDbg, KD, CDB, NTSD), http://msdn.microsoft.com/kokr/library/windows/hardware/ff551063(v=vs. 85).aspx (accessed Feb., 12. 2014).
6 SQL Server Disk Performance Metrics-Part 2-other Important Disk Performance Measures, http://www.sqlshack.com/sql-server-disk-per formance-metrics-part-2-important-disk-perf ormance-measures/ (accessed May., 12, 2014).
7 How To: Use SQL Profiler, https://msdn. microsoft.com/en-us/library/ff650699.aspx (accessed Feb., 12, 2014).
8 Microsoft TechNet-Evaluating Memory and Cache Usage, https://technet.microsoft.com/en-us/library/cc958290.aspx (accessed Jan., 12, 2014).
9 Microsoft TechNet, Library, Server Object, https://technet.microsoft.com/en-us/library/cc757730(v=ws.10).aspx (accessed Jan., 12, 2004).
10 MSDN Library - Memory Object, https://msdn. microsoft.com/en-us/library/ms804008.aspx (accessed Mar., 08, 2015).
11 S. Duttagupta and M Nambiar, "Performance Extrapolation using Load Testing Results," Proceeding of International Journal of Simulation Systems, Science & Technology, pp. 66-74, 2008.
12 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.   DOI
13 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.
14 D.A. Menascé, "Load Testing of Web Sites," IEEE Internet Computing, pp. 70-74, July.August 2002. http://computer.org/internet/