Database performance optimization for SQL Server based on hierarchical queuing network model

作者：Shao, Jingbo; Liu, Xiaoxiao; Li, Yingmei; Liu, Jingyu

来源：International Journal of Database Theory and Application, 2015, 8(1): 187-196.

DOI：10.14257/ijdta.2015.8.1.19

• Database application systems
• Performance bottlenecks
• Performance optimizations
• Performance prediction
• Performance requirements
• Queuing network
• Software and hardwares
• SQL servers

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.

• 出版日期2015
• 单位哈尔滨工程大学