Research And Implementation Of Database Workload Analysis System

As an important part of information system,database's task is to store and manage data.So the performance of the database will directly affect the business expansion capabilities and users experience.Users hope the database' performance stays optimal for a long time,so how to evaluate and improve the performance of the database has become an import subject.At present,some organization use the third-part tools to monitor and analyze the performance of the database,but most of the third-part tools only simulate the workload of database,thus user cannot get a comprehensive analysis results.In order to solve the problem that simulation workload cannot reflect the real load of a database,the thesis analyze the workload which is captured by the database.Performance data will be derived from the analysis results and be used to provide support for database playback functionality and database management.The thesis expounds the research significance and development status of database workload analysis,summarize the basic theory of network communication and database communication.Then the thesis analyzes various protocols that are used in the communication area.As the simulated workload is not comprehensive,the thesis analyzes the total workload that is captured by the database.The thesis focus on workload file analysis and communication protocol parsing,and finally get database performance metrics from the workload data analysis.In this thesis,the system is developed based on the ASE database.Firstly,database store the workload files on disk with PCAP format,and workload analyzer reads the files from disk when analyzing.Then file nanlyzer parsing PCAP files and extracting TDS messages which is used for communications between database clients and server.Secondly,TDS protocol are analyzed through the package split and reorganization,and get the full requests response between the client and server.Then the analyzed data are stored into a database.Finally,the performance report is generated which is extracted from the analytical data.According to database workload analysis system's function requirements,the overall architecture and functional modules of the system are designed.The system is mainly divided into workload capture module,file parsing module,protocol analysis module and workload analyzer module.After workload analysis and data extraction,database performance report can be displayed in graphical form that make the report is more intuitive.Database workload has been developed as script,which makes it possible to replay the workload.When the database is upgraded or configuration parameters need to be changed,one can use the analysis function to determine the impact of the parameters on the database,and provide the proof for changing the configuration parameters to database administrators.