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

• 영문명: A Study on SQL Performance Monitoring in the early Stages of Development
• 발행기관: 한국산업기술융합학회(구. 산업기술교육훈련학회)
• 저자명: 장석주(Seok-Joo Chang)
• 간행물 정보: 『한국산업기술융합학회 학술대회 논문집』2019년 후반기 학술대회 논문집, 123~130쪽, 전체 8쪽
• 주제분류: 공학 > 산업공학
• 파일형태: PDF
• 발행일자: 2019.10.25

영문 초록

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.

키워드

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