数据库性能监控分析系统的设计与实现
Design and Implementation of Database Performance Monitoring
and Analysis System
摘 要 讨论了SQL Server 体系结构和性能优化,在此基础上,介绍了一个基于C# 的数据库性能监控和分析系统的总体设计思想及其关键功能的实现,将本系统集成到常用的数据库性能监测工具,通过数据筛选跟踪、重播跟踪、定位分析等方法,实现对数据库性能监测的分析与设计。
关键词 SQL Server 数据库 性能优化 C#
Abstract: On the basis of discussing system architecture and performance optimizing for
SQL Server, this paper presented the overall design idea and its key functions
implementation of database performance monitoring and analysis system based on C#
programming language, the system in this paper can be integrated into the common
database performance monitoring tools,by means of data filtering trace, replay trace and
location analysis and so on, thus analysis and design for performance monitoring of
database can be implemented.
Keywords: SQL Server; database; performance optimization; C#