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...
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
McJones P. The 1995 SQL reunion: people, projects, and politics. Technical report: SRC-TN-1997-018.
Millsap C, Holt J. Optimizing oracle performance. Sebastopol: O’Reilly; 2003.
Shasha D, Bonnet P. Database tuning: principles, experiments and troubleshooting techniques. San Francisco: Morgan Kaufmann; 2002.
Author information
Authors and Affiliations
Corresponding authors
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Bonnet, P., Shasha, D. (2018). Performance Monitoring Tools. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_124
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_124
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering