Database Performance Optimization for SQL Server Based on Hierarchical Queuing Network Model

다국어 초록 (Multilingual Abstract)

With the ever-increasing complexity and variety of database workload, database application system has been imposed on higher and higher performance requirements. Database system consists of software and hardware. And the factors that affect database performance are uncertain. In order to tackle the issue of database system for SQL server, this paper proposes hierarchical queuing network model for performance prediction, and a model is established for both software resources and hardware resources, the nested resources are linearized by hierarchical calling, thus finding out the main factors for system performance bottleneck, and system performance is adjusted and optimized accordingly. The performance tuning algorithm for SQL server database based on the hierarchical queuing network is presented in detail. And TPC-C benchmark is adopted for simulation. Experimental results show the proposed method achieves 16.8% performance increase on average, and TPS is improved by 40% compared to previous method.

목차 (Table of Contents)

• Abstract
• 1. Introduction
• 2. Modeling for Performance Optimization of SQL Server Database System
• 2.1. Hierarchical Queuing Network Model
• 2.2. Working Mechanism for HQN
• 3. Algorithm for Performance Optimization of SQL Server Database
• 4. Experimental Results
• 5. Conclusion
• Acknowledgements
• References