- 论坛徽章:
- 0
|
sp_who结果如下
fid spid status loginame origname hostname blk dbname cmd
------ ------ ------------ ------------------------------ ------------------------------ ---------- ----- ------------------------------ ----------------
0 2 sleeping (null) (null) 0 master NETWORK HANDLER
0 3 sleeping (null) (null) 0 master DEADLOCK TUNE
0 4 sleeping (null) (null) 0 master MIRROR HANDLER
0 5 sleeping (null) (null) 0 master CHECKPOINT SLEEP
0 6 PLC sleep (null) (null) 0 master HOUSEKEEPER
0 29 lock sleep sa sa 瓪?_?? 8 master FETCH CURSOR
0 52 running sa sa ≤⊙_⊙≥ 0 master SELECT
29的状态是lock sleep ,blk是8
但是8在哪里???
sp_lock结果如下
fid spid locktype table_id page row dbname class context
------ ------ ---------------------------- ----------- ----------- ------ --------------- ------------------------------ ----------------------------
0 8 Ex_intent 31 0 0 master Non Cursor Lock Fam dur
0 8 Ex_page 31 280 0 master Non Cursor Lock Fam dur, Ind pg
0 8 Ex_page 31 282 0 master Non Cursor Lock Fam dur
0 8 Ex_page 31 288 0 master Non Cursor Lock Fam dur, Ind pg
0 8 Ex_page 31 296 0 master Non Cursor Lock Fam dur, Ind pg
0 8 Sh_table 35 0 0 master Non Cursor Lock
select * from sysobjects where id=31
select * from sysobjects where id=35
结果是
name id uid type userstat sysstat indexdel schemacnt sysstat2 crdate expdate deltrig instrig updtrig seltrig ckfirst cache audflags objspare versionts
------------------------------ ----------- ------ ---- -------- ------- -------- --------- ----------- --------------------------- --------------------------- ----------- ----------- ----------- ----------- ----------- ------ ----------- ----------- --------------------------
sysusages 31 1 S 0 113 0 2 0 01 1 1900 12:00AM 01 1 1900 12:00AM 0 0 0 0 0 0 (null) 0 (null)
(1 row(s) affected)
name id uid type userstat sysstat indexdel schemacnt sysstat2 crdate expdate deltrig instrig updtrig seltrig ckfirst cache audflags objspare versionts
------------------------------ ----------- ------ ---- -------- ------- -------- --------- ----------- --------------------------- --------------------------- ----------- ----------- ----------- ----------- ----------- ------ ----------- ----------- --------------------------
sysdevices 35 1 S 0 81 0 0 0 01 1 1900 12:00AM 01 1 1900 12:00AM 0 0 0 0 0 0 (null) 0 (null)
此时我已经无法加设备了,一看设备就锁死,请问如何处理?谢谢!!! |
|