Lock escalation count (delta > 0 triggers investigation) - Deadlock count (delta > 5/hour triggers alert) - Lock timeout count (delta > 10/hour triggers alert) - Any transaction running longer than 30 minutes with locks held - Buffer pool hit ratio below 90% on OLTP pools