상세검색
최근 검색어 전체 삭제
다국어입력
즐겨찾기0
150169.jpg
KCI등재 학술저널

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

SQL Performance Monitoring in the Early Stages of development

  • 35

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.

Ⅰ. 서 론

Ⅱ. 실험

Ⅲ. 실험결과

Ⅳ. 결 론

로딩중