SQL 2008 table locked - can't work out why
Posted
by Mr. Flibble
on Stack Overflow
See other posts from Stack Overflow
or by Mr. Flibble
Published on 2010-04-15T11:34:25Z
Indexed on
2010/04/15
12:33 UTC
Read the original article
Hit count: 178
sql-server-2008
|sql
I have two databases on one SQL 2008 server. Database 1 seems to be causing a lock on a table on database 2. There no queries are running on database 1 that should affect database 2.
Is this normal behaviour?
When I view the running queries with this command
SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time/1000 [seconds]
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
it tells me as much, and says that the command on database 2 is suspended.
I'm at a bit of a loss. What sort of things should I look at to work out why the table in database 2 is locked?
© Stack Overflow or respective owner
