• Karen

    Don't change your log backup interval. The log backups won't stop your processes from completing, so just let them run as normal.

    You can use sp_who2 or the Activity Monitor to see a list of connections to the server, what time they connected, whether they are being blocked, and so on. Use DBCC INPUTBUFFER to see what code an individual SPID is executing. For more detailed information, search the web for sp_whoisactive.

    John