Avoiding Thrashing
If over 30% of active transactions are blocked, then the system is (nearly) thrashingso reduce the number of active transactions
Timeout-based deadlock detection mistakes
- They happen due to long lock delays
- So the system is probably close to thrashing
- So if deadlock detection rate is too high (over 2%) reduce the number of active transactions