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

A Study on SQL Performance Monitoring in the early Stages of Development

According to the S/W development life cycle after the S/W development is completed, functional and performance test is performed. The performance issues found in the testing phase will have to go back to the development phase and be improved, which will delay schedules and increase costs. Performance issues in information systems are largely due to inefficient SQL running on the database. Because the execution of SQL is affected by the amount and distribution of the data, inefficient SQL can't be monitored at the beginning of development with a small amount of data. In this paper, I propose a method to proactively monitor inefficient SQL in the early development phase by modulating statistical information about data. In order to validate the feasibility of the proposal, After creating two accounts using DB Schema provided by TPC-C, I created a large amount of data on the first account and a small amount on the second account. After running the same SQL, the comparison between the two accounts results in nearly the same execution plan and an 11% difference in cost.