title: SQL Server - active monitoring and alerts
body: <p>We occasionally experience problems with blocks on the database which prevents other users from editing the table. Whenever we realize that something went wrong we usually run <code>sp_who2</code> sys procedure in order to check BlkBy column and find <code>SPID</code> which blocks the database.</p>
  
  <p>Now we are thinking about some early warning system which will notify us about the block before the others.</p>
  
  <p>Is there any feature in SQL Server which can constantly monitor the situation and alert us once there are more than 3 blocks on specific database?</p>
  
  <p><strong>IMPORTANT</strong>: we would like to <em>avoid</em> creating a job which does that. </p>
  
  <p>I've checked multiple forums and articles already, but couldn't find any satisfactory solution.</p>
  
  <p>Thank you all for the help.</p>
  
  <p>Cheers</p>