im looking at the results in sp_who2. I see a lot of awaiting commands.
I have done dbcc opentran (database)
i see the oldest is our replication.
select * from sysprocesses where blocked > 0
Done sql profiler on 1204, 3605 for deadlocks - nothing
Still there are over 300-400 processes for awaiting command
Which ones are for system processes.....and must not be killed (if all of these are sa i assume that these are system or someones has hold of the sa password).
Anything else to look at.