How do you diagnose and resolve severe query performance degradation or database locking issues in a production environment?
