2
votes
2answers
333 views

I have a blocking transaction, but no statement is shown

My SQL Server 2008 started hanging on simple queries, so I checked for blocking transactions, using the built-in All Blocking Transactions report. Sure enough, such a transaction exists. However, if ...
1
vote
2answers
475 views

What's the best way to monitor SQL Server Concurrency issues?

What's the best way to monitor SQL Server Conccurency issues? Specifically my goal is to reduce or prevent deadlocks and blocking and to catch potential concerns before they become a problem. For ...