O'Reilly logo

Performance Management: Using IBM InfoSphere Optim Performance Manager and Query Workload Tuner by Yong Hua Zeng, Marichu Scanlon, Lakshmi Palaniappan, Marcia Miskimen, Holly Hayes, Ute Baumbach, Chuck Ballard

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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? ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required