Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Performance Monitoring Tools

  • Philippe Bonnet
  • Dennis Shasha
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-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, Holt J. Optimizing oracle performance. Sebastopol: O’Reilly; 2003.Google Scholar
  3. 3.
    Shasha D, Bonnet P. Database tuning: principles, experiments and troubleshooting techniques. San Francisco: Morgan Kaufmann; 2002.Google Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Department of Computer ScienceIT University of CopenhagenCopenhagenDenmark
  2. 2.Department of Computer ScienceNew York UniversityNew YorkUSA

Section editors and affiliations

  • Philippe Bonnet
    • 1
  1. 1.Dept. of Computer ScienceUniv. of CopenhagenCopenhagenDenmark