What steps do you take to diagnose and resolve a database performance bottleneck caused by slow-running queries?