개발단계에서 SQL 성능 모니터링 방안 연구

SQL Performance Monitoring in the Early Stages of development

After completion of the S/W developmental life cycle, functional and performance testing is performed. Any identified performance issue in the testing phase requires a return to the development phase to address the problem. This results in delayed schedules and increased costs. Performance problems in information systems are largely due to inefficient SQL operating on the database. Given that the execution of SQL is affected by the amount and distribution of data, an inefficient SQL cannot be monitored at the beginning of the development phase using a limited amount of data. In this report, a method to proactively monitor an inefficient SQL in the early development phase is proposed based on the modulation of the statistical information regarding the data. To validate the feasibility of this method, two accounts were created using the DB Schema provided by TPC-C. A large amount of data was generated using the first account, and a small amount using the second account. After running the same SQL, a comparison of the two accounts resulted in nearly the same execution plan and an 11% difference in cost.