blocked table

Last Post 08 Mar 2007 04:02 AM by TRACEYSQL. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
TRACEYSQL
New Member
New Member

--
07 Mar 2007 12:35 PM
hi there i have a program that runs and blocks the table.
I can see what table it is but is there a way i can find out exact what is blocked on by table to the record row?

The only way i can clear this is to kill the spid
Thanks
TRACEYSQL
New Member
New Member

--
08 Mar 2007 04:02 AM
i did run the blocker script that microsoft has sql_blocker_pss80 and captured this



DBCC OPENTRAN FOR DBID 7 [DeltekCP]
Transaction information for database 'DeltekCP'.

Oldest active transaction:
SPID (server process ID) : 238
UID (user ID) : -1
Name : implicit_transaction
LSN : (377463:37782:1)
Start time : Mar 7 2007 1:09:59:150PM

Replicated Transaction Information:
Oldest distributed LSN : (377463:93346:8)
Oldest non-distributed LSN : (0:0:0)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

End time: 2007-03-07 13:16:32.670

8.2 Start time: 2007-03-07 13:16:47.670 0

SYSPROCESSES ASRCFHSQL1\SQL1 134219767
spid status blocked open_tran waitresource waittype waittime cmd lastwaittype cpu physical_io memusage last_batch login_time net_address net_library dbid ecid kpid hostname hostprocess loginame program_name nt_domain nt_username uid sid sql_handle stmt_start stmt_end
------ ------------------------------ ------- --------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ----------- ---------------- -------------------------------- ----------- -------------------- ----------- -------------------------- -------------------------- ------------ ------------ ------ ------ ------ -------------------------------------------------------------------------------------------------------------------------------- ----------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------ ----------- -----------
174 runnable 0 1
You are not authorized to post a reply.

Acceptable Use Policy