【作者】 赵加奎； 陈立军； 杨冬青； 唐世渭；

【Author】 ZHAO Jia-Kui,CHEN Li-Jun,YANG Dong-Qing,and TANG Shi-Wei (Department of Computer Science and Technology,Peking University,Beijing 100871)

【机构】 北京大学计算机科学与技术系；

【摘要】 能够监控数据库系统的性能对于有效的数据库管理来说非常重要.数据库的性能监控通过对数据库系统中发生的事件进行分析处理来实现,而事件信息正好符合数据流的实时性、持续性和有序性的特征,因此可以用数据流系统Argus来实现数据库系统性能的实时监控工具SQLDBA.DBA通过书写类SQL语句来表达监控请求.SQLDBA具有实时性、灵活性、可扩展性、节省空间以及易于实现等优点,是比较理想的数据库系统性能监控工具.更多还原

【Abstract】 The ability to monitor the performance of a DBMS is very important for effective database management.The monitoring of DBMS performance is achieved by analysis of the events occurring in DBMS,and the event record data of DBMS is real-time,ordered and continuous,which accords with the character of data stream.Accordingly,it is a good idea to use the data stream management system(DSMS) Argus to build DBMS performance monitoring tool,called SQLDBA,in which DBA writes SQL style performance monitoring request.Readers will see that SQLDBA has the virtue of being real-time,flexible, scalable,save memory and easy to implement.更多还原