Top-Down Approach
Report starts with settings overview
Next provides Top-5 waits
Use the Waits to guide further investigation
Know Your Load Type!
Online Transaction Processing
Few reads
Many writes
Many small transactions
Look for redo/undo and sequential read issues
Decision Support/Data Warehouse
Many reads
Few writes (other then possible temp)
Few transactions
Look for sort/workareaand scattered read issues
Mixed or Hybrid