Skip to Content
0
Former Member
Apr 30, 2014 at 05:20 PM

dbcc is sleeping

55 Views

try to run dbcc checkdb(mydb) and it is waiting at middle of the process. then open another isql session to check the process, and got following message:

1> sp_who

2> go

fid spid status loginame

origname hostname blk_spid

dbname cmd block_xloid

------ ------ ------------ ------------------------------

------------------------------ ---------- --------

------------------------------ ---------------- -----------

0 2 sleeping NULL

NULL 0

master DEADLOCK TUNE 0

0 3 sleeping NULL

NULL 0

master ASTC HANDLER 0

0 4 sleeping NULL

NULL 0

master CHECKPOINT SLEEP 0

0 5 sleeping NULL

NULL 0

master HK WASH 0

0 6 sleeping NULL

NULL 0

master HK GC 0

0 7 sleeping NULL

NULL 0

master HK CHORES 0

0 8 sleeping NULL

NULL 0

master PORT MANAGER 0

0 9 sleeping NULL

NULL 0

master NETWORK HANDLER 0

0 14 running sa

sa mysyb.li 0

master SELECT 0

0 31 sleeping sa

sa mysyb.li 0

mydb DBCC 0

(10 rows affected)

(return status = 0)

dbcc is sleeping. then run sp_lock and find out one large table with sh_table lock:

1> sp_lock

2> go

The class column will display the cursor name for locks associated with a cursor

for the current user and the cursor id for other users.

fid spid loid locktype table_id page

row dbname class

context

------ ------ ----------- ---------------------------- ----------- -----------

------ --------------- ------------------------------

----------------------------

0 14 28 Sh_intent 752002679 0

0 master Non Cursor Lock

0 31 62 Sh_page 1 1261

0 mydb Non Cursor Lock

0 31 62 Sh_table 1620926561 0

0 mydb Non Cursor Lock

(3 rows affected)

(return status = 0)

So I can't finish dbcc checkdb. How to resolve this problem?