| Abstract |
With the development of a companys services, service requirements and data volume change rapidly increase. As service diversity and data volume change, database performance is under unprecedented pressure. Therefore, database performance faults are more and more concerned. Production system change involves the performance optimization need to modify the design, modify the code, takes longer, solve the problem involving more people and process more complicated, poor timeliness, brings the certain effect to the system problem solving, how to in system design, development and testing phase, timely find problems and solve the problem, simplify the process. To this end, the development of database audit system based on SQL optimization, effectively assist developers and DBA audit to find problems, quickly and accurately locate SQL problems and quickly solve SQL problems, in the assurance of high quality online SQL code, SQL quality control and prediction of SQL performance. Greatly simplifies DBAs work and improves operation and maintenance efficiency. Effectively avoid performance problems.
|