SQL事件跟踪探查器在数据库优化中的作用

Action of SQL Profiler in Database Optimization

随着数据库内数据量的逐渐增大,系统的响应速度将越来越慢,这极大地影响了系统的整体性能,因此,探索数据库优化技术具有非常重要的意义。通过实例介绍了利用SQL事件跟踪探查器进行数据库优化的方法,利用Profiler跟踪查询,找到影响系统性能的SQL语句,并加以优化;同时,利用索引优化器优化索引,实现了数据库的优化。实践证明,文中所提出的优化方法明显提高了管理信息系统的性能和效率。

As the increase of the data in database, the response speed of the system becomes slower and slower, which affect the total performance of system. It is significant to study the technique of database optimization. This paper introduces a method of database optimization employing SQL profiler. It relies on the profiler to find the SQL sentences influencing the performance of system and optimize them. Meantime, it employs index optimizer which can optimize the index to optimize the database. It has been found that, the presented method can remarkably improve the performance and efficiency of information management system.