Resource and Performance Monitoring Tools

As mentioned earlier, the majority of database performance problems are the result of a poor database design or poorly coded database queries. Other reasons for performance problems are data access contention (“hot spots”), inadequate hardware resources, or a poorly configured database server. This section describes a variety of tools and techniques for locating database performance problems.

Application Resource Measurement

Because measuring the performance of an application is difficult, Hewlett-Packard and Tivoli Systems jointly developed an open set of APIs for measuring application response times. This standard set of APIs is called Application Resource Measurement (ARM). If an application has been ...

Get UNIX® Fault Management: A Guide for System Administration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.