Usuario
Agente SQL

Pregunta
-
Estimados.
En un SS2008 R2, sucede que el agente se detiene de manera inesperada, ya parchar con SP3, pero el problema sigue.
El usuario del agente es sysadmin y admeas pertenece al grupo administrator del S.O (W2003), por falta de tiempo no hemos podido actualizar las versiones de SQL y de S.O.
El error en el SQL dice:
Particularmente anoche, el ultimo respaldo en el registro de log fue a las 5:14 Am y a las 05:46 indica:
Debo entender que faltan recursos:
Origen spid53
Mensaje
***Stack Dump being sent to E:\Data\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\SQLDump0270.txtEn una de las filas indica:
2019-10-23 05:46:42.22 spid53 * Input Buffer 60 bytes -
2019-10-23 05:46:42.22 spid53 * Exec p_parametriza 1315El archivo txt es el siguiente:
2019-10-23 05:46:42.22 spid53 ***Stack Dump being sent to E:\Data\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\SQLDump0270.txt
2019-10-23 05:46:42.22 spid53 SqlDumpExceptionHandler: Process 53 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2019-10-23 05:46:42.22 spid53 * *******************************************************************************
2019-10-23 05:46:42.22 spid53 *
2019-10-23 05:46:42.22 spid53 * BEGIN STACK DUMP:
2019-10-23 05:46:42.22 spid53 * 10/23/19 05:46:42 spid 53
2019-10-23 05:46:42.22 spid53 *
2019-10-23 05:46:42.22 spid53 *
2019-10-23 05:46:42.22 spid53 * Exception Address = 000000007741A365 Module(ntdll+000000000002A365)
2019-10-23 05:46:42.22 spid53 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2019-10-23 05:46:42.22 spid53 * Access Violation occurred reading address 00000830D0B045E8
2019-10-23 05:46:42.22 spid53 * Input Buffer 60 bytes -
2019-10-23 05:46:42.22 spid53 * Exec p_parametriza 1315
2019-10-23 05:46:42.22 spid53 *
2019-10-23 05:46:42.22 spid53 *
2019-10-23 05:46:42.22 spid53 * MODULE BASE END SIZE
2019-10-23 05:46:42.22 spid53 * sqlservr 0000000000610000 000000000422FFFF 03c20000
2019-10-23 05:46:42.22 spid53 * ntdll 00000000773F0000 000000007758EFFF 0019f000
2019-10-23 05:46:42.22 spid53 * kernel32 00000000771D0000 00000000772EEFFF 0011f000
2019-10-23 05:46:42.22 spid53 * KERNELBASE 000007FEFD460000 000007FEFD4C9FFF 0006a000
2019-10-23 05:46:42.22 spid53 * ADVAPI32 000007FEFDB80000 000007FEFDC5AFFF 000db000
2019-10-23 05:46:42.22 spid53 * msvcrt 000007FEFDD70000 000007FEFDE0EFFF 0009f000
2019-10-23 05:46:42.22 spid53 * sechost 000007FEFE410000 000007FEFE42EFFF 0001f000
2019-10-23 05:46:42.22 spid53 * RPCRT4 000007FEFD580000 000007FEFD6ABFFF 0012c000
2019-10-23 05:46:42.22 spid53 * MSVCR80 0000000074DC0000 0000000074E88FFF 000c9000
2019-10-23 05:46:42.22 spid53 * MSVCP80 0000000074A30000 0000000074B38FFF 00109000
2019-10-23 05:46:42.22 spid53 * sqlos 0000000074950000 0000000074956FFF 00007000
2019-10-23 05:46:42.22 spid53 * Secur32 000007FEFCD30000 000007FEFCD3AFFF 0000b000
2019-10-23 05:46:42.22 spid53 * SSPICLI 000007FEFCEE0000 000007FEFCF04FFF 00025000
2019-10-23 05:46:42.22 spid53 * pdh 000007FEF4940000 000007FEF498DFFF 0004e000
2019-10-23 05:46:42.22 spid53 * SHLWAPI 000007FEFD500000 000007FEFD570FFF 00071000
2019-10-23 05:46:42.22 spid53 * GDI32 000007FEFDC60000 000007FEFDCC6FFF 00067000
2019-10-23 05:46:42.22 spid53 * USER32 00000000772F0000 00000000773E9FFF 000fa000
2019-10-23 05:46:42.22 spid53 * LPK 000007FEFDB40000 000007FEFDB4DFFF 0000e000
2019-10-23 05:46:42.22 spid53 * USP10 000007FEFE2F0000 000007FEFE3BAFFF 000cb000
2019-10-23 05:46:42.22 spid53 * USERENV 000007FEFD220000 000007FEFD23DFFF 0001e000
2019-10-23 05:46:42.22 spid53 * profapi 000007FEFD110000 000007FEFD11EFFF 0000f000
2019-10-23 05:46:42.22 spid53 * WINMM 000007FEF9250000 000007FEF928AFFF 0003b000
2019-10-23 05:46:42.22 spid53 * IPHLPAPI 000007FEFA8F0000 000007FEFA916FFF 00027000
2019-10-23 05:46:42.22 spid53 * NSI 000007FEFD4F0000 000007FEFD4F7FFF 00008000
2019-10-23 05:46:42.22 spid53 * WINNSI 000007FEFAAA0000 000007FEFAAAAFFF 0000b000
2019-10-23 05:46:42.22 spid53 * opends60 0000000074990000 0000000074997FFF 00008000
2019-10-23 05:46:42.22 spid53 * NETAPI32 000007FEFBC20000 000007FEFBC35FFF 00016000
2019-10-23 05:46:42.22 spid53 * netutils 000007FEFC490000 000007FEFC49BFFF 0000c000
2019-10-23 05:46:42.22 spid53 * srvcli 000007FEFCB80000 000007FEFCBA2FFF 00023000
2019-10-23 05:46:42.22 spid53 * wkscli 000007FEFB9C0000 000007FEFB9D4FFF 00015000
2019-10-23 05:46:42.22 spid53 * LOGONCLI 000007FEFC980000 000007FEFC9AFFFF 00030000
2019-10-23 05:46:42.22 spid53 * SAMCLI 000007FEF9B80000 000007FEF9B93FFF 00014000
2019-10-23 05:46:42.22 spid53 * BatchParser 00000000748F0000 000000007491CFFF 0002d000
2019-10-23 05:46:42.22 spid53 * IMM32 000007FEFDB50000 000007FEFDB7DFFF 0002e000
2019-10-23 05:46:42.22 spid53 * MSCTF 000007FEFF4F0000 000007FEFF5F8FFF 00109000
2019-10-23 05:46:42.22 spid53 * psapi 0000000077590000 0000000077596FFF 00007000
2019-10-23 05:46:42.22 spid53 * instapi10 0000000074980000 000000007498CFFF 0000d000
2019-10-23 05:46:42.22 spid53 * cscapi 000007FEF4A20000 000007FEF4A2EFFF 0000f000
2019-10-23 05:46:42.22 spid53 * sqlevn70 0000000073FD0000 00000000741D3FFF 00204000
2019-10-23 05:46:42.22 spid53 * ntmarta 000007FEFC1A0000 000007FEFC1CCFFF 0002d000
2019-10-23 05:46:42.22 spid53 * WLDAP32 000007FEFE430000 000007FEFE481FFF 00052000
2019-10-23 05:46:42.22 spid53 * CRYPTSP 000007FEFC9B0000 000007FEFC9C7FFF 00018000
2019-10-23 05:46:42.22 spid53 * rsaenh 000007FEFC5B0000 000007FEFC5F6FFF 00047000
2019-10-23 05:46:42.22 spid53 * CRYPTBASE 000007FEFCF70000 000007FEFCF7EFFF 0000f000
2019-10-23 05:46:42.22 spid53 * BROWCLI 000007FEF9AA0000 000007FEF9AB1FFF 00012000
2019-10-23 05:46:42.22 spid53 * AUTHZ 000007FEFCA20000 000007FEFCA4EFFF 0002f000
2019-10-23 05:46:42.22 spid53 * MSCOREE 000007FEF83B0000 000007FEF841EFFF 0006f000
2019-10-23 05:46:42.22 spid53 * mscoreei 000007FEF8210000 000007FEF82B8FFF 000a9000
2019-10-23 05:46:42.22 spid53 * api-ms-win-core-synch-l1-2-0 000007FEF8D30000 000007FEF8D32FFF 00003000
2019-10-23 05:46:42.22 spid53 * ole32 000007FEFE0F0000 000007FEFE2EEFFF 001ff000
2019-10-23 05:46:42.22 spid53 * credssp 000007FEFC4C0000 000007FEFC4C9FFF 0000a000
2019-10-23 05:46:42.22 spid53 * msv1_0 000007FEFC7B0000 000007FEFC801FFF 00052000
2019-10-23 05:46:42.22 spid53 * cryptdll 000007FEFCBB0000 000007FEFCBC3FFF 00014000
2019-10-23 05:46:42.22 spid53 * kerberos 000007FEFC810000 000007FEFC8C8FFF 000b9000
2019-10-23 05:46:42.22 spid53 * MSASN1 000007FEFD120000 000007FEFD12EFFF 0000f000
2019-10-23 05:46:42.22 spid53 * schannel 000007FEFC640000 000007FEFC697FFF 00058000
2019-10-23 05:46:42.22 spid53 * CRYPT32 000007FEFD280000 000007FEFD3ECFFF 0016d000
2019-10-23 05:46:42.22 spid53 * security 0000000074650000 0000000074652FFF 00003000
2019-10-23 05:46:42.22 spid53 * WS2_32 000007FEFE3C0000 000007FEFE40CFFF 0004d000
2019-10-23 05:46:42.22 spid53 * SHELL32 000007FEFE490000 000007FEFF21AFFF 00d8b000
2019-10-23 05:46:42.22 spid53 * OLEAUT32 000007FEFF600000 000007FEFF6DAFFF 000db000
2019-10-23 05:46:42.22 spid53 * ftimport 0000000060000000 0000000060024FFF 00025000
2019-10-23 05:46:42.22 spid53 * MSFTE 0000000049980000 0000000049D2DFFF 003ae000
2019-10-23 05:46:42.22 spid53 * VERSION 000007FEFC1D0000 000007FEFC1DBFFF 0000c000
2019-10-23 05:46:42.22 spid53 * dbghelp 0000000074790000 00000000748EDFFF 0015e000
2019-10-23 05:46:42.22 spid53 * WINTRUST 000007FEFD240000 000007FEFD27AFFF 0003b000
2019-10-23 05:46:42.22 spid53 * ncrypt 000007FEFC9D0000 000007FEFCA1FFFF 00050000
2019-10-23 05:46:42.22 spid53 * bcrypt 000007FEFCAE0000 000007FEFCB01FFF 00022000
2019-10-23 05:46:42.22 spid53 * mswsock 000007FEFC8D0000 000007FEFC924FFF 00055000
2019-10-23 05:46:42.22 spid53 * wship6 000007FEFCA60000 000007FEFCA66FFF 00007000
2019-10-23 05:46:42.22 spid53 * wshtcpip 000007FEFC2A0000 000007FEFC2A6FFF 00007000
2019-10-23 05:46:42.22 spid53 * ntdsapi 000007FEFA0F0000 000007FEFA116FFF 00027000
2019-10-23 05:46:42.22 spid53 * DNSAPI 000007FEFC6A0000 000007FEFC6FAFFF 0005b000
2019-10-23 05:46:42.22 spid53 * rasadhlp 000007FEFA160000 000007FEFA167FFF 00008000
2019-10-23 05:46:42.22 spid53 * fwpuclnt 000007FEFA7B0000 000007FEFA802FFF 00053000
2019-10-23 05:46:42.22 spid53 * bcryptprimitives 000007FEFC930000 000007FEFC97BFFF 0004c000
2019-10-23 05:46:42.22 spid53 * SAMLIB 000007FEF9B60000 000007FEF9B7CFFF 0001d000
2019-10-23 05:46:42.22 spid53 * CLBCatQ 000007FEFD730000 000007FEFD7C8FFF 00099000
2019-10-23 05:46:42.22 spid53 * sqlncli10 0000000073D10000 0000000073FCCFFF 002bd000
2019-10-23 05:46:42.22 spid53 * COMCTL32 000007FEF21F0000 000007FEF228FFFF 000a0000
2019-10-23 05:46:42.22 spid53 * COMDLG32 000007FEFDCD0000 000007FEFDD66FFF 00097000
2019-10-23 05:46:42.22 spid53 * SQLNCLIR10 0000000074750000 0000000074786FFF 00037000
2019-10-23 05:46:42.22 spid53 * xplog70 0000000074920000 000000007492FFFF 00010000
2019-10-23 05:46:42.22 spid53 * xplog70 0000000074740000 0000000074741FFF 00002000
2019-10-23 05:46:42.22 spid53 * xpstar 0000000074200000 0000000074287FFF 00088000
2019-10-23 05:46:42.22 spid53 * SQLSCM 0000000074730000 000000007473DFFF 0000e000
2019-10-23 05:46:42.22 spid53 * ODBC32 000007FEFB200000 000007FEFB2B0FFF 000b1000
2019-10-23 05:46:42.22 spid53 * ATL80 0000000074D70000 0000000074D8FFFF 00020000
2019-10-23 05:46:42.22 spid53 * odbcint 0000000073B30000 0000000073B67FFF 00038000
2019-10-23 05:46:42.22 spid53 * clusapi 000007FEF2B40000 000007FEF2B8FFFF 00050000
2019-10-23 05:46:42.22 spid53 * resutils 000007FEF2AA0000 000007FEF2AB8FFF 00019000
2019-10-23 05:46:42.22 spid53 * xpstar 0000000073810000 0000000073834FFF 00025000
2019-10-23 05:46:42.22 spid53 * oledb32 000007FEFAFD0000 000007FEFB0DDFFF 0010e000
2019-10-23 05:46:42.22 spid53 * MSDART 000007FEFB450000 000007FEFB477FFF 00028000
2019-10-23 05:46:42.22 spid53 * Comctl32 000007FEFB9E0000 000007FEFBBD4FFF 001f5000
2019-10-23 05:46:42.22 spid53 * OLEDB32R 0000000074710000 0000000074723FFF 00014000
2019-10-23 05:46:42.22 spid53 * comsvcs 000007FEF1D50000 000007FEF1F00FFF 001b1000
2019-10-23 05:46:42.22 spid53 * msdasql 000007FEFB140000 000007FEFB1F5FFF 000b6000
2019-10-23 05:46:42.22 spid53 * MSDATL3 000007FEFB430000 000007FEFB44FFFF 00020000
2019-10-23 05:46:42.22 spid53 * MSDASQLR 00000000741F0000 00000000741FEFFF 0000f000
2019-10-23 05:46:42.22 spid53 * RpcRtRemote 000007FEFD020000 000007FEFD033FFF 00014000
2019-10-23 05:46:42.22 spid53 * myodbc5a 000007FEF0680000 000007FEF0C36FFF 005b7000
2019-10-23 05:46:42.22 spid53 * MSVCR120 000007FEF1430000 000007FEF151EFFF 000ef000
2019-10-23 05:46:42.22 spid53 * odbccp32 000007FEFB400000 000007FEFB427FFF 00028000
2019-10-23 05:46:42.22 spid53 * NLAapi 000007FEFBC00000 000007FEFBC14FFF 00015000
2019-10-23 05:46:42.22 spid53 * napinsp 000007FEFA120000 000007FEFA134FFF 00015000
2019-10-23 05:46:42.22 spid53 * winrnr 000007FEFA150000 000007FEFA15AFFF 0000b000
2019-10-23 05:46:42.22 spid53 * xpsqlbot 0000000071000000 0000000071007FFF 00008000
2019-10-23 05:46:42.22 spid53 * dsrole 000007FEFB8C0000 000007FEFB8CBFFF 0000c000
2019-10-23 05:46:42.22 spid53 * instapi 0000000048060000 000000004806CFFF 0000d000
2019-10-23 05:46:42.22 spid53 * apphelp 000007FEFCF10000 000007FEFCF66FFF 00057000
2019-10-23 05:46:42.22 spid53 * msxmlsql 0000000073520000 0000000073670FFF 00151000
2019-10-23 05:46:42.22 spid53 * dbghelp 00000000736B0000 000000007380DFFF 0015e000
2019-10-23 05:46:42.22 spid53 *
2019-10-23 05:46:42.22 spid53 * P1Home: 000000002233D1B0: 00000000C0000005 0000000000000000 000000007741A365 0000000000000002 0000000000000000 00000830D0B045E8
2019-10-23 05:46:42.22 spid53 * P2Home: 000000002233CCC0: 000000002233D1B0 000000002233CCC0 0000000000000000 0000000000000000 000000001D900000 000000001D951CF0
2019-10-23 05:46:42.22 spid53 * P3Home: 0000000000000000:
2019-10-23 05:46:42.22 spid53 * P4Home: 0000000000000000:
2019-10-23 05:46:42.22 spid53 * P5Home: 000000001D900000: 0000000000000000 010016FFF21EED9A 00000000FFEEFFEE 0000000004DD0018 000000001D900128 000000001D900000
2019-10-23 05:46:42.22 spid53 * P6Home: 000000001D951CF0: 000000001D94BC30 C8B522BE00000001 AA00E5AD11CE5CF3 000000003D774400 0000000000000000 9000008316571E02
2019-10-23 05:46:42.22 spid53 * ContextFlags: 000000000010001F: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2019-10-23 05:46:42.22 spid53 * MxCsr: 0000000000001F80:
2019-10-23 05:46:42.22 spid53 * SegCs: 0000000000000033:
2019-10-23 05:46:42.22 spid53 * SegDs: 000000000000002B:
2019-10-23 05:46:42.22 spid53 * SegEs: 000000000000002B:
2019-10-23 05:46:42.22 spid53 * SegFs: 0000000000000053:
2019-10-23 05:46:42.22 spid53 * SegGs: 000000000000002B:
2019-10-23 05:46:42.22 spid53 * SegSs: 000000000000002B:
2019-10-23 05:46:42.22 spid53 * EFlags: 0000000000010202: 2B7000000000001F FFFF000000007752 000000000000FFFF 0000000000000000 0FA0000000000000 0000000000000000
2019-10-23 05:46:42.22 spid53 * Rax: 000000001BF7E380: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2019-10-23 05:46:42.22 spid53 * Rcx: 000000FFFFFFFFFF:
2019-10-23 05:46:42.22 spid53 * Rdx: 0000000000000000:
2019-10-23 05:46:42.22 spid53 * Rbx: 00000830D0B045E0:
2019-10-23 05:46:42.22 spid53 * Rsp: 000000002233D280: 0000000000000001 0000000000000004 0000000000000000 0000000000000001 0000000000000158 000007FEF1497795
2019-10-23 05:46:42.22 spid53 * Rbp: 0000000017137840: 0000000000000043 00000000F0E0D0C0 0000000000000000 88000083178DE0A6 0000000017137A30 88000083178DE0A5
2019-10-23 05:46:42.22 spid53 * Rsi: 0000000000000000:
2019-10-23 05:46:42.22 spid53 * Rdi: 0000000000000000:
2019-10-23 05:46:42.22 spid53 * R8: 0000000017137830: 00000000171077E0 8C0000001BF7E380 0000000000000043 00000000F0E0D0C0 0000000000000000 88000083178DE0A6
2019-10-23 05:46:42.22 spid53 * R9: 00000000FFFFFFFF: 0002000004010100 F500010006565301 0C0001000682C900 CB106000075EF300 0000010003FCAE10 003C6E000FE41200
2019-10-23 05:46:42.22 spid53 * R10: 0000000000000000:
2019-10-23 05:46:42.22 spid53 * R11: 000000002233CFD2: 30E8000000002492 3188000000001BFD 0002000000001BFD 0000000000000000 000A000000000000 4DA8000000000000
2019-10-23 05:46:42.22 spid53 * R12: 00000000003A0000: 0000000000000000 01000944C79CC114 00000000FFEEFFEE 0000000017060018 00000000003A0128 00000000003A0000
2019-10-23 05:46:42.22 spid53 * R13: 0000000000000001:
2019-10-23 05:46:42.22 spid53 * R14: 0000000000000001:
2019-10-23 05:46:42.22 spid53 * R15: 0000000000000000:
2019-10-23 05:46:42.22 spid53 * Rip: 000000007741A365: 0001BD49087B8B48 BE49000000010000 FFFFFFFF00007FFF 708841800F40C641 0FFFFF0000BF410E 4B105B8B4C00401F
2019-10-23 05:46:42.22 spid53 * *******************************************************************************
2019-10-23 05:46:42.22 spid53 * -------------------------------------------------------------------------------
2019-10-23 05:46:42.22 spid53 * Short Stack Dump
2019-10-23 05:46:42.24 spid53 000000007741A365 Module(ntdll+000000000002A365)
2019-10-23 05:46:42.26 spid53 00000000771F13EA Module(kernel32+00000000000213EA)
2019-10-23 05:46:42.26 spid53 000007FEF14969D8 Module(MSVCR120+00000000000669D8)
2019-10-23 05:46:42.26 spid53 000007FEF14A7B46 Module(MSVCR120+0000000000077B46)
2019-10-23 05:46:42.27 spid53 000007FEF069DF38 Module(myodbc5a+000000000001DF38)
2019-10-23 05:46:42.27 spid53 000007FEF069CAC2 Module(myodbc5a+000000000001CAC2)
2019-10-23 05:46:42.27 spid53 000007FEFB2078B1 Module(ODBC32+00000000000078B1)
2019-10-23 05:46:42.27 spid53 000007FEFB1AE0E8 Module(msdasql+000000000006E0E8)
2019-10-23 05:46:42.27 spid53 000007FEFB187C23 Module(msdasql+0000000000047C23)
2019-10-23 05:46:42.27 spid53 00000000011603FB Module(sqlservr+0000000000B503FB)
2019-10-23 05:46:42.27 spid53 000000000112DDBB Module(sqlservr+0000000000B1DDBB)
2019-10-23 05:46:42.27 spid53 00000000010F4F02 Module(sqlservr+0000000000AE4F02)
2019-10-23 05:46:42.28 spid53 000000000107B6F6 Module(sqlservr+0000000000A6B6F6)
2019-10-23 05:46:42.28 spid53 0000000001F14961 Module(sqlservr+0000000001904961)
2019-10-23 05:46:42.28 spid53 00000000006DCFF4 Module(sqlservr+00000000000CCFF4)
2019-10-23 05:46:42.28 spid53 000000000069BD4D Module(sqlservr+000000000008BD4D)
2019-10-23 05:46:42.28 spid53 0000000000688B5D Module(sqlservr+0000000000078B5D)
2019-10-23 05:46:42.28 spid53 000000000068B8AB Module(sqlservr+000000000007B8AB)
2019-10-23 05:46:42.28 spid53 0000000000B98AA2 Module(sqlservr+0000000000588AA2)
2019-10-23 05:46:42.28 spid53 0000000000669B55 Module(sqlservr+0000000000059B55)
2019-10-23 05:46:42.29 spid53 000000000068076B Module(sqlservr+000000000007076B)
2019-10-23 05:46:42.29 spid53 000000000067FF3C Module(sqlservr+000000000006FF3C)
2019-10-23 05:46:42.29 spid53 0000000001B18A90 Module(sqlservr+0000000001508A90)
2019-10-23 05:46:42.29 spid53 0000000001B183E6 Module(sqlservr+00000000015083E6)
2019-10-23 05:46:42.29 spid53 0000000001B163DD Module(sqlservr+00000000015063DD)
2019-10-23 05:46:42.29 spid53 0000000000669B55 Module(sqlservr+0000000000059B55)
2019-10-23 05:46:42.29 spid53 000000000068076B Module(sqlservr+000000000007076B)
2019-10-23 05:46:42.29 spid53 000000000067FF3C Module(sqlservr+000000000006FF3C)
2019-10-23 05:46:42.29 spid53 0000000000680F4D Module(sqlservr+0000000000070F4D)
2019-10-23 05:46:42.29 spid53 000000000064A252 Module(sqlservr+000000000003A252)
2019-10-23 05:46:42.30 spid53 000000000061EF70 Module(sqlservr+000000000000EF70)
2019-10-23 05:46:42.30 spid53 000000000061ED4A Module(sqlservr+000000000000ED4A)
2019-10-23 05:46:42.30 spid53 000000000061EB8F Module(sqlservr+000000000000EB8F)
2019-10-23 05:46:42.30 spid53 000000000073D706 Module(sqlservr+000000000012D706)
2019-10-23 05:46:42.30 spid53 000000000073D7E5 Module(sqlservr+000000000012D7E5)
2019-10-23 05:46:42.30 spid53 00000000009BD869 Module(sqlservr+00000000003AD869)
2019-10-23 05:46:42.31 spid53 000000000073E01A Module(sqlservr+000000000012E01A)
2019-10-23 05:46:42.31 spid53 0000000074DC37D7 Module(MSVCR80+00000000000037D7)
2019-10-23 05:46:42.31 spid53 0000000074DC3894 Module(MSVCR80+0000000000003894)
2019-10-23 05:46:42.31 spid53 00000000771E555D Module(kernel32+000000000001555D)
2019-10-23 05:46:42.31 spid53 000000007744385D Module(ntdll+000000000005385D)
2019-10-23 05:46:42.34 spid53 Stack Signature for the dump is 0x00000001DBF4872E
Todas las respuestas
-
Estimados.
En un SS2008 R2, sucede que el agente se detiene de manera inesperada, ya parchar con SP3, pero el problema sigue.
El usuario del agente es sysadmin y admeas pertenece al grupo administrator del S.O (W2003), por falta de tiempo no hemos podido actualizar las versiones de SQL y de S.O.
El error en el SQL dice:
Particularmente anoche, el ultimo respaldo en el registro de log fue a las 5:14 Am y a las 05:46 indica:
Debo entender que faltan recursos:
Origen spid53
Mensaje
***Stack Dump being sent to E:\Data\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\SQLDump0270.txtEn una de las filas indica:
2019-10-23 05:46:42.22 spid53 * Input Buffer 60 bytes -
2019-10-23 05:46:42.22 spid53 * Exec p_parametriza 1315El archivo txt es el siguiente:
2019-10-23 05:46:42.22 spid53 ***Stack Dump being sent to E:\Data\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\SQLDump0270.txt
2019-10-23 05:46:42.22 spid53 SqlDumpExceptionHandler: Process 53 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2019-10-23 05:46:42.22 spid53 * *******************************************************************************
2019-10-23 05:46:42.22 spid53 *
2019-10-23 05:46:42.22 spid53 * BEGIN STACK DUMP:
2019-10-23 05:46:42.22 spid53 * 10/23/19 05:46:42 spid 53
2019-10-23 05:46:42.22 spid53 *
2019-10-23 05:46:42.22 spid53 *
2019-10-23 05:46:42.22 spid53 * Exception Address = 000000007741A365 Module(ntdll+000000000002A365)
2019-10-23 05:46:42.22 spid53 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2019-10-23 05:46:42.22 spid53 * Access Violation occurred reading address 00000830D0B045E8
2019-10-23 05:46:42.22 spid53 * Input Buffer 60 bytes -
2019-10-23 05:46:42.22 spid53 * Exec p_parametriza 1315
2019-10-23 05:46:42.22 spid53 *
2019-10-23 05:46:42.22 spid53 *
2019-10-23 05:46:42.22 spid53 * MODULE BASE END SIZE
2019-10-23 05:46:42.22 spid53 * sqlservr 0000000000610000 000000000422FFFF 03c20000
2019-10-23 05:46:42.22 spid53 * ntdll 00000000773F0000 000000007758EFFF 0019f000
2019-10-23 05:46:42.22 spid53 * kernel32 00000000771D0000 00000000772EEFFF 0011f000
2019-10-23 05:46:42.22 spid53 * KERNELBASE 000007FEFD460000 000007FEFD4C9FFF 0006a000
2019-10-23 05:46:42.22 spid53 * ADVAPI32 000007FEFDB80000 000007FEFDC5AFFF 000db000
2019-10-23 05:46:42.22 spid53 * msvcrt 000007FEFDD70000 000007FEFDE0EFFF 0009f000
2019-10-23 05:46:42.22 spid53 * sechost 000007FEFE410000 000007FEFE42EFFF 0001f000
2019-10-23 05:46:42.22 spid53 * RPCRT4 000007FEFD580000 000007FEFD6ABFFF 0012c000
2019-10-23 05:46:42.22 spid53 * MSVCR80 0000000074DC0000 0000000074E88FFF 000c9000
2019-10-23 05:46:42.22 spid53 * MSVCP80 0000000074A30000 0000000074B38FFF 00109000
2019-10-23 05:46:42.22 spid53 * sqlos 0000000074950000 0000000074956FFF 00007000
2019-10-23 05:46:42.22 spid53 * Secur32 000007FEFCD30000 000007FEFCD3AFFF 0000b000
2019-10-23 05:46:42.22 spid53 * SSPICLI 000007FEFCEE0000 000007FEFCF04FFF 00025000
2019-10-23 05:46:42.22 spid53 * pdh 000007FEF4940000 000007FEF498DFFF 0004e000
2019-10-23 05:46:42.22 spid53 * SHLWAPI 000007FEFD500000 000007FEFD570FFF 00071000
2019-10-23 05:46:42.22 spid53 * GDI32 000007FEFDC60000 000007FEFDCC6FFF 00067000
2019-10-23 05:46:42.22 spid53 * USER32 00000000772F0000 00000000773E9FFF 000fa000
2019-10-23 05:46:42.22 spid53 * LPK 000007FEFDB40000 000007FEFDB4DFFF 0000e000
2019-10-23 05:46:42.22 spid53 * USP10 000007FEFE2F0000 000007FEFE3BAFFF 000cb000
2019-10-23 05:46:42.22 spid53 * USERENV 000007FEFD220000 000007FEFD23DFFF 0001e000
2019-10-23 05:46:42.22 spid53 * profapi 000007FEFD110000 000007FEFD11EFFF 0000f000
2019-10-23 05:46:42.22 spid53 * WINMM 000007FEF9250000 000007FEF928AFFF 0003b000
2019-10-23 05:46:42.22 spid53 * IPHLPAPI 000007FEFA8F0000 000007FEFA916FFF 00027000
2019-10-23 05:46:42.22 spid53 * NSI 000007FEFD4F0000 000007FEFD4F7FFF 00008000
2019-10-23 05:46:42.22 spid53 * WINNSI 000007FEFAAA0000 000007FEFAAAAFFF 0000b000
2019-10-23 05:46:42.22 spid53 * opends60 0000000074990000 0000000074997FFF 00008000
2019-10-23 05:46:42.22 spid53 * NETAPI32 000007FEFBC20000 000007FEFBC35FFF 00016000
2019-10-23 05:46:42.22 spid53 * netutils 000007FEFC490000 000007FEFC49BFFF 0000c000
2019-10-23 05:46:42.22 spid53 * srvcli 000007FEFCB80000 000007FEFCBA2FFF 00023000
2019-10-23 05:46:42.22 spid53 * wkscli 000007FEFB9C0000 000007FEFB9D4FFF 00015000
2019-10-23 05:46:42.22 spid53 * LOGONCLI 000007FEFC980000 000007FEFC9AFFFF 00030000
2019-10-23 05:46:42.22 spid53 * SAMCLI 000007FEF9B80000 000007FEF9B93FFF 00014000
2019-10-23 05:46:42.22 spid53 * BatchParser 00000000748F0000 000000007491CFFF 0002d000
2019-10-23 05:46:42.22 spid53 * IMM32 000007FEFDB50000 000007FEFDB7DFFF 0002e000
2019-10-23 05:46:42.22 spid53 * MSCTF 000007FEFF4F0000 000007FEFF5F8FFF 00109000
2019-10-23 05:46:42.22 spid53 * psapi 0000000077590000 0000000077596FFF 00007000
2019-10-23 05:46:42.22 spid53 * instapi10 0000000074980000 000000007498CFFF 0000d000
2019-10-23 05:46:42.22 spid53 * cscapi 000007FEF4A20000 000007FEF4A2EFFF 0000f000
2019-10-23 05:46:42.22 spid53 * sqlevn70 0000000073FD0000 00000000741D3FFF 00204000
2019-10-23 05:46:42.22 spid53 * ntmarta 000007FEFC1A0000 000007FEFC1CCFFF 0002d000
2019-10-23 05:46:42.22 spid53 * WLDAP32 000007FEFE430000 000007FEFE481FFF 00052000
2019-10-23 05:46:42.22 spid53 * CRYPTSP 000007FEFC9B0000 000007FEFC9C7FFF 00018000
2019-10-23 05:46:42.22 spid53 * rsaenh 000007FEFC5B0000 000007FEFC5F6FFF 00047000
2019-10-23 05:46:42.22 spid53 * CRYPTBASE 000007FEFCF70000 000007FEFCF7EFFF 0000f000
2019-10-23 05:46:42.22 spid53 * BROWCLI 000007FEF9AA0000 000007FEF9AB1FFF 00012000
2019-10-23 05:46:42.22 spid53 * AUTHZ 000007FEFCA20000 000007FEFCA4EFFF 0002f000
2019-10-23 05:46:42.22 spid53 * MSCOREE 000007FEF83B0000 000007FEF841EFFF 0006f000
2019-10-23 05:46:42.22 spid53 * mscoreei 000007FEF8210000 000007FEF82B8FFF 000a9000
2019-10-23 05:46:42.22 spid53 * api-ms-win-core-synch-l1-2-0 000007FEF8D30000 000007FEF8D32FFF 00003000
2019-10-23 05:46:42.22 spid53 * ole32 000007FEFE0F0000 000007FEFE2EEFFF 001ff000
2019-10-23 05:46:42.22 spid53 * credssp 000007FEFC4C0000 000007FEFC4C9FFF 0000a000
2019-10-23 05:46:42.22 spid53 * msv1_0 000007FEFC7B0000 000007FEFC801FFF 00052000
2019-10-23 05:46:42.22 spid53 * cryptdll 000007FEFCBB0000 000007FEFCBC3FFF 00014000
2019-10-23 05:46:42.22 spid53 * kerberos 000007FEFC810000 000007FEFC8C8FFF 000b9000
2019-10-23 05:46:42.22 spid53 * MSASN1 000007FEFD120000 000007FEFD12EFFF 0000f000
2019-10-23 05:46:42.22 spid53 * schannel 000007FEFC640000 000007FEFC697FFF 00058000
2019-10-23 05:46:42.22 spid53 * CRYPT32 000007FEFD280000 000007FEFD3ECFFF 0016d000
2019-10-23 05:46:42.22 spid53 * security 0000000074650000 0000000074652FFF 00003000
2019-10-23 05:46:42.22 spid53 * WS2_32 000007FEFE3C0000 000007FEFE40CFFF 0004d000
2019-10-23 05:46:42.22 spid53 * SHELL32 000007FEFE490000 000007FEFF21AFFF 00d8b000
2019-10-23 05:46:42.22 spid53 * OLEAUT32 000007FEFF600000 000007FEFF6DAFFF 000db000
2019-10-23 05:46:42.22 spid53 * ftimport 0000000060000000 0000000060024FFF 00025000
2019-10-23 05:46:42.22 spid53 * MSFTE 0000000049980000 0000000049D2DFFF 003ae000
2019-10-23 05:46:42.22 spid53 * VERSION 000007FEFC1D0000 000007FEFC1DBFFF 0000c000
2019-10-23 05:46:42.22 spid53 * dbghelp 0000000074790000 00000000748EDFFF 0015e000
2019-10-23 05:46:42.22 spid53 * WINTRUST 000007FEFD240000 000007FEFD27AFFF 0003b000
2019-10-23 05:46:42.22 spid53 * ncrypt 000007FEFC9D0000 000007FEFCA1FFFF 00050000
2019-10-23 05:46:42.22 spid53 * bcrypt 000007FEFCAE0000 000007FEFCB01FFF 00022000
2019-10-23 05:46:42.22 spid53 * mswsock 000007FEFC8D0000 000007FEFC924FFF 00055000
2019-10-23 05:46:42.22 spid53 * wship6 000007FEFCA60000 000007FEFCA66FFF 00007000
2019-10-23 05:46:42.22 spid53 * wshtcpip 000007FEFC2A0000 000007FEFC2A6FFF 00007000
2019-10-23 05:46:42.22 spid53 * ntdsapi 000007FEFA0F0000 000007FEFA116FFF 00027000
2019-10-23 05:46:42.22 spid53 * DNSAPI 000007FEFC6A0000 000007FEFC6FAFFF 0005b000
2019-10-23 05:46:42.22 spid53 * rasadhlp 000007FEFA160000 000007FEFA167FFF 00008000
2019-10-23 05:46:42.22 spid53 * fwpuclnt 000007FEFA7B0000 000007FEFA802FFF 00053000
2019-10-23 05:46:42.22 spid53 * bcryptprimitives 000007FEFC930000 000007FEFC97BFFF 0004c000
2019-10-23 05:46:42.22 spid53 * SAMLIB 000007FEF9B60000 000007FEF9B7CFFF 0001d000
2019-10-23 05:46:42.22 spid53 * CLBCatQ 000007FEFD730000 000007FEFD7C8FFF 00099000
2019-10-23 05:46:42.22 spid53 * sqlncli10 0000000073D10000 0000000073FCCFFF 002bd000
2019-10-23 05:46:42.22 spid53 * COMCTL32 000007FEF21F0000 000007FEF228FFFF 000a0000
2019-10-23 05:46:42.22 spid53 * COMDLG32 000007FEFDCD0000 000007FEFDD66FFF 00097000
2019-10-23 05:46:42.22 spid53 * SQLNCLIR10 0000000074750000 0000000074786FFF 00037000
2019-10-23 05:46:42.22 spid53 * xplog70 0000000074920000 000000007492FFFF 00010000
2019-10-23 05:46:42.22 spid53 * xplog70 0000000074740000 0000000074741FFF 00002000
2019-10-23 05:46:42.22 spid53 * xpstar 0000000074200000 0000000074287FFF 00088000
2019-10-23 05:46:42.22 spid53 * SQLSCM 0000000074730000 000000007473DFFF 0000e000
2019-10-23 05:46:42.22 spid53 * ODBC32 000007FEFB200000 000007FEFB2B0FFF 000b1000
2019-10-23 05:46:42.22 spid53 * ATL80 0000000074D70000 0000000074D8FFFF 00020000
2019-10-23 05:46:42.22 spid53 * odbcint 0000000073B30000 0000000073B67FFF 00038000
2019-10-23 05:46:42.22 spid53 * clusapi 000007FEF2B40000 000007FEF2B8FFFF 00050000
2019-10-23 05:46:42.22 spid53 * resutils 000007FEF2AA0000 000007FEF2AB8FFF 00019000
2019-10-23 05:46:42.22 spid53 * xpstar 0000000073810000 0000000073834FFF 00025000
2019-10-23 05:46:42.22 spid53 * oledb32 000007FEFAFD0000 000007FEFB0DDFFF 0010e000
2019-10-23 05:46:42.22 spid53 * MSDART 000007FEFB450000 000007FEFB477FFF 00028000
2019-10-23 05:46:42.22 spid53 * Comctl32 000007FEFB9E0000 000007FEFBBD4FFF 001f5000
2019-10-23 05:46:42.22 spid53 * OLEDB32R 0000000074710000 0000000074723FFF 00014000
2019-10-23 05:46:42.22 spid53 * comsvcs 000007FEF1D50000 000007FEF1F00FFF 001b1000
2019-10-23 05:46:42.22 spid53 * msdasql 000007FEFB140000 000007FEFB1F5FFF 000b6000
2019-10-23 05:46:42.22 spid53 * MSDATL3 000007FEFB430000 000007FEFB44FFFF 00020000
2019-10-23 05:46:42.22 spid53 * MSDASQLR 00000000741F0000 00000000741FEFFF 0000f000
2019-10-23 05:46:42.22 spid53 * RpcRtRemote 000007FEFD020000 000007FEFD033FFF 00014000
2019-10-23 05:46:42.22 spid53 * myodbc5a 000007FEF0680000 000007FEF0C36FFF 005b7000
2019-10-23 05:46:42.22 spid53 * MSVCR120 000007FEF1430000 000007FEF151EFFF 000ef000
2019-10-23 05:46:42.22 spid53 * odbccp32 000007FEFB400000 000007FEFB427FFF 00028000
2019-10-23 05:46:42.22 spid53 * NLAapi 000007FEFBC00000 000007FEFBC14FFF 00015000
2019-10-23 05:46:42.22 spid53 * napinsp 000007FEFA120000 000007FEFA134FFF 00015000
2019-10-23 05:46:42.22 spid53 * winrnr 000007FEFA150000 000007FEFA15AFFF 0000b000
2019-10-23 05:46:42.22 spid53 * xpsqlbot 0000000071000000 0000000071007FFF 00008000
2019-10-23 05:46:42.22 spid53 * dsrole 000007FEFB8C0000 000007FEFB8CBFFF 0000c000
2019-10-23 05:46:42.22 spid53 * instapi 0000000048060000 000000004806CFFF 0000d000
2019-10-23 05:46:42.22 spid53 * apphelp 000007FEFCF10000 000007FEFCF66FFF 00057000
2019-10-23 05:46:42.22 spid53 * msxmlsql 0000000073520000 0000000073670FFF 00151000
2019-10-23 05:46:42.22 spid53 * dbghelp 00000000736B0000 000000007380DFFF 0015e000
2019-10-23 05:46:42.22 spid53 *
2019-10-23 05:46:42.22 spid53 * P1Home: 000000002233D1B0: 00000000C0000005 0000000000000000 000000007741A365 0000000000000002 0000000000000000 00000830D0B045E8
2019-10-23 05:46:42.22 spid53 * P2Home: 000000002233CCC0: 000000002233D1B0 000000002233CCC0 0000000000000000 0000000000000000 000000001D900000 000000001D951CF0
2019-10-23 05:46:42.22 spid53 * P3Home: 0000000000000000:
2019-10-23 05:46:42.22 spid53 * P4Home: 0000000000000000:
2019-10-23 05:46:42.22 spid53 * P5Home: 000000001D900000: 0000000000000000 010016FFF21EED9A 00000000FFEEFFEE 0000000004DD0018 000000001D900128 000000001D900000
2019-10-23 05:46:42.22 spid53 * P6Home: 000000001D951CF0: 000000001D94BC30 C8B522BE00000001 AA00E5AD11CE5CF3 000000003D774400 0000000000000000 9000008316571E02
2019-10-23 05:46:42.22 spid53 * ContextFlags: 000000000010001F: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2019-10-23 05:46:42.22 spid53 * MxCsr: 0000000000001F80:
2019-10-23 05:46:42.22 spid53 * SegCs: 0000000000000033:
2019-10-23 05:46:42.22 spid53 * SegDs: 000000000000002B:
2019-10-23 05:46:42.22 spid53 * SegEs: 000000000000002B:
2019-10-23 05:46:42.22 spid53 * SegFs: 0000000000000053:
2019-10-23 05:46:42.22 spid53 * SegGs: 000000000000002B:
2019-10-23 05:46:42.22 spid53 * SegSs: 000000000000002B:
2019-10-23 05:46:42.22 spid53 * EFlags: 0000000000010202: 2B7000000000001F FFFF000000007752 000000000000FFFF 0000000000000000 0FA0000000000000 0000000000000000
2019-10-23 05:46:42.22 spid53 * Rax: 000000001BF7E380: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2019-10-23 05:46:42.22 spid53 * Rcx: 000000FFFFFFFFFF:
2019-10-23 05:46:42.22 spid53 * Rdx: 0000000000000000:
2019-10-23 05:46:42.22 spid53 * Rbx: 00000830D0B045E0:
2019-10-23 05:46:42.22 spid53 * Rsp: 000000002233D280: 0000000000000001 0000000000000004 0000000000000000 0000000000000001 0000000000000158 000007FEF1497795
2019-10-23 05:46:42.22 spid53 * Rbp: 0000000017137840: 0000000000000043 00000000F0E0D0C0 0000000000000000 88000083178DE0A6 0000000017137A30 88000083178DE0A5
2019-10-23 05:46:42.22 spid53 * Rsi: 0000000000000000:
2019-10-23 05:46:42.22 spid53 * Rdi: 0000000000000000:
2019-10-23 05:46:42.22 spid53 * R8: 0000000017137830: 00000000171077E0 8C0000001BF7E380 0000000000000043 00000000F0E0D0C0 0000000000000000 88000083178DE0A6
2019-10-23 05:46:42.22 spid53 * R9: 00000000FFFFFFFF: 0002000004010100 F500010006565301 0C0001000682C900 CB106000075EF300 0000010003FCAE10 003C6E000FE41200
2019-10-23 05:46:42.22 spid53 * R10: 0000000000000000:
2019-10-23 05:46:42.22 spid53 * R11: 000000002233CFD2: 30E8000000002492 3188000000001BFD 0002000000001BFD 0000000000000000 000A000000000000 4DA8000000000000
2019-10-23 05:46:42.22 spid53 * R12: 00000000003A0000: 0000000000000000 01000944C79CC114 00000000FFEEFFEE 0000000017060018 00000000003A0128 00000000003A0000
2019-10-23 05:46:42.22 spid53 * R13: 0000000000000001:
2019-10-23 05:46:42.22 spid53 * R14: 0000000000000001:
2019-10-23 05:46:42.22 spid53 * R15: 0000000000000000:
2019-10-23 05:46:42.22 spid53 * Rip: 000000007741A365: 0001BD49087B8B48 BE49000000010000 FFFFFFFF00007FFF 708841800F40C641 0FFFFF0000BF410E 4B105B8B4C00401F
2019-10-23 05:46:42.22 spid53 * *******************************************************************************
2019-10-23 05:46:42.22 spid53 * -------------------------------------------------------------------------------
2019-10-23 05:46:42.22 spid53 * Short Stack Dump
2019-10-23 05:46:42.24 spid53 000000007741A365 Module(ntdll+000000000002A365)
2019-10-23 05:46:42.26 spid53 00000000771F13EA Module(kernel32+00000000000213EA)
2019-10-23 05:46:42.26 spid53 000007FEF14969D8 Module(MSVCR120+00000000000669D8)
2019-10-23 05:46:42.26 spid53 000007FEF14A7B46 Module(MSVCR120+0000000000077B46)
2019-10-23 05:46:42.27 spid53 000007FEF069DF38 Module(myodbc5a+000000000001DF38)
2019-10-23 05:46:42.27 spid53 000007FEF069CAC2 Module(myodbc5a+000000000001CAC2)
2019-10-23 05:46:42.27 spid53 000007FEFB2078B1 Module(ODBC32+00000000000078B1)
2019-10-23 05:46:42.27 spid53 000007FEFB1AE0E8 Module(msdasql+000000000006E0E8)
2019-10-23 05:46:42.27 spid53 000007FEFB187C23 Module(msdasql+0000000000047C23)
2019-10-23 05:46:42.27 spid53 00000000011603FB Module(sqlservr+0000000000B503FB)
2019-10-23 05:46:42.27 spid53 000000000112DDBB Module(sqlservr+0000000000B1DDBB)
2019-10-23 05:46:42.27 spid53 00000000010F4F02 Module(sqlservr+0000000000AE4F02)
2019-10-23 05:46:42.28 spid53 000000000107B6F6 Module(sqlservr+0000000000A6B6F6)
2019-10-23 05:46:42.28 spid53 0000000001F14961 Module(sqlservr+0000000001904961)
2019-10-23 05:46:42.28 spid53 00000000006DCFF4 Module(sqlservr+00000000000CCFF4)
2019-10-23 05:46:42.28 spid53 000000000069BD4D Module(sqlservr+000000000008BD4D)
2019-10-23 05:46:42.28 spid53 0000000000688B5D Module(sqlservr+0000000000078B5D)
2019-10-23 05:46:42.28 spid53 000000000068B8AB Module(sqlservr+000000000007B8AB)
2019-10-23 05:46:42.28 spid53 0000000000B98AA2 Module(sqlservr+0000000000588AA2)
2019-10-23 05:46:42.28 spid53 0000000000669B55 Module(sqlservr+0000000000059B55)
2019-10-23 05:46:42.29 spid53 000000000068076B Module(sqlservr+000000000007076B)
2019-10-23 05:46:42.29 spid53 000000000067FF3C Module(sqlservr+000000000006FF3C)
2019-10-23 05:46:42.29 spid53 0000000001B18A90 Module(sqlservr+0000000001508A90)
2019-10-23 05:46:42.29 spid53 0000000001B183E6 Module(sqlservr+00000000015083E6)
2019-10-23 05:46:42.29 spid53 0000000001B163DD Module(sqlservr+00000000015063DD)
2019-10-23 05:46:42.29 spid53 0000000000669B55 Module(sqlservr+0000000000059B55)
2019-10-23 05:46:42.29 spid53 000000000068076B Module(sqlservr+000000000007076B)
2019-10-23 05:46:42.29 spid53 000000000067FF3C Module(sqlservr+000000000006FF3C)
2019-10-23 05:46:42.29 spid53 0000000000680F4D Module(sqlservr+0000000000070F4D)
2019-10-23 05:46:42.29 spid53 000000000064A252 Module(sqlservr+000000000003A252)
2019-10-23 05:46:42.30 spid53 000000000061EF70 Module(sqlservr+000000000000EF70)
2019-10-23 05:46:42.30 spid53 000000000061ED4A Module(sqlservr+000000000000ED4A)
2019-10-23 05:46:42.30 spid53 000000000061EB8F Module(sqlservr+000000000000EB8F)
2019-10-23 05:46:42.30 spid53 000000000073D706 Module(sqlservr+000000000012D706)
2019-10-23 05:46:42.30 spid53 000000000073D7E5 Module(sqlservr+000000000012D7E5)
2019-10-23 05:46:42.30 spid53 00000000009BD869 Module(sqlservr+00000000003AD869)
2019-10-23 05:46:42.31 spid53 000000000073E01A Module(sqlservr+000000000012E01A)
2019-10-23 05:46:42.31 spid53 0000000074DC37D7 Module(MSVCR80+00000000000037D7)
2019-10-23 05:46:42.31 spid53 0000000074DC3894 Module(MSVCR80+0000000000003894)
2019-10-23 05:46:42.31 spid53 00000000771E555D Module(kernel32+000000000001555D)
2019-10-23 05:46:42.31 spid53 000000007744385D Module(ntdll+000000000005385D)
2019-10-23 05:46:42.34 spid53 Stack Signature for the dump is 0x00000001DBF4872EHola CristianPM
Gracias por levantar tu consulta en los foros de MSDN. Con respecto a la misma, te sugiero realizar lo siguiente:
- Al inicio de tu consulta mencionas que no han realizado las actualizaciones correspondientes de SQL y del S.O.
- Es importante que, primero comprueben mediante las actualizaciones de los elementos mencionados el problema se resuelva. Por ello recomiendo realizar la actualización de los mismos.
- Como recomendación al momento de formular una consulta por este medio y que para la comunidad de foros de MSDN pueda asesorarte correctamente, recomendamos sólamente colocar el número de error y el mensaje.
Gracias por usar los foros de MSDN.
Pablo Rubio
____
Por favor recuerde "Marcar como respuesta" las respuestas que hayan resuelto su problema, es una forma común de reconocer a aquellos que han ayudado, y hace que sea más fácil para los otros visitantes encontrar la solución más tarde.
Microsoft ofrece este servicio de forma gratuita, con la finalidad de ayudar a los usuarios y la ampliación de la base de datos de conocimientos relacionados con los productos y tecnologías de Microsoft.
Este contenido es proporcionado "tal cual" y no implica ninguna responsabilidad de parte de Microsoft.
-
-