14 December 2010

How to receive Deadlock information automatically via email

Something that is confusing, even to some…air quotes..DBA’s, is the difference between locks and deadlocks in SQL server. If you are working with Dynamics GP running on SQL Server, locks are normal. Records get locks as users update them to prevent conflicts.

Deadlocks are something else entirely. Deadlocking occurs when two user processes have locks on separate objects and each process is trying to acquire a lock on the object that the other process has. Deadlocking is bad and has a detrimental affect on performance. They can can also be a pain to track down.

In a new article at SQLServerCentral.com Geoff Albin provides a method to receive Deadlock information automatically via email.. This is fantastic option to help track down intermittent deadlocks.