We often need to create blocking alert in our Production server to capture existing blocking on server and keep record for future analysis. Here are steps which help us to create blocking alerts- Either you can receive blocking details through e-mail or you can log event id in application log and configure your monitoring tool to… Read More Create Blocking Alert – SQL 2005 , SQL 2008 R2 and SQL 2012