基于关系数据库性能优化策略的研究与实现-计算机软件与理论专业论文.docxVIP

摘 要 随着数据量的增大和数据处理复杂度的增加，数据库性能受到越来越大的挑 战。然而，在系统开发过程中，缺乏对系统性能问题的全面考虑；数据库投入运 用后，随着数据量的不断增加，数据分布会产生较大的变化。这些都会造成潜在 的数据库性能问题。因此，如何对数据库性能进行调整和优化已成为数据库研究 领域的一个重要课题。 本文首先对通用关系数据库性能优化理论进行了深入的研究和分析，并提出 了基于层次的迭代优化方法。以此为基础，针对特定的以 SQL Server 为平台的某 个数据库存在的性能问题，通过使用该方法对性能问题进行综合查找分析，提出 了具体的优化方案。该方案重点包括索引、SQL 语句、磁盘存储三个层次的优化， 每个层次均提出了优化流程和优化策略，并在磁盘存储优化中提出并实现了数据 库中自动定时分区和自动定时碎片整理机制。 最后，通过对优化方案实施前后数据库的性能进行对比，数据库的性能得到 了明显的提升，这说明针对存在该性能问题的数据库，基于该优化方法的优化方 案有一定的使用价值。 关键词：数据库 性能优化 基于层次的迭代优化方法 优化方案 SQL Server Abstract With data volume much bigger and data process more complex than before,the database performance is subjected to a bigger challenge.However,during the develop process of the system,little attention are paid to the performance of the system.After the database throwing into use,as the increasing amount of data, data distribution will produce larger changes. All of those may cause potential database performance problem. Therefore, how to adjust and optimize database performance has become an important subject on database research. In this thesis, the theory of the general relational database performance optimization is firstly reaearched and analysed deeply,then an optimization method named based on the level of the iterative is put forward. Based on it, a performance tuning scheme for a particular SQL Server database which have some performance problems is proposed. The scheme mainly include three levels of optimization ,which is the index, the SQL statement and the disk storage,each level are put forward the optimization process and optimization strategy.In the disk storage optimization, an auto mechanism about partition and fragment cleaning in fixed time is proposed and realized. Finally, the performance of the database before and after the implementation of the optimized scheme is compared,and the performance of the database has been obviously improved.This shows that use the proposed based on the level of the interative optimization method to form database optimization scheme