We have a SSIS package having serializable transactions level.While updating its taking lot of time and gettign locked but i was unable to find out the which another process is blocking how to find this out ?
sp_who2 will give you current processes in server.
sp_who2 'active' will list active processes. Look for BlkBy column and you'll get details of process being blocked ie ones having a valid value for BlkBy and the value there corresponds to ID of process blocking it
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
its an SSIS package inside the sequence container lot of tasks are exist at last we have simple update task which updates status to completed which is getting hanged with system process as blocked.
SPID 2 is blocking the update statement when i run SP_who. But When I go and see there in the sys.dm_tran_locks table it says some foreign key is holding a lock.This foreign key references to the primary key of the table which I am updating and the same is getting blocked.
If you are enthusiastic wow goldabout Runescape Gold world of warcraft however by no means seem to have enough wow gold while playing world of warcraft to get fun, have you ever thought about making much more wow gold within online game or buying wow gold from online wow gold store? I believe you're in the right place, because you will find this article very helpful to make more wow gold on your own or selecting a correct store in order to wow gold kaufen. Reading my post, you will be easily ready to return to online game to make enough precious metal to buy anything you like. It save you a tremendous amount of time.When I simply started playing wow, I do not buy cheap wow gold. In comparison, We invested several weeks desperately attempting to make enough gold to purchase stuff I'd like. However after attempted more than a year, I was forced to quit making wow gold by myself because I will hardly make both ends meet mmoga gold kaufen. It might consider me days to find the weapon I wanted to make use of. It had been being a large amount of function.
Lock on table
Posted - 02/25/2013 : 03:56:06
