So lately I've been getting calls occasionally about system performance. First thing I do is check for cases of blocking as the system has a history of it. I execute some stored procedures which find long running processes with locks or processes waiting for locks. I check these processes in Activity Monitor and when I select "Details" after choosing the process in Activity Monitor, the Last T-SQL Command Batch is nothing. No SQL statement at all. Is this normal in the case of locked up processes? Do you think it's a crashed program on one of the clients causing the problem? This seems to be the only theory that I can think of.