用 sp_who_lock查询到是94号进程死锁
于是用 kill 94取消此进程,
但是结果一直是:SPID 94: 正在进行事务回滚。估计回滚已完成: 100%。估计剩余时间: 0 秒。
kill 很多此都一直是这结果。尝试KILL 7,但是提示:只能KILL用户进程。尝试了将DSTC重启也没用。但是重启可以解决这个问题。
图如下:
于是用 kill 94取消此进程,
但是结果一直是:SPID 94: 正在进行事务回滚。估计回滚已完成: 100%。估计剩余时间: 0 秒。
kill 很多此都一直是这结果。尝试KILL 7,但是提示:只能KILL用户进程。尝试了将DSTC重启也没用。但是重启可以解决这个问题。
图如下:
*Dump thread - spid = 94, PSS = 0x1c593250, EC = 0x1c593580
*Stack Dump being sent to d:\ERPDB\MSSQL\log\SQLDump0010.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 05/12/11 09:15:51 spid 94
*
*
*
* ( cD *A . O 01 00 28 00 63 44 db 2a 41 bd d0 11 b1 2e 00 c0 4f c2
* ZY G ? C = f3 ef 1f 5a 59 90 f6 14 fa 47 a8 3f e0 93 43 f8 3d c1
* 03 00 00 00 00 00 00 00
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00CBCFFF 008bd000
* ntdll 7C930000 7CA02FFF 000d3000
* kernel32 7C800000 7C92BFFF 0012c000
* ADVAPI32 77F30000 77FDBFFF 000ac000
* RPCRT4 77C20000 77CC0FFF 000a1000
* Secur32 76EB0000 76EC2FFF 00013000
* MSVCP71 7C3A0000 7C41AFFF 0007b000
* MSVCR71 7C340000 7C395FFF 00056000
* opends60 41060000 41065FFF 00006000
* SHELL32 7CA10000 7D1EBFFF 007dc000
* msvcrt 77B70000 77BC9FFF 0005a000
* GDI32 77BD0000 77C18FFF 00049000
* USER32 77E10000 77E9FFFF 00090000
* SHLWAPI 77EB0000 77F01FFF 00052000
* sqlsort 42AE0000 42B6FFFF 00090000
* ums 41070000 4107DFFF 0000e000
* IMM32 76180000 7619CFFF 0001d000
* LPK 7F000000 7F008FFF 00009000
* USP10 74AE0000 74B44FFF 00065000
* comctl32 77CD0000 77DD2FFF 00103000
* sqlevn70 41080000 4108AFFF 0000b000
* NETAPI32 03260000 032B7FFF 00058000
* AUTHZ 032C0000 032D3FFF 00014000
* COMRES 038F0000 03A49FFF 0015a000
* ole32 03A50000 03B88FFF 00139000
* XOLEHLP 03B90000 03B95FFF 00006000
* MSDTCPRX 03BA0000 03C18FFF 00079000
* OLEAUT32 03C20000 03CABFFF 0008c000
* msvcp60 03CB0000 03D14FFF 00065000
* MTXCLU 03D20000 03D38FFF 00019000
* VERSION 03D40000 03D47FFF 00008000
* WSOCK32 03D50000 03D5AFFF 0000b000
* WS2_32 03D60000 03D76FFF 00017000
* WS2HELP 03D80000 03D87FFF 00008000
* CLUSAPI 03DD0000 03DE1FFF 00012000
* RESUTILS 03DF0000 03E02FFF 00013000
* USERENV 03E10000 03ECCFFF 000bd000
* mswsock 03EE0000 03F1FFFF 00040000
* DNSAPI 03F20000 03F4AFFF 0002b000
* winrnr 03F90000 03F96FFF 00007000
* WLDAP32 03FA0000 03FCDFFF 0002e000
* rasadhlp 03FF0000 03FF4FFF 00005000
* NTMARTA 00EA0000 00EBFFFF 00020000
* SAMLIB 00EC0000 00ECEFFF 0000f000
* SSNETLIB 00ED0000 00EE5FFF 00016000
* security 04AD0000 04AD3FFF 00004000
* hnetcfg 04AE0000 04B36FFF 00057000
* wshtcpip 05B90000 05B97FFF 00008000
* SSmsLPCn 05C20000 05C27FFF 00008000
* SSnmPN70 05DE0000 05DE6FFF 00007000
* ntdsapi 06100000 06113FFF 00014000
* kerberos 058D0000 05927FFF 00058000
* cryptdll 05FD0000 05FDBFFF 0000c000
* MSASN1 06150000 06161FFF 00012000
* rsaenh 04B50000 04B84FFF 00035000
* PSAPI 04B90000 04B9AFFF 0000b000
* xpsp2res 06170000 066B8FFF 00549000
* Invalid Address 05740000 057C2FFF 00083000
* sqloledb 066C0000 06740FFF 00081000
* Invalid Address 051B0000 051C9FFF 0001a000
* MSDATL3 05650000 05664FFF 00015000
* oledb32 06C50000 06CC8FFF 00079000
* OLEDB32R 05180000 0518AFFF 0000b000
* xpstar 06CD0000 06D1CFFF 0004d000
* SQLRESLD 052D0000 052DBFFF 0000c000
* SQLSVC 06D20000 06D3AFFF 0001b000
* mlang 10D30000 10DC2FFF 00093000
* msoeacct 09670000 096B3FFF 00044000
* acctres 07F90000 07F9CFFF 0000d000
* msident 084E0000 084EDFFF 0000e000
* msidntld 08680000 08684FFF 00005000
* PSTOREC 088C0000 088CDFFF 0000e000
* SETUPAPI 10E70000 10FE3FFF 00174000
* ADMWPROX 08B90000 08BA0FFF 00011000
* xpsqlbot 05050000 05055FFF 00006000
* DBNETLIB 04E50000 04E6BFFF 0001c000
* DBnmpNTw 04BE0000 04BE6FFF 00007000
* SQLOLEDB 05080000 0508CFFF 0000d000
* msadce 0F850000 0F8A7FFF 00058000
* msadcer 07450000 07452FFF 00003000
* msi 112F0000 11730FFF 00441000
* dbghelp 11740000 1183FFFF 00100000
*
* * *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 009BA63C Module(sqlservr+005BA63C) (GetOSErrString+00004F68)
* * -------------------------------------------------------------------------------