Email Alerts for Deadlocks?

Question

Email Alerts for Deadlocks?

ahthomas

Ten Centuries

Points: 1382
More actions
July 2, 2012 at 9:07 am

#392636

Is setting up a job to query for deadlocks and send email alerts possible? Not sure where to start with that.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

http://technet.microsoft.com/en-us/library/ms186385

Need to ensure you have DBMail setup, and a trigger or something to fire the email to your once it triggers the Agent Alert.

ahthomas Ten Centuries Points: 1382 More actions · Answer 2

ahthomas

Ten Centuries

Points: 1382

July 6, 2012 at 9:26 am

#1509762

Not really sure where to begin setting that up...

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

http://msdn.microsoft.com/en-us/library/ms186358.aspx

this should help you setup db mail

ahthomas Ten Centuries Points: 1382 More actions · Answer 4

Mail is already setup, I am not sure how to setup the job to check for deadlocks, and alert when there are locks..

Ant-Green SSC Guru Points: 113507 More actions · Answer 5

The first link contains the T-SQL to create the alert and the job and the table it logs it too, but you will need to specify the Database and modify where it in the script, just replace AdventureWorks for the database of your choice.

Then you just need to create a trigger on this table which uses sp_send_dbmail to send the inserted value via email.

ahthomas Ten Centuries Points: 1382 More actions · Answer 6

I enabled traceflag 1222 -1 to log deadlocks to a table. Looks like this link might be more what I want... I assume step 3 just goes into a job?

http://myexperienceinmssql.blogspot.com/2012/05/configuring-deadlock-alert.html