Optimizing queries using materialized views: a practical, scalable solution
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Continuously adaptive continuous queries over streams
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
Processing complex aggregate queries over data streams
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Monitoring streams: a new class of data management applications
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
SMART: making DB2 (more) autonomic
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
TREAT: a better match algorithm for AI production systems
AAAI'87 Proceedings of the sixth National conference on Artificial intelligence - Volume 1
Automatic physical design tuning: workload as a sequence
Proceedings of the 2006 ACM SIGMOD international conference on Management of data
Self-tuning database systems: a decade of progress
VLDB '07 Proceedings of the 33rd international conference on Very large data bases
Self-tuning query mesh for adaptive multi-route query processing
Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology
DIADS: addressing the "my-problem-or-yours" syndrome with integrated SAN and database diagnosis
FAST '09 Proccedings of the 7th conference on File and storage technologies
Online monitoring and visualisation of database structural deterioration
International Journal of Autonomic Computing
Lightweight problem determination in DBMSs using data stream analysis techniques
Proceedings of the 2010 Conference of the Center for Advanced Studies on Collaborative Research
An active system for dynamic vertical partitioning of relational databases
MICAI'11 Proceedings of the 10th international conference on Artificial Intelligence: advances in Soft Computing - Volume Part II
DYMOND: an active system for dynamic vertical partitioning of multimedia databases
Proceedings of the 16th International Database Engineering & Applications Sysmposium
| Hi-index | 0.00 |
The ability to monitor a database server is crucial foreffective database administration. Today's commercialdatabase systems support two basic mechanisms formonitoring: (a) obtaining a snapshot of counters tocapture current state, and (b) logging events in the serverto a table/file to capture history. In this paper we showthat for a large class of important databaseadministration tasks the above mechanisms areinadequate in functionality or performance. We presentan infrastructure called SQLCM that enables continuousmonitoring inside the database server and that has theability to automatically take actions based on monitoring.We describe the implementation of SQLCM in MicrosoftSQL Server and show how several common and importantmonitoring tasks can be easily specified in SQLCM. Ourexperimental evaluation indicates that SQLCM imposeslow overhead on normal server execution end enablesmonitoring tasks on a production server that would be tooexpensive using today's monitoring mechanisms.