Low data cache hit rate

Low catalog cache hit rate

Low converter cache hit rate

Cache swaps

High read rate (physical)

High read activity (physical)

High write activity (physical)

High read rate (virtual)

High parse activity

Low hit rate for table scans

Low hit rate for optimizer strategy

Low hit rate on <deletes/updates>

'Physical Temp Page Writes' high

High collision rate on SQL locks

Long waiting times with SQL collisions

Queue on SQL collisions

Lock escalations (<number of> table locks)

Log queue overflows

'Log I/O-Queue' too small

High log activity

Long write transactions

High collision rate on <name> region

High TAS collision rate

Large number of time-consuming commands

Long command runtime in DB kernel

Large number of self suspends (dispatches)

Long vsuspend time (user tasks)

Large number of vsleeps (user tasks)