Problem Solving
Approach
Hardware Performance
CPU Load
Wait IO is really a measure of the I/O subsystem, not the CPU.
CPU Load 2
Storage Subsystem
Storage Subsystem 2
Storage I/O Case Study
Storage I/O Study 2
Memory and Paging
Network
The simplest way to tell if the network is a significant contributor to application performance issues is to take measurement while running the client application on the local host and over the network. Then compare the results.
Database a Bottleneck?
Database Manager
Database Memory 2
Checkpoints
BI File Utilization
Keep busy buffer waits low by using a before image writer.
Keep empty buffer waits low by providing more BI buffers.
Keep the BIW BI writes low by increasing BI buffer size.
Further Information
