Performance Monitoring Tools
Performance monitoring tools denote the utilities and programs that give access to database server internals.
Relational database systems have had to prove their performance from the outset . Tools to measure their performance have therefore been present in early versions of most major systems.
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 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...
- 1.McJones P. The 1995 SQL reunion: people, projects, and politics. Technical report: SRC-TN-1997-018.Google Scholar
- 2.Millsap C, Holt J. Optimizing oracle performance. Sebastopol: O’Reilly; 2003.Google Scholar
- 3.Shasha D, Bonnet P. Database tuning: principles, experiments and troubleshooting techniques. San Francisco: Morgan Kaufmann; 2002.Google Scholar