Describe a time when you had to resolve a severe database locking or deadlock issue in a production environment.
