ngreene (2/5/2014)
This article may be helpful for your problem.http://sqlprosperity.com/post/SQL-Server-quasi-real-time-performance-monitoring
It has helped me a lot to identify what processes are causing blocks without having to be on the server querying it at the time of the block. Take a look and hopefully it is helpful.
This thread was from January 2011
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events