SQL Blocked processes issue

• Tsinelas

  Say Hey Kid

  Points: 707

  More actions

  July 6, 2012 at 11:20 am

  #263482

  Hi SQL Masters,

  For MS SQL starndard process, anyone can provide how to resolve this one?

  Details:

  SQL Alert: # of blocked processes 395.00 too high >=20 for 2 collection intervals for ("Instance Name").

  Thank you

  -dev1.bohol

• Ant-Green

  SSC Guru

  Points: 113446

  More actions

  July 9, 2012 at 2:35 am

  #1510210

  Take a look at the accidental DBA e-book (link in my signature below) for the blocking chapter (chapter 6).

• Tsinelas

  Say Hey Kid

  Points: 707

  More actions

  July 9, 2012 at 2:57 pm

  #1510604

  Hi,

  Thanks for the quick response 🙂 i appreciate it much 🙂

  -dev1.bohol