Improving the System Performance Management Interface of TOP SQL

• Main Authors: Tzu-Chun Lin, 林姿君
• Other Authors: Wei-Min Jeng
• Format: Others
• Language: zh-TW
• Published: 2013
• Online Access: http://ndltd.ncl.edu.tw/handle/99684858683051574539

碩士 === 東吳大學 === 資訊管理學系 === 102 === Upon the heavy use of information technology today, getting hold of the real-time accurate information is the only mean to any possible success. In order to maximize the add-on value of information, the huge amount of data has to be effectively managed with the current data base system. Nearly every application system nowadays depends on a reliable data base sys-tem to provide the critical information it needs. The way regarding how to efficiently access the information remains the issue that most users are concerned. Due to the need of an satis-factory respond time from a data base system, the performance of a good database system has to be maintain in its best operating condition to sustain the running of the overall application. Because of the goal in improving the performance of the system, most of the database system vendors offer monitoring tools or utilities to fine tune the underlying system. Well-known examples such as Quest Software Toad and Embarcadero are suggested by Microsoft SQL Server、Oracle、or even the third-party manufacturers for the same purpose. However, most of the products only passively provide the monitoring statistics without actively providing the helpful advice to the management people. There¬fore, the tools are limited in effectively help the system management at the critical time. This study aims to design an easy and effective tool and the corresponding user interface for the system management people. Practical and lost-cost solution is offered by pinpointing the TOP SQL statements for the users. Top performance indicators such as CPU Time, Disk I/O, etc. are used to monitor the performance of the targeted problematic statements in order to efficiently monitor and improve the system performance.