Encyclopedia of Database Systems

2009 Edition
| Editors: LING LIU, M. TAMER ÖZSU

Performance Monitoring Tools

  • Philippe Bonnet
  • Dennis Shasha
Reference work entry
DOI: https://doi.org/10.1007/978-0-387-39940-9_124

Definition

Performance monitoring tools denote the utilities and programs that give access to database server internals.

Historical Background

Relational database systems have had to prove their performance from the outset [1]. Tools to measure their performance have therefore been present in early versions of most major systems.

Foundations

Performance Monitoring tools are useful in finding out how queries are being serviced, and how the underlying resources are being used. In this entry, the characteristics of the most relevant types of tools are described.

Event Monitor

Event monitors capture the aggregate resources associated to a given event (e.g., query execution, deadlock, session) and report the collected data when the event completes. Event monitors should have low overhead as the collected data is usually accumulated in performance counters that are updated as a side effect of the operations monitored (e.g., CPU usage, IO issued, locks collected during query execution) and...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    McJones P. The 1995 SQL reunion: people, projects, and politics. Technical Report: SRC–TN–1997–018.Google Scholar
  2. 2.
    Millsap C. and Holt J. Optimizing Oracle Performance. O’Reilly, Sebastopol, CA, 2003.Google Scholar
  3. 3.
    Shasha D. and Bonnet P. Database Tuning: Principles, Experiments and Troubleshooting Techniques. Morgan Kaufmann, San Francisco, CA, 2002.Google Scholar

Copyright information

© Springer Science+Business Media, LLC 2009

Authors and Affiliations

  • Philippe Bonnet
    • 1
  • Dennis Shasha
    • 2
  1. 1.University of CopenhagenCopenhagenDenmark
  2. 2.New York UniversityNew YorkUSA