The Research And Implementation Of Database Performance Tuning And Optimization In Rural Land Approval And Registration System

Database performance tuning and optimization need to be considered in the whole software life cycle.In the long term of operation process,database system performance bottleneck is also a problem that software developers need to solve urgently.In this dissertation,combined with the performance bottleneck problems encountered in the development and maintenance of Rural Land Approval and Registration System,based on the theory of database tuning,the Rural Land Approval and Registration System is optimized and studied from tuning database logic design,tuning index,tuning SQL statements,using caching technology and upgrading hardware configuration,etc.The database performance tuning of the Rural Land Approval and Registration System is completed firstly,and also the better performance at the system level is made by repeating the optimization and test to find the optimal scheme suitable for this system.Firstly,the related research of database performance tuning and optimization is introduced and explained in detail,which mainly involves the background,significance,the theoretical methods and the commonly used turning tools of internet industry at home and abroad in the Rural Land Approval and Registration System.The main research methods and contents for the performance tuning of the system are also briefly introduced.Secondly,the database performance tuning and optimization is studied in this dissertation.First of all,we analysis of the working principle of SQL Server kernel memory management and storage is analyzed,which lays the theoretical foundation for subsequent research on SQL Server.After that,the index of database performance is studied,which provides a measure for the performance adjustment of the test.Finally,the performance tuning and optimization of technical route is studied step by step,which is determined from application,database settings,operating system,hardware configuration for all-around.Meanwhile,the tuning and optimization work required at each level is studied theoretically in detail.Thirdly,the database performance tuning and optimization theory is applied to practice,and the correctness of the theory is tested in practice.Combined with business background and system architecture of the Rural Land Approval and Registration System,the interceptor tool is developed,which is suitable for monitoring the database performance and collecting system data required for application layer performance tuning and optimization.According to the optimization scheme of database performance,all aspects of Rural Land Approval and Registration System can be optimized artificially.Through repeated optimization practice,the performance optimization of the Rural Land Approval and Registration System has been completed successfully.Fourthly,the performance monitoring tools and the indexes that need to focus on observing the performance of the system in the tools are introduced.Through the tools,performance indexes of the Rural Land Approval and Registration System before and after optimization are also tested and compared,which confirming the performance optimization scheme has greatly improved the performance of Rural Land Approval and Registration System.Finally,the work of this dissertation is summarized,and also the future tuning work of database performance tuning in the Rural Land Approval and Registration System is prospected.