Finding and fixing database level bottlenecks
Performance refers to the way that a system behaves in response to a particular application. It can be measured in terms of system response time and resource utilization. Performance is generally affected by factors such as these factors:
•The resources that are available on your system
•How well those resources are used and shared
An important initial step when there is an unknown bottleneck is to categorize it by basic type. Does it have to do with disk, or maybe a CPU? Memory? Locking or network? ...
Get Performance Management: Using IBM InfoSphere Optim Performance Manager and Query Workload Tuner 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.
