What steps would you take to diagnose the causes of low database performance?

To diagnose low database performance, I would follow these steps:

1. Metrics collection and monitoring: Check CPU load, memory usage, I/O operations, network activity on the database server.
2. Slow query analysis: Enable slow query logging or use database profiler to identify long-running queries.
3. Index check: Ensure that indexes are created and used correctly for frequently used queries.
4. Query optimization: Analyze execution plans (EXPLAIN) to identify bottlenecks.
5. Lock and contention check: Detect if locks or deadlocks are causing delays.
6. Database configuration review: Check memory, caching, parallelism settings, and other performance-related parameters.
7. Hardware resources: Ensure the server is not resource-constrained.

This systematic approach helps identify and fix performance issues.