计算机应用与软件2012，Vol.29Issue(12)：58-60,3.DOI:10.3969/j.issn.1000-386x.2012.12.017
基于动态视图的数据库性能调优
DATABASE PERFORMANCE TUNING BASED ON DYNAMIC VIEWS
摘要
Abstract
For the issue that the abnormal fluctuations of load may affect the performance of database, external graphical tools for monitoring and database optimisation can be employed, but the operation of these software in server would waste a lot of system resource. Moreover, many tuning methods are also relatively one-sided and short of overall view. Therefore, a database performance tuning method based on dynamic views is proposed. This method starts from system performance parameters, by establishing global performance baselines, and in combination with dynamic views to analyse the reasons of resource consumption, it studies how to reduce the cost of execution plan. 120,000 records are chosen from SQL Server 2008 Adventure Works database to make examples verification, and experimental resulte show that the method can effectively solve the practical performance problems in large-scale data processing.关键词
数据库管理员/性能基线/动态视图/执行计划/非聚集索引/查询优化器Key words
Database administrator/Performance baseline/Dynamic views/Execution plan/Nonclustering index/Query optimiser分类
信息技术与安全科学引用本文复制引用
徐增敏,张昆,丁勇,赵汝文..基于动态视图的数据库性能调优[J].计算机应用与软件,2012,29(12):58-60,3.基金项目
国家自然科学基金项目(60963024). （60963024）
