• I'd suggest sp_lock to get a list of locks. You might also want to read up about locking types.

    For blocking processes, sp_who & sp_who2 will give you a good idea of what is happening on your server. To look at processes in further detail, try

    dbcc_inputbuffer(spid)