Hi friends, It's me agains with some performance issues... I wish I had something better to say... but well. The question is very simple. I have a software running towards an SQL Server database 24X7. The performance is quite good! You taught me how to improve it!. But lately I have been having some terrible locks. This happens once in 20 days aproximately. There seems to exist some query that runs not very often that locks every single query that tries to run against the DB for a couple of minutes. This locks the entire set of transactions, locking al the requests made to the application. I can see this at the Activity Monitor, where all the connections look like "suspended" . If I run the SQL Profiler, it will tell me that all the queries have a great performance and they do. But it seems that once in a while, some runs some runs some bizarre query and it locks everything down. So the question is: 1) Which is the best way to get the best info when this happens?? Maybe something about "Blocked Processes thresholds" ? Maybe If this happens for 30 or 40 seconds I wont get to know, and it might be happening more often than I thought. 2) Is there a way to tell SQL Server that if this happens , it should inmediately abort the unperformant query? Ok... Thanks a lot in advance!