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

• 영문명: SQL Performance Monitoring in the Early Stages of development
• 발행기관: 한국산업기술융합학회(구. 산업기술교육훈련학회)
• 저자명: 장석주(Seok-Joo Chang)
• 간행물 정보: 『산업기술연구논문지』산업기술연구논문지 제24권 4호, 81~88쪽, 전체 8쪽
• 주제분류: 공학 > 산업공학
• 파일형태: PDF
• 발행일자: 2019.12.30

영문 초록

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.

목차

Ⅰ. 서 론

Ⅱ. 실험

Ⅲ. 실험결과

Ⅳ. 결 론

키워드

히스토그램 변조 실행계획 데이터베이스 객체 통계정보 SQL Monitoring Fake Histogram Execution Plan Cost Based Optimizer(CBO) Object Statistics