My client needs to know blocking and blocked SQL Statments in DPA alert

dpa2016yw

Hello,

Is there a way to get a blocking session SQL Statements for blocking and blocked sessions for SQL Server 2012 in the alert email? I know there is no these info in standard total blocking time alert.

Thanks for your help!

Find more posts tagged with

Alert

Accepted answers

mandevil

Here's one you could likely implement and modify: Custom Alert - Blocked Sessions - From Instance

It concatenates the select clause. Be aware though that I think our message has a 100 or 200 character limit, so you will likely have to trim it down significantly.

All comments

mandevil

Here's one you could likely implement and modify: Custom Alert - Blocked Sessions - From Instance

It concatenates the select clause. Be aware though that I think our message has a 100 or 200 character limit, so you will likely have to trim it down significantly.

dpa2016yw

Thanks. we also need blocked session sql statements.

Thanks for your help

dpa2016yw

we also need to know blocker session sql statements.

Thanks for your help!