February 24, 2016 at 11:25 am
I am also getting below error from crash dump and SQL is restarting after very 30 minutes
We have SQL 2012 SP2 and CU8
*******************************************************************************
* *
* Exception Analysis *
* *
*******************************************************************************
Debugger CompCtrlDb Connection::Open failed 80004005
Cannot access CompCentralDB. You may need to request access: http://windows/access
*** WARNING: Unable to verify checksum for mscorlib.ni.dll
Debugger Dbgportaldb Connection::Open failed 80004005
Database Dbgportaldb not connected
FAULTING_IP:
sqllang!SQLDumperLibraryInvoke+2e4 [e:\sql11_main_t\sqltdbms\msql\utils\watson.cpp @ 573]
000007fd`6a5c5a94 8bd8 mov ebx,eax
EXCEPTION_RECORD: ffffffffffffffff -- (.exr 0xffffffffffffffff)
ExceptionAddress: 000007fd6a5c5a94 (sqllang!SQLDumperLibraryInvoke+0x00000000000002e4)
ExceptionCode: 000042ac
ExceptionFlags: 00000000
NumberParameters: 0
CONTEXT: 0000000000000000 -- (.cxr 0x0;r)
rax=000000000000003f rbx=0000000000000000 rcx=0000000000000043
rdx=0000000066b05ce0 rsi=0000000000000064 rdi=0000000000001ecc
rip=000007fd8fba2bea rsp=000000006777c358 rbp=000000006777d630
r8=0000000000000000 r9=0000000000000000 r10=0000000000000004
r11=0000000000000007 r12=0000000000000000 r13=0000000000000000
r14=000000006777c388 r15=0000000000000000
iopl=0 nv up ei ng nz na po cy
cs=0033 ss=002b ds=002b es=002b fs=0053 gs=002b efl=00000287
ntdll!ZwWaitForSingleObject+0xa:
000007fd`8fba2bea c3 ret
PROCESS_NAME: sqlservr.exe
ERROR_CODE: (NTSTATUS) 0x42ac - <Unable to get error code text>
EXCEPTION_CODE: (Win32) 0x42ac (17068) - <Unable to get error code text>
NTGLOBALFLAG: 0
APP: sqlservr.exe
ANALYSIS_VERSION: 6.13.0016.1867 (debuggers(dbg).130603-1717) amd64fre
MANAGED_STACK: !dumpstack -EE
OS Thread Id: 0x4708 (0)
Current frame:
Child-SP RetAddr Caller, Callee
FAULTING_THREAD: 0000000000004708
BUGCHECK_STR: APPLICATION_FAULT_APPLICATION_FAULT_MISSING_CLR_METADATA
PRIMARY_PROBLEM_CLASS: APPLICATION_FAULT_MISSING_CLR_METADATA
DEFAULT_BUCKET_ID: APPLICATION_FAULT_MISSING_CLR_METADATA
LAST_CONTROL_TRANSFER: from 000007f62b26f32c to 000007fd8ce36ac0
STACK_TEXT:
00000000`6777d530 000007f6`2b26f32c : 000007fd`6b300fc0 000007f6`2b26db14 00000000`6777d650 000007fd`69b55b80 : KERNELBASE!RaiseException+0x68
00000000`6777d610 000007fd`6a5c5a94 : 000007f6`2b27a668 00000000`00000004 00000000`0258f5a0 000007fd`6aa4fb49 : sqlservr!CDmpDump::Dump+0x4c
00000000`6777d650 000007fd`6a5c64b6 : 00000000`00000000 00000000`6777f610 00000000`00000000 000007fd`6b2f39b0 : sqllang!SQLDumperLibraryInvoke+0x2e4
00000000`6777d8f0 000007fd`6a58d14b : 0000000e`c20f2040 00000000`6777f610 0000000e`c20f2040 0000000e`c20f30c0 : sqllang!CImageHelper::DoMiniDump+0x426
00000000`6777dae0 000007fd`6a58c54a : 00000000`000000ff 000007fd`6caa2286 00000000`6777f580 0000001b`0000083f : sqllang!stackTrace+0xbdb
00000000`6777f520 000007fd`74b54bdd : 000007fd`74b23bf0 00000000`6777f660 00000000`00000034 00000000`008a6fb0 : sqllang!stackTraceCallBack+0xca
00000000`6777f560 000007fd`74b37639 : 00000000`6777f8b0 00000000`6777f880 00000000`12af6cc0 00000000`6777f960 : sqldk!ex_raise2+0x340
00000000`6777f870 000007fd`6caa2286 : 0000000e`10500000 0000000e`c20e2218 00000008`0000016c 0000000e`00000009 : sqldk!ex_raise+0xf0
00000000`6777f8f0 000007fd`6b7246df : 00000000`00000000 00000000`67780130 00000000`00000000 0000000e`c20d7a70 : sqlmin!RaiseInconsistencyError+0x316
00000000`6777fc20 000007fd`6b5219e8 : ffffffff`fffffffe 0000001c`2af33540 00000000`00000004 00000000`00000000 : sqlmin!IndexPageManager::GetPageForLinkModification+0x1ecc
00000000`677800c0 000007fd`6b51378c : 0000000e`c20d7a60 00000000`00000000 0000000e`c20d7a60 00000000`00000000 : sqlmin!SplitPage+0x3a9
00000000`67780b90 000007fd`6b515f23 : 00000000`00000000 0000000e`00000000 0000000c`d0493350 0000000e`c20c0001 : sqlmin!IndexDataSetSession::InsertSmallRecord+0x1b5c
00000000`67788eb0 000007fd`6b5161d6 : 000169e2`45361ac4 000007fd`6b52e8bb 00000000`00000000 0000000e`104ec630 : sqlmin!IndexDataSetSession::InsertRowInternal+0x2d11
00000000`6778b130 000007fd`6b516066 : 0000000e`c20c5d58 0000000e`c209aca8 0000000e`c20c5d20 000007fd`55c40000 : sqlmin!DatasetSession::InsertRow+0x163
00000000`6778b200 000007fd`6b51c26b : 0000000e`c20d4f30 000007fd`55c474ab 0000000e`0010be60 00000000`00000000 : sqlmin!RowsetNewSS::InsertRow+0x26
00000000`6778b230 000007fd`55c47f27 : 0000000e`c20d4f30 000007fd`00000004 00000000`6778b330 0000000e`c209aca8 : sqlmin!CValRowMult::SetDataX+0x194
00000000`6778b300 000007fd`6b51cb23 : 0000000e`c209b7b0 00000000`00000004 00000000`00000004 0000000e`c209ac60 : sqltses!CEsExec::GeneralEval+0x1a9
00000000`6778b420 000007fd`6b51ca96 : 0000000e`c209ac60 0000000e`c209b570 0000000e`c209b570 00000000`00000004 : sqlmin!CQScanUpdateNew::GetRow+0x3f7
00000000`6778b4c0 000007fd`6b4c671f : 0000000e`c209a150 00000000`00000000 0000000e`c209ad50 0000000d`eb790d80 : sqlmin!CQScanUpdateNew::GetRow+0x76
00000000`6778b560 000007fd`69432051 : 7fffffff`ffffffff 00000000`00000000 00000000`6778bf38 ffffffff`ffffffff : sqlmin!CQueryScan::GetRow+0x81
00000000`6778b590 000007fd`6945cb9d : 0000000e`c209a150 0000000e`c20f2040 0000000e`c209a100 00000000`00000000 : sqllang!CXStmtQuery::ErsqExecuteQuery+0x54a
00000000`6778b720 000007fd`6945c9a9 : 0000000e`c209a201 00000000`0499cc00 00000000`00000000 0000000e`c20f2001 : sqllang!CXStmtDML::XretDMLExecute+0x2f3
00000000`6778b800 000007fd`694103b1 : 00000000`00000000 0000000e`c20a0430 00000000`6778b8f9 0000000e`c209a150 : sqllang!CXStmtDML::XretExecute+0xad
00000000`6778b830 000007fd`6942a58b : 0000000e`c20a0810 00000000`00000000 ffffffff`fffffffe 00000000`00000000 : sqllang!CMsqlExecContext::ExecuteStmts<1,1>+0x400
00000000`6778b950 000007fd`69429cc4 : 0000000e`c20a0150 0000000e`c20f2040 00000000`6778be00 0000000d`60526da8 : sqllang!CMsqlExecContext::FExecute+0xa33
00000000`6778bb40 000007fd`6a286f33 : 0000000d`60526da8 0000000d`60526da8 0000000d`60526da8 00000000`00000000 : sqllang!CSQLSource::Execute+0x866
00000000`6778bd00 000007fd`6a28f132 : 00000000`00000000 00000000`00000000 00000000`00000000 0000000d`eb790d90 : sqllang!ExecuteSql+0x863
00000000`6778c7c0 000007fd`6a28e73c : 0000000e`c20f2040 0000000d`60526da8 0000000e`c20f3040 000007fd`6a2ecd00 : sqllang!CSpecProc::ExecuteSpecial+0x2a2
00000000`6778c8f0 000007fd`6995a588 : 0000000d`00000000 0000000e`c20f2040 0000000d`60526998 0000000d`60526998 : sqllang!CXProc::Execute+0x16c
00000000`6778cd60 000007fd`6a2bca51 : 00000000`00000000 00000000`00000000 0000000d`60526da8 000007fd`00000000 : sqllang!CSQLSource::Execute+0x9a8
00000000`6778cf20 000007fd`6a2bc4c5 : 0000000d`60526998 0000000d`60526998 00000000`00000000 00000000`04976160 : sqllang!CStmtExecProc::XretLocalExec+0x201
00000000`6778cfa0 000007fd`6a2b9dc8 : 00000000`00000000 000007fd`6a2ec738 0000000d`605268e0 00000019`b8b31020 : sqllang!CStmtExecProc::XretExecExecute+0x4d5
00000000`6778d740 000007fd`694103b1 : 0000000d`65056430 0000000e`c20f2040 0000000e`c20f2040 0000000d`60526060 : sqllang!CXStmtExecProc::XretExecute+0x38
00000000`6778d780 000007fd`6942a58b : 00000022`13974785 00000000`00000000 0000000e`c20f3170 000007fd`6945369a : sqllang!CMsqlExecContext::ExecuteStmts<1,1>+0x400
00000000`6778d8a0 000007fd`69429cc4 : 0000000d`65056150 0000000e`c20f2040 0000000e`c20ee200 0000000e`c20ee628 : sqllang!CMsqlExecContext::FExecute+0xa33
00000000`6778da90 000007fd`6a2bca51 : 00000000`00000000 00000000`00000000 0000000e`c20ee628 00000019`00000000 : sqllang!CSQLSource::Execute+0x866
00000000`6778dc50 000007fd`6a2bc4c5 : 0000000e`c20ee218 0000000e`c20ee218 00000000`00000000 00000000`6778dd28 : sqllang!CStmtExecProc::XretLocalExec+0x201
00000000`6778dcd0 000007fd`6a2b9dc8 : 00000000`00000000 000007fd`6a2ec738 0000000e`c20ee160 00000019`b86950b0 : sqllang!CStmtExecProc::XretExecExecute+0x4d5
00000000`6778e470 000007fd`694103b1 : 0000000e`c20b4430 0000000e`c20f2040 0000000e`c20f2040 0000000e`c2083f10 : sqllang!CXStmtExecProc::XretExecute+0x38
00000000`6778e4b0 000007fd`6942a58b : 00000022`13973e12 00000000`00000000 0000000e`c20f3170 000007fd`6945369a : sqllang!CMsqlExecContext::ExecuteStmts<1,1>+0x400
00000000`6778e5d0 000007fd`69429cc4 : 0000000e`c20b4150 0000000e`c20f2040 0000000e`c20f8000 0000000e`c20f6100 : sqllang!CMsqlExecContext::FExecute+0xa33
00000000`6778e7c0 000007fd`6944ee4c : 0000000e`c20f1da0 0000000e`c20f1da0 0000000e`c20f6100 00000000`00000000 : sqllang!CSQLSource::Execute+0x866
00000000`6778e980 000007fd`69444827 : 00000000`00000000 00000000`00000000 00000000`00000001 00000000`00000000 : sqllang!process_request+0x73c
00000000`6778f050 000007fd`74b13740 : 0000001b`ff8a0f40 00000000`00000000 ffffffff`ffffffff 00000000`6778f440 : sqllang!process_commands+0x51c
00000000`6778f310 000007fd`74b13be4 : 0000001b`ff8a0f58 00000000`00000200 00000000`0499ccf8 00000000`00000000 : sqldk!SOS_Task::Param::Execute+0x21e
00000000`6778f910 000007fd`74b139e7 : 0000001b`ff8a0040 00000000`0499ccf8 0000001b`ff8a0040 00000000`00000000 : sqldk!SOS_Scheduler::RunTask+0xa8
00000000`6778f980 000007fd`74b41d3f : 0000001b`ff300158 00000000`04976160 00000000`04976160 00000000`04976160 : sqldk!SOS_Scheduler::ProcessTasks+0x29a
00000000`6778fa00 000007fd`74b424a0 : 00000000`04976160 00000021`9dc8ba4f 00000000`04976160 00000000`000dbba0 : sqldk!SchedulerManager::WorkerEntryPoint+0x261
00000000`6778faa0 000007fd`74b432eb : 000007f6`2a215508 00000000`6778fb40 0000001b`ff300258 00000000`00001338 : sqldk!SystemThread::RunWorker+0x8f
00000000`6778fad0 000007fd`74b41b68 : 00000000`00000000 000007f6`2a215508 00000000`00000000 00000000`00000000 : sqldk!SystemThreadDispatcher::ProcessWorker+0x3c8
00000000`6778fb80 000007fd`8fa61842 : 00000000`00000000 00000000`00000000 000007f6`2a215508 00000000`00000000 : sqldk!SchedulerManager::ThreadEntryPoint+0x236
00000000`6778fc20 000007fd`8fbddf11 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : kernel32!BaseThreadInitThunk+0x1a
00000000`6778fc50 00000000`00000000 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : ntdll!RtlUserThreadStart+0x1d
STACK_COMMAND: ~0s; .ecxr ; kb
FOLLOWUP_IP:
sqllang!SQLDumperLibraryInvoke+2e4 [e:\sql11_main_t\sqltdbms\msql\utils\watson.cpp @ 573]
000007fd`6a5c5a94 8bd8 mov ebx,eax
FAULTING_SOURCE_LINE: e:\sql11_main_t\sqltdbms\msql\utils\watson.cpp
FAULTING_SOURCE_FILE: e:\sql11_main_t\sqltdbms\msql\utils\watson.cpp
FAULTING_SOURCE_LINE_NUMBER: 573
SYMBOL_STACK_INDEX: 2
SYMBOL_NAME: sqllang!SQLDumperLibraryInvoke+2e4
FOLLOWUP_NAME: wintriag
MODULE_NAME: sqllang
IMAGE_NAME: sqllang.dll
DEBUG_FLR_IMAGE_TIMESTAMP: 513ae1d6
FAILURE_BUCKET_ID: APPLICATION_FAULT_MISSING_CLR_METADATA_42ac_sqllang.dll!SQLDumperLibraryInvoke
BUCKET_ID: APPLICATION_FAULT_APPLICATION_FAULT_MISSING_CLR_METADATA_sqllang!SQLDumperLibraryInvoke+2e4
ANALYSIS_SOURCE: UM
FAILURE_ID_HASH_STRING: um:application_fault_missing_clr_metadata_42ac_sqllang.dll!sqldumperlibraryinvoke
FAILURE_ID_HASH: {d3e12259-659c-ce4a-0698-f422925e8301}
Followup: wintriag
---------
February 24, 2016 at 11:33 am
1) find out what happens at the 30 minute frequency
2) Anything in SQL error log before the crash?
3) trend various counters and utilizations (especially various memory buckets) from restart to crash
4) review every patch after yours for anything that was fixed that stopped a crash
5) open a ticket with Microsoft support
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 24, 2016 at 11:50 am
Here is the dump details on errorlog
2016-02-24 10:47:42.700 spid72 ex_raise2: Exception raised, major=52, minor=42, state=9, severity=22, attempting to create symptom dump
2016-02-24 10:47:42.700 spid72 Using 'dbghelp.dll' version '4.0.5'
2016-02-24 10:47:42.700 spid72 **Dump thread - spid = 0, EC = 0x00000008250590C0
2016-02-24 10:47:42.700 spid72 ***Stack Dump being sent to G:\MSSQL11.01\MSSQL\LOG\SQLDump10000.txt
2016-02-24 10:47:42.700 spid72 * *******************************************************************************
2016-02-24 10:47:42.700 spid72 *
2016-02-24 10:47:42.700 spid72 * BEGIN STACK DUMP:
2016-02-24 10:47:42.700 spid72 * 02/24/16 10:47:42 spid 72
2016-02-24 10:47:42.700 spid72 *
2016-02-24 10:47:42.700 spid72 * ex_raise2: Exception raised, major=52, minor=42, state=9, severity=22
2016-02-24 10:47:42.700 spid72 *
2016-02-24 10:47:42.700 spid72 * Input Buffer 157 bytes -
2016-02-24 10:47:42.700 spid72 * 16 00 00 00 12 00 00 00 02 00 00 00 00 00 00 00 00 00
2016-02-24 10:47:42.700 spid72 * p r c _ A P 01 00 00 00 1d 00 70 00 72 00 63 00 5f 00 41 00 50 00
2016-02-24 10:47:42.700 spid72 * P S t a g i n g P 50 00 53 00 74 00 61 00 67 00 69 00 6e 00 67 00 50 00
2016-02-24 10:47:42.700 spid72 * r o c e s s Q u e 72 00 6f 00 63 00 65 00 73 00 73 00 51 00 75 00 65 00
2016-02-24 10:47:42.700 spid72 * u e E n d @ P R 75 00 65 00 45 00 6e 00 64 00 00 00 0a 40 00 50 00 52
2016-02-24 10:47:42.700 spid72 * O C E S S I D & 00 4f 00 43 00 45 00 53 00 53 00 49 00 44 00 00 26 04
2016-02-24 10:47:42.700 spid72 * ~? @ Q U E U E 04 0c 7e 8c 00 0a 40 00 51 00 55 00 45 00 55 00 45 00
2016-02-24 10:47:42.700 spid72 * N A M E § Ð 4 4e 00 41 00 4d 00 45 00 00 a7 80 00 09 04 d0 00 34 0c
2016-02-24 10:47:42.700 spid72 * ACCOUNTQUEUE 00 41 43 43 4f 55 4e 54 51 55 45 55 45
2016-02-24 10:47:42.700 spid72 *
2016-02-24 10:47:42.700 spid72 *
2016-02-24 10:47:42.700 spid72 * MODULE BASE END SIZE
2016-02-24 10:47:42.700 spid72 * sqlservr 000007F7A16D0000 000007F7A170DFFF 0003e000
2016-02-24 10:47:42.700 spid72 * ntdll 000007FC9EFC0000 000007FC9F17CFFF 001bd000
2016-02-24 10:47:42.700 spid72 * KERNEL32 000007FC9CC30000 000007FC9CD66FFF 00137000
2016-02-24 10:47:42.700 spid72 * KERNELBASE 000007FC9C280000 000007FC9C373FFF 000f4000
2016-02-24 10:47:42.700 spid72 * ADVAPI32 000007FC9E890000 000007FC9E96EFFF 000df000
2016-02-24 10:47:42.700 spid72 * MSVCR100 000000006E400000 000000006E4D1FFF 000d2000
2016-02-24 10:47:42.700 spid72 * MSVCP100 000000006E330000 000000006E3C7FFF 00098000
2016-02-24 10:47:42.700 spid72 * sqlos 000000006D070000 000000006D076FFF 00007000
2016-02-24 10:47:42.700 spid72 * NETAPI32 000007FC9A760000 000007FC9A774FFF 00015000
2016-02-24 10:47:42.700 spid72 * pdh 000007FC8FA40000 000007FC8FA8BFFF 0004c000
2016-02-24 10:47:42.700 spid72 * opends60 000000006D060000 000000006D067FFF 00008000
2016-02-24 10:47:42.700 spid72 * sqlmin 000007FC7F830000 000007FC81777FFF 01f48000
2016-02-24 10:47:42.700 spid72 * sqllang 000007FC7D7A0000 000007FC7F82EFFF 0208f000
2016-02-24 10:47:42.700 spid72 * sqlTsEs 000007FC87EE0000 000007FC88766FFF 00887000
2016-02-24 10:47:42.700 spid72 * sqldk 000007FC87A60000 000007FC87ED8FFF 00479000
2016-02-24 10:47:42.700 spid72 * msvcrt 000007FC9C5D0000 000007FC9C674FFF 000a5000
2016-02-24 10:47:42.700 spid72 * sechost 000007FC9C560000 000007FC9C5A7FFF 00048000
2016-02-24 10:47:42.700 spid72 * RPCRT4 000007FC9CD70000 000007FC9CEB4FFF 00145000
2016-02-24 10:47:42.700 spid72 * netutils 000007FC9A920000 000007FC9A92DFFF 0000e000
2016-02-24 10:47:42.700 spid72 * srvcli 000007FC9B9E0000 000007FC9BA03FFF 00024000
2016-02-24 10:47:42.700 spid72 * wkscli 000007FC9A780000 000007FC9A794FFF 00015000
2016-02-24 10:47:42.700 spid72 * USER32 000007FC9EA10000 000007FC9EB5BFFF 0014c000
2016-02-24 10:47:42.700 spid72 * ole32 000007FC9E710000 000007FC9E88DFFF 0017e000
2016-02-24 10:47:42.700 spid72 * OLEAUT32 000007FC9CF20000 000007FC9CFE2FFF 000c3000
2016-02-24 10:47:42.700 spid72 * CRYPT32 000007FC9BFA0000 000007FC9C170FFF 001d1000
2016-02-24 10:47:42.700 spid72 * Secur32 000007FC97050000 000007FC9705AFFF 0000b000
2016-02-24 10:47:42.700 spid72 * PSAPI 000007FC9CC20000 000007FC9CC26FFF 00007000
2016-02-24 10:47:42.700 spid72 * WS2_32 000007FC9C4A0000 000007FC9C4F7FFF 00058000
2016-02-24 10:47:42.700 spid72 * USERENV 000007FC9C210000 000007FC9C22EFFF 0001f000
2016-02-24 10:47:42.700 spid72 * AUTHZ 000007FC9B1A0000 000007FC9B1E6FFF 00047000
2016-02-24 10:47:42.700 spid72 * WINTRUST 000007FC9C1B0000 000007FC9C204FFF 00055000
2016-02-24 10:47:42.700 spid72 * WINMM 000007FC8B710000 000007FC8B72FFFF 00020000
2016-02-24 10:47:42.700 spid72 * GDI32 000007FC9E5C0000 000007FC9E700FFF 00141000
2016-02-24 10:47:42.700 spid72 * combase 000007FC9EB60000 000007FC9ED10FFF 001b1000
2016-02-24 10:47:42.700 spid72 * MSASN1 000007FC9BED0000 000007FC9BEE5FFF 00016000
2016-02-24 10:47:42.710 spid72 * NSI 000007FC9D150000 000007FC9D158FFF 00009000
2016-02-24 10:47:42.710 spid72 * profapi 000007FC9BEB0000 000007FC9BEC4FFF 00015000
2016-02-24 10:47:42.710 spid72 * WINMMBASE 000007FC8A960000 000007FC8A991FFF 00032000
2016-02-24 10:47:42.710 spid72 * SSPICLI 000007FC9BBD0000 000007FC9BBFCFFF 0002d000
2016-02-24 10:47:42.710 spid72 * LOGONCLI 000007FC9B420000 000007FC9B453FFF 00034000
2016-02-24 10:47:42.710 spid72 * SAMCLI 000007FC9BDA0000 000007FC9BDB5FFF 00016000
2016-02-24 10:47:42.710 spid72 * CRYPTBASE 000007FC9BC60000 000007FC9BC69FFF 0000a000
2016-02-24 10:47:42.710 spid72 * bcryptPrimitives 000007FC9BC00000 000007FC9BC5CFFF 0005d000
2016-02-24 10:47:42.710 spid72 * instapi110 000007FC935F0000 000007FC935FDFFF 0000e000
2016-02-24 10:47:42.710 spid72 * CLUSAPI 000007FC8D810000 000007FC8D86EFFF 0005f000
2016-02-24 10:47:42.710 spid72 * cryptdll 000007FC9B7F0000 000007FC9B803FFF 00014000
2016-02-24 10:47:42.710 spid72 * RESUTILS 000007FC8D770000 000007FC8D80CFFF 0009d000
2016-02-24 10:47:42.710 spid72 * cscapi 000007FC8D3E0000 000007FC8D3F0FFF 00011000
2016-02-24 10:47:42.710 spid72 * sqlevn70 000000006B030000 000000006B2A9FFF 0027a000
2016-02-24 10:47:42.710 spid72 * CRYPTSP 000007FC9B7D0000 000007FC9B7E9FFF 0001a000
2016-02-24 10:47:42.710 spid72 * rsaenh 000007FC9B320000 000007FC9B36AFFF 0004b000
2016-02-24 10:47:42.710 spid72 * imagehlp 000007FC9C5B0000 000007FC9C5C3FFF 00014000
2016-02-24 10:47:42.710 spid72 * ncrypt 000007FC9B8D0000 000007FC9B8F4FFF 00025000
2016-02-24 10:47:42.710 spid72 * bcrypt 000007FC9B890000 000007FC9B8B4FFF 00025000
2016-02-24 10:47:42.710 spid72 * NTASN1 000007FC9B850000 000007FC9B884FFF 00035000
2016-02-24 10:47:42.710 spid72 * gpapi 000007FC9B0F0000 000007FC9B10EFFF 0001f000
2016-02-24 10:47:42.710 spid72 * ntmarta 000007FC97B50000 000007FC97B7DFFF 0002e000
2016-02-24 10:47:42.710 spid72 * VERSION 000007FC99660000 000007FC99668FFF 00009000
2016-02-24 10:47:42.710 spid72 * msv1_0 000007FC9B520000 000007FC9B572FFF 00053000
2016-02-24 10:47:42.710 spid72 * kerberos 000007FC9B6A0000 000007FC9B76FFFF 000d0000
2016-02-24 10:47:42.710 spid72 * schannel 000007FC9B3B0000 000007FC9B418FFF 00069000
2016-02-24 10:47:42.710 spid72 * MSCOREE 000007FC96FB0000 000007FC9701EFFF 0006f000
2016-02-24 10:47:42.710 spid72 * mscoreei 000007FC96F10000 000007FC96FA8FFF 00099000
2016-02-24 10:47:42.710 spid72 * security 000007FC8D5F0000 000007FC8D5F2FFF 00003000
2016-02-24 10:47:42.710 spid72 * clbcatq 000007FC9E970000 000007FC9EA05FFF 00096000
2016-02-24 10:47:42.710 spid72 * sqlncli11 000000006ACD0000 000000006B022FFF 00353000
2016-02-24 10:47:42.710 spid72 * COMCTL32 000007FC905E0000 000007FC90683FFF 000a4000
2016-02-24 10:47:42.710 spid72 * COMDLG32 000007FC9C380000 000007FC9C420FFF 000a1000
2016-02-24 10:47:42.710 spid72 * SHLWAPI 000007FC9CEC0000 000007FC9CF0FFFF 00050000
2016-02-24 10:47:42.710 spid72 * SHELL32 000007FC9D160000 000007FC9E444FFF 012e5000
2016-02-24 10:47:42.710 spid72 * SHCORE 000007FC9A450000 000007FC9A4E5FFF 00096000
2016-02-24 10:47:42.710 spid72 * SQLNCLIR11 000000006C060000 000000006C097FFF 00038000
2016-02-24 10:47:42.710 spid72 * DPAPI 000007FC9A950000 000007FC9A957FFF 00008000
2016-02-24 10:47:42.710 spid72 * clr 000007FC965A0000 000007FC96F0AFFF 0096b000
2016-02-24 10:47:42.710 spid72 * MSVCR110_CLR0400 000007FC964C0000 000007FC96591FFF 000d2000
2016-02-24 10:47:42.710 spid72 * mscorlib.ni 000007FC94EC0000 000007FC964B9FFF 015fa000
2016-02-24 10:47:42.710 spid72 * SqlAccess 000000005E020000 000000005E08CFFF 0006d000
2016-02-24 10:47:42.710 spid72 * clrjit 000007FC8F8E0000 000007FC8FA10FFF 00131000
2016-02-24 10:47:42.710 spid72 * BatchParser 000000006BF80000 000000006BFAAFFF 0002b000
2016-02-24 10:47:42.710 spid72 * ftimport 0000000060000000 0000000060024FFF 00025000
2016-02-24 10:47:42.710 spid72 * MSFTE 000000005F1F0000 000000005F59DFFF 003ae000
2016-02-24 10:47:42.710 spid72 * dbghelp 000000006AB30000 000000006ACC5FFF 00196000
2016-02-24 10:47:42.710 spid72 * mswsock 000007FC9B580000 000007FC9B5DBFFF 0005c000
2016-02-24 10:47:42.710 spid72 * ntdsapi 000007FC9A7A0000 000007FC9A7C3FFF 00024000
2016-02-24 10:47:42.710 spid72 * DSPARSE 000007FC97660000 000007FC9766AFFF 0000b000
2016-02-24 10:47:42.710 spid72 * DNSAPI 000007FC9B600000 000007FC9B69BFFF 0009c000
2016-02-24 10:47:42.710 spid72 * rasadhlp 000007FC97650000 000007FC97657FFF 00008000
2016-02-24 10:47:42.710 spid72 * IPHLPAPI 000007FC9A3D0000 000007FC9A3F9FFF 0002a000
2016-02-24 10:47:42.710 spid72 * WINNSI 000007FC99650000 000007FC99659FFF 0000a000
2016-02-24 10:47:42.710 spid72 * fwpuclnt 000007FC99580000 000007FC995E0FFF 00061000
2016-02-24 10:47:42.710 spid72 * ncryptsslp 000007FC8D5D0000 000007FC8D5E9FFF 0001a000
2016-02-24 10:47:42.710 spid72 * xpsqlbot 000000006BBD0000 000000006BBD7FFF 00008000
2016-02-24 10:47:42.710 spid72 * xpstar 000000006BBF0000 000000006BC5FFFF 00070000
2016-02-24 10:47:42.710 spid72 * ATL100 000000006E3D0000 000000006E3FAFFF 0002b000
2016-02-24 10:47:42.710 spid72 * SQLSCM 000000006BC70000 000000006BC7EFFF 0000f000
2016-02-24 10:47:42.710 spid72 * ODBC32 000007FC8C860000 000007FC8C91DFFF 000be000
2016-02-24 10:47:42.710 spid72 * xpstar 000000006BC90000 000000006BCB4FFF 00025000
2016-02-24 10:47:42.710 spid72 * xplog70 000000006BCD0000 000000006BCE3FFF 00014000
2016-02-24 10:47:42.710 spid72 * BROWCLI 000007FC8EED0000 000007FC8EEE1FFF 00012000
2016-02-24 10:47:42.710 spid72 * xplog70 000000006BD80000 000000006BD82FFF 00003000
2016-02-24 10:47:42.710 spid72 * DSROLE 000007FC9A910000 000007FC9A918FFF 00009000
2016-02-24 10:47:42.710 spid72 * dbghelp 0000000023C30000 0000000023DC5FFF 00196000
2016-02-24 10:47:42.710 spid72 *
2016-02-24 10:47:42.710 spid72 * P1Home: 000000006537CE90: 0000000000000000 0000000000000008 00000000007A0000 0000000000000080 0000000000000074 000007FC9EFC5640
2016-02-24 10:47:42.710 spid72 * P2Home: 0000000000000042:
2016-02-24 10:47:42.710 spid72 * P3Home: 0000000000000000:
2016-02-24 10:47:42.710 spid72 * P4Home: 0000000000000000:
2016-02-24 10:47:42.710 spid72 * P5Home: 00000000006B02BC: 0108000900070008 010A000B0109000A 000C000D000B000C 000E000F010D000E 00100011000F0010 0012001300110012
2016-02-24 10:47:42.710 spid72 * P6Home: 000007FC7D7D7028: 004AF5F8880FC085 ED870FC73B489848 3CF418840F004AF5 C38B30247C8B4800 90C35B5E38C48348 2414894C10EC8348
2016-02-24 10:47:42.710 spid72 * ContextFlags: 000000000010004F:
2016-02-24 10:47:42.710 spid72 * MxCsr: 0000000000001FA0:
2016-02-24 10:47:42.710 spid72 * SegCs: 0000000000000033:
2016-02-24 10:47:42.710 spid72 * SegDs: 000000000000002B:
2016-02-24 10:47:42.710 spid72 * SegEs: 000000000000002B:
2016-02-24 10:47:42.710 spid72 * SegFs: 0000000000000053:
2016-02-24 10:47:42.710 spid72 * SegGs: 000000000000002B:
2016-02-24 10:47:42.710 spid72 * SegSs: 000000000000002B:
2016-02-24 10:47:42.710 spid72 * EFlags: 0000000000000206:
2016-02-24 10:47:42.710 spid72 * Rax: 0000000000000080:
2016-02-24 10:47:42.710 spid72 * Rcx: 0000000000000074:
2016-02-24 10:47:42.710 spid72 * Rdx: 000007FC9EFC5640: 4100000108C48148 9090C35B5E5E415F 9090909090909090 9090909090909090 44894C20244C8944 5441575655531824
2016-02-24 10:47:42.710 spid72 * Rbx: 0000000000000000:
2016-02-24 10:47:42.710 spid72 * Rsp: 000000006537D440: 0000000000000000 0000000000000000 00000008250590C0 000000006537D6D0 00000000000042AC 0000000000000000
2016-02-24 10:47:42.710 spid72 * Rbp: 000000006537F0A0: 0072005F00780065 0065007300690061 00450020003A0032 0070006500630078 006E006F00690074 0069006100720020
2016-02-24 10:47:42.710 spid72 * Rsi: 00000008250590C0: 00000008250590C0 000000083098D020 0000000000000000 0000000000000000 00000008250590E0 00000008250590E0
2016-02-24 10:47:42.710 spid72 * Rdi: 000000006537D6D0: 00000000678C8F40 0000000000000000 000000006537D870 000000006537D730 000000006537D710 000007FC7F8CAD3C
2016-02-24 10:47:42.710 spid72 * R8: 000000006537D021: 3238303030303030 0030433039353035 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2016-02-24 10:47:42.710 spid72 * R9: 0000000000000002:
2016-02-24 10:47:42.710 spid72 * R10: 0000000000000000:
2016-02-24 10:47:42.710 spid72 * R11: 0000006A00000100:
2016-02-24 10:47:42.710 spid72 * R12: 0000000000000001:
2016-02-24 10:47:42.710 spid72 * R13: 0000000000000001:
2016-02-24 10:47:42.710 spid72 * R14: 0000000000000000:
2016-02-24 10:47:42.710 spid72 * R15: 000000000000083F:
2016-02-24 10:47:42.710 spid72 * Rip: 000007FC9C2A4650: 000000C0248C8B48 FFFDCDB0E8CC3348 C3000000D8C48148 9090909090909090 38418B4D28EC8348 11E8D18B49CA8B48
2016-02-24 10:47:42.710 spid72 * *******************************************************************************
2016-02-24 10:47:42.710 spid72 * -------------------------------------------------------------------------------
2016-02-24 10:47:42.710 spid72 * Short Stack Dump
2016-02-24 10:47:42.720 spid72 000007FC9C2A4650 Module(KERNELBASE+0000000000024650)
2016-02-24 10:47:42.720 spid72 000007FC7E927E5E Module(sqllang+0000000001187E5E)
2016-02-24 10:47:42.720 spid72 000007FC7E92CD43 Module(sqllang+000000000118CD43)
2016-02-24 10:47:42.720 spid72 000007FC7E92C54A Module(sqllang+000000000118C54A)
2016-02-24 10:47:42.720 spid72 000007FC87AB4BDD Module(sqldk+0000000000054BDD)
2016-02-24 10:47:42.730 spid72 000007FC87A97639 Module(sqldk+0000000000037639)
2016-02-24 10:47:42.730 spid72 000007FC80E42286 Module(sqlmin+0000000001612286)
2016-02-24 10:47:42.730 spid72 000007FC7FAC46DF Module(sqlmin+00000000002946DF)
2016-02-24 10:47:42.730 spid72 000007FC7F8C19E8 Module(sqlmin+00000000000919E8)
2016-02-24 10:47:42.730 spid72 000007FC7F8B378C Module(sqlmin+000000000008378C)
2016-02-24 10:47:42.730 spid72 000007FC7F8B5F23 Module(sqlmin+0000000000085F23)
2016-02-24 10:47:42.730 spid72 000007FC7F8B61D6 Module(sqlmin+00000000000861D6)
2016-02-24 10:47:42.730 spid72 000007FC7F8B6066 Module(sqlmin+0000000000086066)
2016-02-24 10:47:42.730 spid72 000007FC7F8BC320 Module(sqlmin+000000000008C320)
2016-02-24 10:47:42.730 spid72 000007FC87EE7F27 Module(sqlTsEs+0000000000007F27)
2016-02-24 10:47:42.730 spid72 000007FC7F8BCB23 Module(sqlmin+000000000008CB23)
2016-02-24 10:47:42.730 spid72 000007FC7F8BCA96 Module(sqlmin+000000000008CA96)
2016-02-24 10:47:42.730 spid72 000007FC7F86671F Module(sqlmin+000000000003671F)
2016-02-24 10:47:42.730 spid72 000007FC7D7D2051 Module(sqllang+0000000000032051)
2016-02-24 10:47:42.730 spid72 000007FC7D7FCB9D Module(sqllang+000000000005CB9D)
2016-02-24 10:47:42.730 spid72 000007FC7D7FC9A9 Module(sqllang+000000000005C9A9)
2016-02-24 10:47:42.730 spid72 000007FC7D7B03B1 Module(sqllang+00000000000103B1)
2016-02-24 10:47:42.730 spid72 000007FC7D7CA58B Module(sqllang+000000000002A58B)
2016-02-24 10:47:42.730 spid72 000007FC7D7C9CC4 Module(sqllang+0000000000029CC4)
2016-02-24 10:47:42.730 spid72 000007FC7E626F33 Module(sqllang+0000000000E86F33)
2016-02-24 10:47:42.730 spid72 000007FC7E62F132 Module(sqllang+0000000000E8F132)
2016-02-24 10:47:42.740 spid72 000007FC7E62E73C Module(sqllang+0000000000E8E73C)
2016-02-24 10:47:42.740 spid72 000007FC7DCFA588 Module(sqllang+000000000055A588)
2016-02-24 10:47:42.740 spid72 000007FC7E65CA51 Module(sqllang+0000000000EBCA51)
2016-02-24 10:47:42.740 spid72 000007FC7E65C4C5 Module(sqllang+0000000000EBC4C5)
2016-02-24 10:47:42.740 spid72 000007FC7E659DC8 Module(sqllang+0000000000EB9DC8)
2016-02-24 10:47:42.740 spid72 000007FC7D7B03B1 Module(sqllang+00000000000103B1)
2016-02-24 10:47:42.740 spid72 000007FC7D7CA58B Module(sqllang+000000000002A58B)
2016-02-24 10:47:42.740 spid72 000007FC7D7C9CC4 Module(sqllang+0000000000029CC4)
2016-02-24 10:47:42.740 spid72 000007FC7E65CA51 Module(sqllang+0000000000EBCA51)
2016-02-24 10:47:42.740 spid72 000007FC7E65C4C5 Module(sqllang+0000000000EBC4C5)
2016-02-24 10:47:42.740 spid72 000007FC7E659DC8 Module(sqllang+0000000000EB9DC8)
2016-02-24 10:47:42.740 spid72 000007FC7D7B03B1 Module(sqllang+00000000000103B1)
2016-02-24 10:47:42.740 spid72 000007FC7D7CA58B Module(sqllang+000000000002A58B)
2016-02-24 10:47:42.740 spid72 000007FC7D7C9CC4 Module(sqllang+0000000000029CC4)
2016-02-24 10:47:42.740 spid72 000007FC7D7EEE4C Module(sqllang+000000000004EE4C)
2016-02-24 10:47:42.740 spid72 000007FC7D7E4827 Module(sqllang+0000000000044827)
2016-02-24 10:47:42.740 spid72 000007FC87A73740 Module(sqldk+0000000000013740)
2016-02-24 10:47:42.740 spid72 000007FC87A73BE4 Module(sqldk+0000000000013BE4)
2016-02-24 10:47:42.740 spid72 000007FC87A739E7 Module(sqldk+00000000000139E7)
2016-02-24 10:47:42.740 spid72 000007FC87AA1D3F Module(sqldk+0000000000041D3F)
2016-02-24 10:47:42.740 spid72 000007FC87AA24A0 Module(sqldk+00000000000424A0)
2016-02-24 10:47:42.740 spid72 000007FC87AA32EB Module(sqldk+00000000000432EB)
2016-02-24 10:47:42.750 spid72 000007FC87AA1B68 Module(sqldk+0000000000041B68)
2016-02-24 10:47:42.760 spid72 000007FC9CC31842 Module(KERNEL32+0000000000001842)
2016-02-24 10:47:42.760 spid72 000007FC9EFD4F45 Module(ntdll+0000000000014F45)
2016-02-24 10:47:42.760 spid72 Stack Signature for the dump is 0x00000000C8A93FC0
February 24, 2016 at 3:29 pm
What is running in an automated fashion every 30 minutes on the system? 3rd party backup software? Something? Kevin has a pretty good order for trying to figure out what's up.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 24, 2016 at 4:54 pm
We ran the checkDB on all the databases. There were 2 user databases which has index corruption.
We moved 2 databases 2 some other servers and issue is resolved.
But we tried to fix on the same server we couldn't succeed.
February 24, 2016 at 8:02 pm
meajaykr (2/24/2016)
We ran the checkDB on all the databases. There were 2 user databases which has index corruption.We moved 2 databases 2 some other servers and issue is resolved.
But we tried to fix on the same server we couldn't succeed.
PLEASE try to do others a favor and get Microsoft a copy of the database and your server configuration!! That is several scenarios that should not happen (database corruption that causes crash and also which can be fixed on a different server but not the original one).
Also, you MUST IMMEDIATELY validate EVERYTHING in your IO stack, and I mean everything. Every piece of hardware, firmware, driver, etc. that exists between SQL Server's RAM and the physical media the data is stored on. It is VERY likely that the cause of the corruption is there.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 24, 2016 at 8:09 pm
meajaykr (2/24/2016)
We ran the checkDB on all the databases. There were 2 user databases which has index corruption.We moved 2 databases 2 some other servers and issue is resolved.
But we tried to fix on the same server we couldn't succeed.
Did you try dropping and rebuilding the corrupt indexes???
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply