none
数据库访问突然超时之后又自行恢复正常,存在大量报错 Exception raised, major=52, minor=42, state=3, severity=22 RRS feed

  • 问题

  • 环境:SQL2008R2数据库群集  +  操作系统server2008 R2 企业版
    故障现象:突然应用访问卡,接着超时。过了1个小时左右又恢复正常。今年出现过3次,都是莫名其妙自己好了,生产系统,每次将近1个小时无法访问给单位带来很大的损失,找不到问题和处理办法,鸭梨山大。


    服务器性能很好,内存32G ,CPU 无压力。
    分析日志如下,向版主、各位大神求助:


    spid kpid    blocked waittype waittime lastwaittype    dbid uid
    187 18864   0 0x0000      0        SOS_SCHEDULER_YIELD         6 1

    cpu physical_io memusage login_time last_batch ecid open_tran status    
    46 0       2                  00:01.0      33:47.6 0 0  runnable   


    2015-11-26 13:37:48.09 spid78      ex_raise2: Exception raised, major=52, minor=42, state=3, severity=22, attempting to create symptom dump
    2015-11-26 13:37:48.13 spid78      Using 'dbghelp.dll' version '4.0.5'
    2015-11-26 13:37:48.15 spid78      **Dump thread - spid = 0, EC = 0x00000002CDC8A460
    2015-11-26 13:37:48.15 spid78      *
    2015-11-26 13:37:48.15 spid78      * User initiated stack dump.  This is not a server exception dump.
    2015-11-26 13:37:48.15 spid78      *
    2015-11-26 13:37:48.15 spid78      ***Stack Dump being sent to G:\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\SQLDump4451.txt
    2015-11-26 13:37:48.15 spid78      * *******************************************************************************
    2015-11-26 13:37:48.15 spid78      *
    2015-11-26 13:37:48.15 spid78      * BEGIN STACK DUMP:
    2015-11-26 13:37:48.15 spid78      *   11/26/15 13:37:48 spid 78
    2015-11-26 13:37:48.15 spid78      *
    2015-11-26 13:37:48.15 spid78      * ex_raise2: Exception raised, major=52, minor=42, state=3, severity=22
    2015-11-26 13:37:48.15 spid78      *
    2015-11-26 13:37:48.15 spid78      * Input Buffer 510 bytes -
    2015-11-26 13:37:48.15 spid78      *              select 1 from Messages_Center  where  SendMode=4  and  DoneD
    2015-11-26 13:37:48.15 spid78      *  ate is null and IsShow = 1 and IsDel= 0  and IsNoHandle=0  and NoNeedRem
    2015-11-26 13:37:48.15 spid78      *  ind =0 and (  (  TargetUser = 'a22bef40-57a4-4569-9e7d-21591a6541f7' ) 
    2015-11-26 13:37:48.15 spid78      *  )  and  MessageType in ('  ','  ')  order by Row_ID desc
    2015-11-26 13:37:48.15 spid78      * 
    2015-11-26 13:37:48.15 spid78      *
    2015-11-26 13:37:48.15 spid78      *  MODULE                          BASE      END       SIZE
    2015-11-26 13:37:48.15 spid78      * sqlservr                       0000000000B70000  000000000471DFFF  03bae000
    2015-11-26 13:37:48.15 spid78      * ntdll                          0000000077230000  00000000773D8FFF  001a9000
    2015-11-26 13:37:48.15 spid78      * kernel32                       0000000077010000  000000007712EFFF  0011f000
    2015-11-26 13:37:48.15 spid78      * KERNELBASE                     000007FEFD1C0000  000007FEFD22BFFF  0006c000
    2015-11-26 13:37:48.15 spid78      * ADVAPI32                       000007FEFD3B0000  000007FEFD48AFFF  000db000
    2015-11-26 13:37:48.15 spid78      * msvcrt                         000007FEFEF70000  000007FEFF00EFFF  0009f000
    2015-11-26 13:37:48.15 spid78      * sechost                        000007FEFD620000  000007FEFD63EFFF  0001f000
    2015-11-26 13:37:48.15 spid78      * RPCRT4                         000007FEFF370000  000007FEFF49CFFF  0012d000
    2015-11-26 13:37:48.15 spid78      * MSVCR80                        0000000074CB0000  0000000074D78FFF  000c9000
    2015-11-26 13:37:48.15 spid78      * MSVCP80                        0000000074BA0000  0000000074CA8FFF  00109000
    2015-11-26 13:37:48.15 spid78      * sqlos                          0000000070CB0000  0000000070CB6FFF  00007000
    2015-11-26 13:37:48.15 spid78      * Secur32                        000007FEFCD60000  000007FEFCD6AFFF  0000b000
    2015-11-26 13:37:48.15 spid78      * SSPICLI                        000007FEFCDC0000  000007FEFCDE4FFF  00025000
    2015-11-26 13:37:48.15 spid78      * pdh                            000007FEEA0A0000  000007FEEA0EDFFF  0004e000
    2015-11-26 13:37:48.15 spid78      * SHLWAPI                        000007FEFD850000  000007FEFD8C0FFF  00071000
    2015-11-26 13:37:48.15 spid78      * GDI32                          000007FEFF4A0000  000007FEFF506FFF  00067000
    2015-11-26 13:37:48.15 spid78      * USER32                         0000000077130000  0000000077229FFF  000fa000
    2015-11-26 13:37:48.15 spid78      * LPK                            000007FEFD970000  000007FEFD97DFFF  0000e000
    2015-11-26 13:37:48.15 spid78      * USP10                          000007FEFD980000  000007FEFDA48FFF  000c9000
    2015-11-26 13:37:48.15 spid78      * USERENV                        000007FEFD230000  000007FEFD24DFFF  0001e000
    2015-11-26 13:37:48.15 spid78      * profapi                        000007FEFCFF0000  000007FEFCFFEFFF  0000f000
    2015-11-26 13:37:48.15 spid78      * WINMM                          000007FEF4370000  000007FEF43AAFFF  0003b000
    2015-11-26 13:37:48.15 spid78      * IPHLPAPI                       000007FEFAF80000  000007FEFAFA6FFF  00027000
    2015-11-26 13:37:48.15 spid78      * NSI                            000007FEFF530000  000007FEFF537FFF  00008000
    2015-11-26 13:37:48.15 spid78      * WINNSI                         000007FEFAF70000  000007FEFAF7AFFF  0000b000
    2015-11-26 13:37:48.15 spid78      * opends60                       0000000070E80000  0000000070E87FFF  00008000
    2015-11-26 13:37:48.15 spid78      * NETAPI32                       000007FEFB030000  000007FEFB045FFF  00016000
    2015-11-26 13:37:48.15 spid78      * netutils                       000007FEFC420000  000007FEFC42BFFF  0000c000
    2015-11-26 13:37:48.15 spid78      * srvcli                         000007FEFCA70000  000007FEFCA92FFF  00023000
    2015-11-26 13:37:48.15 spid78      * wkscli                         000007FEFB010000  000007FEFB024FFF  00015000
    2015-11-26 13:37:48.15 spid78      * LOGONCLI                       000007FEFC5E0000  000007FEFC60FFFF  00030000
    2015-11-26 13:37:48.15 spid78      * SAMCLI                         000007FEF9A50000  000007FEF9A63FFF  00014000
    2015-11-26 13:37:48.15 spid78      * BatchParser                    0000000070670000  000000007069CFFF  0002d000
    2015-11-26 13:37:48.15 spid78      * IMM32                          000007FEFD820000  000007FEFD84DFFF  0002e000
    2015-11-26 13:37:48.15 spid78      * MSCTF                          000007FEFF010000  000007FEFF118FFF  00109000
    2015-11-26 13:37:48.15 spid78      * psapi                          00000000773F0000  00000000773F6FFF  00007000
    2015-11-26 13:37:48.15 spid78      * instapi10                      0000000065FC0000  0000000065FCCFFF  0000d000
    2015-11-26 13:37:48.15 spid78      * CLUSAPI                        000007FEF9680000  000007FEF96CFFFF  00050000
    2015-11-26 13:37:48.15 spid78      * cryptdll                       000007FEFCAA0000  000007FEFCAB3FFF  00014000
    2015-11-26 13:37:48.15 spid78      * RESUTILS                       000007FEF3C20000  000007FEF3C38FFF  00019000
    2015-11-26 13:37:48.15 spid78      * cscapi                         000007FEF3C50000  000007FEF3C5EFFF  0000f000
    2015-11-26 13:37:48.15 spid78      * sqlevn70                       000000006BA80000  000000006BB6BFFF  000ec000
    2015-11-26 13:37:48.15 spid78      * sqlevn70                       000000006B510000  000000006B710FFF  00201000
    2015-11-26 13:37:48.15 spid78      * CRYPTSP                        000007FEFC7F0000  000007FEFC807FFF  00018000
    2015-11-26 13:37:48.15 spid78      * rsaenh                         000007FEFC4F0000  000007FEFC536FFF  00047000
    2015-11-26 13:37:48.15 spid78      * CRYPTBASE                      000007FEFCE90000  000007FEFCE9EFFF  0000f000
    2015-11-26 13:37:48.15 spid78      * BROWCLI                        000007FEF4350000  000007FEF4361FFF  00012000
    2015-11-26 13:37:48.15 spid78      * AUTHZ                          000007FEFC9C0000  000007FEFC9EEFFF  0002f000
    2015-11-26 13:37:48.15 spid78      * MSCOREE                        000007FEF94B0000  000007FEF951EFFF  0006f000
    2015-11-26 13:37:48.15 spid78      * ole32                          000007FEFDA50000  000007FEFDC52FFF  00203000
    2015-11-26 13:37:48.15 spid78      * credssp                        000007FEFC3F0000  000007FEFC3F9FFF  0000a000
    2015-11-26 13:37:48.15 spid78      * msv1_0                         000007FEFC720000  000007FEFC771FFF  00052000
    2015-11-26 13:37:48.15 spid78      * kerberos                       000007FEFC810000  000007FEFC8C7FFF  000b8000
    2015-11-26 13:37:48.15 spid78      * MSASN1                         000007FEFD000000  000007FEFD00EFFF  0000f000
    2015-11-26 13:37:48.15 spid78      * schannel                       000007FEFC580000  000007FEFC5D6FFF  00057000
    2015-11-26 13:37:48.16 spid78      * CRYPT32                        000007FEFD050000  000007FEFD1BCFFF  0016d000
    2015-11-26 13:37:48.16 spid78      * WS2_32                         000007FEFEDA0000  000007FEFEDECFFF  0004d000
    2015-11-26 13:37:48.16 spid78      * mswsock                        000007FEFC790000  000007FEFC7E4FFF  00055000
    2015-11-26 13:37:48.16 spid78      * wshtcpip                       000007FEFC190000  000007FEFC196FFF  00007000
    2015-11-26 13:37:48.16 spid78      * wship6                         000007FEFC780000  000007FEFC786FFF  00007000
    2015-11-26 13:37:48.16 spid78      * DNSAPI                         000007FEFC610000  000007FEFC66AFFF  0005b000
    2015-11-26 13:37:48.16 spid78      * rasadhlp                       000007FEFA430000  000007FEFA437FFF  00008000
    2015-11-26 13:37:48.16 spid78      * fwpuclnt                       000007FEFA610000  000007FEFA662FFF  00053000
    2015-11-26 13:37:48.16 spid78      * security                       0000000070CA0000  0000000070CA2FFF  00003000
    2015-11-26 13:37:48.16 spid78      * OLEAUT32                       000007FEFEE90000  000007FEFEF66FFF  000d7000
    2015-11-26 13:37:48.16 spid78      * ftimport                       0000000060000000  0000000060024FFF  00025000
    2015-11-26 13:37:48.16 spid78      * MSFTE                          0000000049980000  0000000049D2DFFF  003ae000
    2015-11-26 13:37:48.16 spid78      * VERSION                        000007FEFC090000  000007FEFC09BFFF  0000c000
    2015-11-26 13:37:48.16 spid78      * dbghelp                        000000006B7D0000  000000006B92DFFF  0015e000
    2015-11-26 13:37:48.16 spid78      * WINTRUST                       000007FEFD330000  000007FEFD36AFFF  0003b000
    2015-11-26 13:37:48.16 spid78      * ntmarta                        000007FEFC0A0000  000007FEFC0CCFFF  0002d000
    2015-11-26 13:37:48.16 spid78      * WLDAP32                        000007FEFECC0000  000007FEFED11FFF  00052000
    2015-11-26 13:37:48.16 spid78      * ncrypt                         000007FEFC970000  000007FEFC9BFFFF  00050000
    2015-11-26 13:37:48.16 spid78      * bcrypt                         000007FEFC940000  000007FEFC961FFF  00022000
    2015-11-26 13:37:48.16 spid78      * ntdsapi                        000007FEF9C50000  000007FEF9C76FFF  00027000
    2015-11-26 13:37:48.16 spid78      * bcryptprimitives               000007FEFC430000  000007FEFC47BFFF  0004c000
    2015-11-26 13:37:48.16 spid78      * SAMLIB                         000007FEFAC80000  000007FEFAC9CFFF  0001d000
    2015-11-26 13:37:48.16 spid78      * apphelp                        000007FEFCDF0000  000007FEFCE46FFF  00057000
    2015-11-26 13:37:48.16 spid78      * CLBCatQ                        000007FEFD8D0000  000007FEFD968FFF  00099000
    2015-11-26 13:37:48.16 spid78      * sqlncli10                      000000006AA20000  000000006ACD7FFF  002b8000
    2015-11-26 13:37:48.16 spid78      * COMCTL32                       000007FEF3B40000  000007FEF3BDFFFF  000a0000
    2015-11-26 13:37:48.16 spid78      * COMDLG32                       000007FEFEDF0000  000007FEFEE86FFF  00097000
    2015-11-26 13:37:48.16 spid78      * SHELL32                        000007FEFDF30000  000007FEFECB8FFF  00d89000
    2015-11-26 13:37:48.16 spid78      * SQLNCLIR10                     000000006FC00000  000000006FC26FFF  00027000
    2015-11-26 13:37:48.16 spid78      * netbios                        000007FEF1270000  000007FEF1279FFF  0000a000
    2015-11-26 13:37:48.16 spid78      * xpsqlbot                       000000006DC20000  000000006DC27FFF  00008000
    2015-11-26 13:37:48.16 spid78      * xpstar                         000000006CA60000  000000006CAE7FFF  00088000
    2015-11-26 13:37:48.16 spid78      * SQLSCM                         0000000070660000  000000007066DFFF  0000e000
    2015-11-26 13:37:48.16 spid78      * ODBC32                         000007FEF2CF0000  000007FEF2DA0FFF  000b1000
    2015-11-26 13:37:48.16 spid78      * ATL80                          0000000074920000  000000007493FFFF  00020000
    2015-11-26 13:37:48.16 spid78      * odbcint                        0000000071CF0000  0000000071D27FFF  00038000
    2015-11-26 13:37:48.16 spid78      * xpstar                         000000006D9C0000  000000006D9E0FFF  00021000
    2015-11-26 13:37:48.16 spid78      * xplog70                        000000006DC10000  000000006DC1FFFF  00010000
    2015-11-26 13:37:48.16 spid78      * xplog70                        000000006D9B0000  000000006D9B1FFF  00002000
    2015-11-26 13:37:48.16 spid78      * sqlvdi                         00000000713E0000  000000007140BFFF  0002c000
    2015-11-26 13:37:48.16 spid78      * dsrole                         000007FEFBBB0000  000007FEFBBBBFFF  0000c000
    2015-11-26 13:37:48.16 spid78      * oledb32                        000007FEF1440000  000007FEF154DFFF  0010e000
    2015-11-26 13:37:48.16 spid78      * MSDART                         000007FEF2DD0000  000007FEF2DF7FFF  00028000
    2015-11-26 13:37:48.16 spid78      * Comctl32                       000007FEFB9B0000  000007FEFBBA3FFF  001f4000
    2015-11-26 13:37:48.16 spid78      * OLEDB32R                       0000000071640000  0000000071653FFF  00014000
    2015-11-26 13:37:48.16 spid78      * comsvcs                        000007FEF0420000  000007FEF05CFFFF  001b0000
    2015-11-26 13:37:48.16 spid78      * RpcRtRemote                    000007FEFCF40000  000007FEFCF53FFF  00014000
    2015-11-26 13:37:48.16 spid78      * instapi                        00000000099A0000  00000000099ACFFF  0000d000
    2015-11-26 13:37:48.16 spid78      * dbghelp                        0000000070500000  000000007065DFFF  0015e000
    2015-11-26 13:37:48.16 spid78      *
    2015-11-26 13:37:48.16 spid78      *     P1Home: 002E0037002E0032: 
    2015-11-26 13:37:48.16 spid78      *     P2Home: 0000000000000030: 
    2015-11-26 13:37:48.16 spid78      *     P3Home: 00000000004BDD80:  00000009BE2152A0  0000000000000000  00000008B4066430  00000008B40665E0  00000000460808C0  00000008E13A6BC0 
    2015-11-26 13:37:48.16 spid78      *     P4Home: 0000000000000000: 
    2015-11-26 13:37:48.16 spid78      *     P5Home: 0000000C00680066: 
    2015-11-26 13:37:48.16 spid78      *     P6Home: 00000008E13EBAD8:  004D005C003A0047  004C005100530053  0035005F00300031  0053004D002E0030  0053004C00510053  0045005600520045 
    2015-11-26 13:37:48.16 spid78      * ContextFlags: 000000000010000F: 
    2015-11-26 13:37:48.16 spid78      *      MxCsr: 0000000000001FA0: 
    2015-11-26 13:37:48.16 spid78      *      SegCs: 0000000000000033: 
    2015-11-26 13:37:48.16 spid78      *      SegDs: 000000000000002B: 
    2015-11-26 13:37:48.16 spid78      *      SegEs: 000000000000002B: 
    2015-11-26 13:37:48.16 spid78      *      SegFs: 0000000000000053: 
    2015-11-26 13:37:48.16 spid78      *      SegGs: 000000000000002B: 
    2015-11-26 13:37:48.16 spid78      *      SegSs: 000000000000002B: 
    2015-11-26 13:37:48.16 spid78      *     EFlags: 0000000000000206: 
    2015-11-26 13:37:48.16 spid78      *        Rax: 00000008E18967E4: 
    2015-11-26 13:37:48.16 spid78      *        Rcx: 00000008940A61A0:  002E0037002E0032  0000000000000030  00000000004BDD80  0000000000000000  0000000C00680066  00000008E13EBAD8 
    2015-11-26 13:37:48.16 spid78      *        Rdx: 0000000000000000: 
    2015-11-26 13:37:48.16 spid78      *        Rbx: 0000000000000000: 
    2015-11-26 13:37:48.16 spid78      *        Rsp: 00000008940A67B0:  0000000000000000  00000002CDC8A460  00000008940A69E0  000007FFFFC50000  00000000000042AC  0000000000000000 
    2015-11-26 13:37:48.16 spid78      *        Rbp: 0000000002F6863B:  0030250C8B486590  D46E34058B480000  0000C0018C8B4800  00009024848B4800  000003D081894800  000030250C8B4865 
    2015-11-26 13:37:48.16 spid78      *        Rsi: 00000002CDC8A460:  00000002CDC8A460  00000003D3574EA0  0000000000000000  0000000000000004  00000002CDC8A480  00000002CDC8A480 
    2015-11-26 13:37:48.16 spid78      *        Rdi: 00000008940A69E0:  00000008E13EBAD0  00390034002D0065  00000000FFFFFFFE  00000008940A6A88  00000008940A6A76  0000000000B70000 
    2015-11-26 13:37:48.16 spid78      *         R8: 0000000000000000: 
    2015-11-26 13:37:48.16 spid78      *         R9: 0000000000000000: 
    2015-11-26 13:37:48.16 spid78      *        R10: 0000000000000000: 
    2015-11-26 13:37:48.16 spid78      *        R11: 00000008940A6FC0:  002E0037002E0032  0000000000000030  00000000004BDD80  0000000000000000  0000000C00680066  00000008E13EBAD8 
    2015-11-26 13:37:48.16 spid78      *        R12: 0000000000000001: 
    2015-11-26 13:37:48.16 spid78      *        R13: 00000003D3574EA0:  00000003D3574080  00000003D35743B0  00000003D3574AD0  00000008940AAD60  00000003D3574F10  00000003E9ECBBA0 
    2015-11-26 13:37:48.16 spid78      *        R14: 00000008940A7F60:  0072005F00780065  0065007300690061  00450020003A0032  0070006500630078  006E006F00690074  0069006100720020 
    2015-11-26 13:37:48.16 spid78      *        R15: 00000000FFFFFFFF:  0082000000030100  0000000000000001  0100000000000000  D600280000001E00  000001002E4BAF1F  002A91000042A600 
    2015-11-26 13:37:48.16 spid78      *        Rip: 000007FEFD1C940D:  C3000000C8C48148  9090909090909090  8348C48B48909090  FFFFFEC0F74178EC  480001631C850FFF  4810708948085889 
    2015-11-26 13:37:48.16 spid78      * *******************************************************************************
    2015-11-26 13:37:48.16 spid78      * -------------------------------------------------------------------------------
    2015-11-26 13:37:48.16 spid78      * Short Stack Dump
    2015-11-26 13:37:48.17 spid78      000007FEFD1C940D Module(KERNELBASE+000000000000940D)
    2015-11-26 13:37:48.17 spid78      0000000002C1981D Module(sqlservr+00000000020A981D)
    2015-11-26 13:37:48.17 spid78      0000000002C1DD3A Module(sqlservr+00000000020ADD3A)
    2015-11-26 13:37:48.17 spid78      0000000002C1D89D Module(sqlservr+00000000020AD89D)
    2015-11-26 13:37:48.18 spid78      0000000001449E6E Module(sqlservr+00000000008D9E6E)
    2015-11-26 13:37:48.18 spid78      0000000000F6F2A6 Module(sqlservr+00000000003FF2A6)
    2015-11-26 13:37:48.18 spid78      0000000002F6863B Module(sqlservr+00000000023F863B)
    2015-11-26 13:37:48.18 spid78      000000000136E114 Module(sqlservr+00000000007FE114)
    2015-11-26 13:37:48.18 spid78      0000000000C4D11C Module(sqlservr+00000000000DD11C)
    2015-11-26 13:37:48.18 spid78      0000000000C43830 Module(sqlservr+00000000000D3830)
    2015-11-26 13:37:48.18 spid78      0000000000BA908B Module(sqlservr+000000000003908B)
    2015-11-26 13:37:48.18 spid78      0000000000BC0D2F Module(sqlservr+0000000000050D2F)
    2015-11-26 13:37:48.18 spid78      0000000000C6C567 Module(sqlservr+00000000000FC567)
    2015-11-26 13:37:48.18 spid78      0000000000C6C70F Module(sqlservr+00000000000FC70F)
    2015-11-26 13:37:48.18 spid78      0000000000C05997 Module(sqlservr+0000000000095997)
    2015-11-26 13:37:48.18 spid78      0000000000C05BD5 Module(sqlservr+0000000000095BD5)
    2015-11-26 13:37:48.18 spid78      0000000000BAF58D Module(sqlservr+000000000003F58D)
    2015-11-26 13:37:48.19 spid78      0000000000BB19E2 Module(sqlservr+00000000000419E2)
    2015-11-26 13:37:48.19 spid78      0000000000C100BC Module(sqlservr+00000000000A00BC)
    2015-11-26 13:37:48.19 spid78      0000000000C101BA Module(sqlservr+00000000000A01BA)
    2015-11-26 13:37:48.19 spid78      0000000000C09A76 Module(sqlservr+0000000000099A76)
    2015-11-26 13:37:48.19 spid78      0000000000C0984B Module(sqlservr+000000000009984B)
    2015-11-26 13:37:48.19 spid78      0000000000C0A7E4 Module(sqlservr+000000000009A7E4)
    2015-11-26 13:37:48.19 spid78      0000000000BC9D59 Module(sqlservr+0000000000059D59)
    2015-11-26 13:37:48.19 spid78      0000000000BCA9B8 Module(sqlservr+000000000005A9B8)
    2015-11-26 13:37:48.19 spid78      0000000000BCB30C Module(sqlservr+000000000005B30C)
    2015-11-26 13:37:48.19 spid78      00000000027CF456 Module(sqlservr+0000000001C5F456)
    2015-11-26 13:37:48.19 spid78      00000000027C957A Module(sqlservr+0000000001C5957A)
    2015-11-26 13:37:48.21 spid78      00000000027CC744 Module(sqlservr+0000000001C5C744)
    2015-11-26 13:37:48.21 spid78      00000000024DFB13 Module(sqlservr+000000000196FB13)
    2015-11-26 13:37:48.21 spid78      000000000127DF9A Module(sqlservr+000000000070DF9A)
    2015-11-26 13:37:48.21 spid78      0000000000E2E531 Module(sqlservr+00000000002BE531)
    2015-11-26 13:37:48.21 spid78      0000000000E2E8FD Module(sqlservr+00000000002BE8FD)
    2015-11-26 13:37:48.21 spid78      0000000000E2EE92 Module(sqlservr+00000000002BEE92)
    2015-11-26 13:37:48.21 spid78      0000000000E18F7D Module(sqlservr+00000000002A8F7D)
    2015-11-26 13:37:48.21 spid78      0000000000DF99F7 Module(sqlservr+00000000002899F7)
    2015-11-26 13:37:48.21 spid78      0000000000DF9916 Module(sqlservr+0000000000289916)
    2015-11-26 13:37:48.21 spid78      0000000000DF9916 Module(sqlservr+0000000000289916)
    2015-11-26 13:37:48.22 spid78      0000000000DF92D1 Module(sqlservr+00000000002892D1)
    2015-11-26 13:37:48.22 spid78      0000000000E0E2CF Module(sqlservr+000000000029E2CF)
    2015-11-26 13:37:48.22 spid78      0000000000E0DC08 Module(sqlservr+000000000029DC08)
    2015-11-26 13:37:48.22 spid78      0000000000DEEAA1 Module(sqlservr+000000000027EAA1)
    2015-11-26 13:37:48.22 spid78      0000000000DEDA30 Module(sqlservr+000000000027DA30)
    2015-11-26 13:37:48.22 spid78      0000000000E86AFC Module(sqlservr+0000000000316AFC)
    2015-11-26 13:37:48.22 spid78      0000000000D4E606 Module(sqlservr+00000000001DE606)
    2015-11-26 13:37:48.22 spid78      0000000000D4F85E Module(sqlservr+00000000001DF85E)
    2015-11-26 13:37:48.22 spid78      0000000000D4FE19 Module(sqlservr+00000000001DFE19)
    2015-11-26 13:37:48.22 spid78      0000000000D4FCBF Module(sqlservr+00000000001DFCBF)
    2015-11-26 13:37:48.22 spid78      0000000000BCB203 Module(sqlservr+000000000005B203)
    2015-11-26 13:37:48.22 spid78      0000000000BCC1A6 Module(sqlservr+000000000005C1A6)
    2015-11-26 13:37:48.22 spid78      0000000000C15342 Module(sqlservr+00000000000A5342)
    2015-11-26 13:37:48.23 spid78      0000000000B7BBD8 Module(sqlservr+000000000000BBD8)
    2015-11-26 13:37:48.23 spid78      0000000000B7B8BA Module(sqlservr+000000000000B8BA)
    2015-11-26 13:37:48.23 spid78      0000000000B7B6FF Module(sqlservr+000000000000B6FF)
    2015-11-26 13:37:48.23 spid78      0000000001098FB6 Module(sqlservr+0000000000528FB6)
    2015-11-26 13:37:48.23 spid78      0000000001099175 Module(sqlservr+0000000000529175)
    2015-11-26 13:37:48.23 spid78      0000000001099839 Module(sqlservr+0000000000529839)
    2015-11-26 13:37:48.24 spid78      0000000001099502 Module(sqlservr+0000000000529502)
    2015-11-26 13:37:48.24 spid78      0000000074CB37D7 Module(MSVCR80+00000000000037D7)
    2015-11-26 13:37:48.24 spid78      0000000074CB3894 Module(MSVCR80+0000000000003894)
    2015-11-26 13:37:48.25 spid78      00000000770259ED Module(kernel32+00000000000159ED)
    2015-11-26 13:37:48.25 spid78      000000007725C541 Module(ntdll+000000000002C541)
    2015-11-26 13:37:48.34 spid78      * -------------------------------------------------------------------------------
    2015-11-26 13:37:48.34 spid78      Stack Signature for the dump is 0x000000016CCDBC68
    2015-11-26 13:37:53.61 登录          Login succeeded for user 'GXuser'. Connection made using SQL Server authentication. [客户端: 10.33.66.26]
    2015-11-26 13:37:53.61 登录          Login succeeded for user 'GXuser'. Connection made using SQL Server authentication. [客户端: 10.33.66.26]
    2015-11-26 13:37:53.62 登录          Login succeeded for user 'GXuser'. Connection made using SQL Server authentication. [客户端: 10.33.66.26]
    2015-11-26 13:37:53.63 登录          Login succeeded for user 'GXuser'. Connection made using SQL Server authentication. [客户端: 10.33.66.26]
    2015-11-26 13:37:53.64 登录          Login succeeded for user 'GXuser'. Connection made using SQL Server authentication. [客户端: 10.33.66.26]
    2015-11-26 13:37:53.65 登录          Login succeeded for user 'GXuser'. Connection made using SQL Server authentication. [客户端: 10.33.66.26]
    2015-11-26 13:37:53.66 登录          Login succeeded for user 'GXuser'. Connection made using SQL Server authentication. [客户端: 10.33.66.26]
    2015-11-26 13:37:53.66 登录          Login succeeded for user 'GXuser'. Connection made using SQL Server authentication. [客户端: 10.33.66.26]
    2015-11-26 13:37:53.67 登录          Login succeeded for user 'GXuser'. Connection made using SQL Server authentication. [客户端: 10.33.66.26]
    2015-11-26 13:37:53.69 spid78      External dump process return code 0x20000001.
    External dump process returned no errors.

    2015年11月27日 3:44

全部回复

  • 故障时查询下有多少线程、工作队列、内存状况是如何的

    Try SQL Server 2008 QQ:315054403 dgdba@hotmail.com

    2015年11月27日 4:54
  • Dup post: https://social.msdn.microsoft.com/Forums/zh-CN/cf604c38-88ea-4dbd-810f-71329bb1ea20/-exception-raised-major52-minor42-state3-severity22?forum=sqlserverzhchs
    2015年11月28日 0:35