Jo Pattyn
SSC-Dedicated
Points: 32571
More actions
May 9, 2023 at 8:39 am
#4186509
You can capture blocking with extended events on SQL 2019, but doesn't have alerting
Alerting can be done with xesmarttarget
https://spaghettidba.com/2022/02/28/recipe-5-killing-blocking-spids/
https://spaghettidba.com/2022/02/25/recipe-4-sending-alerts-via-email/
Saran
Right there with Babe
Points: 760
May 10, 2023 at 1:58 pm
#4187397
Thanks, it is little complicated to configure https://spaghettidba.com/2022/02/28/recipe-5-killing-blocking-spids/
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply