SharePoint Dragons

Nikander & Margriet on SharePoint

Kill table lock

Found a table that was locked during an ETL process. Retrieved the culprit session via:

select * from sys.dm_exec_requests cross apply sys.dm_exec_sql_text([sql_handle]) where blocking_session_id = 0

Then, killed it like this:

KILL([session id])

And the ETL process is free to try again!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: