Carrier-grade Database Application Performance Optimization Technology Research

Nowadays, database is widely used in telecom industry. Because the data volume is much bigger and data process is much more complex than before, the requirement of the database performance is getting higher. How to take full advantage of the hardware and software resource to improve the database performance becomes a hot topic.This paper discussed about the performance tuning of database application. Performance problems always occurs in the production system, but the reasons of performance problems could be involved in all the stages of the application life cycle, including application design, development, testing and production. Operating system, database and application coding is the basic components of database application, all of the possible factors needed to be considered for database performance tuning.This thesis explained the detail procedures of how to detect and diagnose the bottlenecks of the database performance, declared that application and I/O are the major reasons to cause the poor performance, and analyzed the effect of those problems to the database performance.Using bind variable and tuning SQL are two important methods for application tuning, using bind variable could avoid parsing operation, thus reduce CPU and memory usage; tuning SQL is very important to improve response time, decrease CPU, memory and I/O resource usage, and decrease resource competition at the same time.The major goal of tuning I/O is to reduce I/O rate and throughput, thus to reduce the waiting event caused by I/O problems; it can be achieved by tuning application, logical storage, physical storage and I/O channel.Telecom industry is well known for its huge data volume and frequently changing applications, this thesis gave a tuning instance in telecom production system, provided a good reference for the database application performance tuning.