October 13, 2015 at 8:51 am
Today our live SQL Server 2012 Standard Edition (64-bit) instance restarted itself at 11:02 after an apparent crash at 11:01. The SQL Server Error Log does not provide much information, other than to show the SQL Server service apparently restarting and the databases all starting up, etc.
Can anyone please suggest as to how we can establish the cause of this crash? Further details below:
Event Viewer (Application Error)
Faulting application name: sqlservr.exe, version: 2011.110.2100.60, time stamp: 0x4f36496e
Faulting module name: ntdll.dll, version: 6.1.7601.18247, time stamp: 0x521eaf24
Exception code: 0xc0000374
Fault offset: 0x00000000000c4102
Faulting process id: 0x155c
Faulting application start time: 0x01d08bfa7cdf5078
Faulting application path: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqlservr.exe
Faulting module path: C:\Windows\SYSTEM32tdll.dll
Report Id: 8d24c8aa-7191-11e5-8edb-a0b3cce3757a
Event Viewer (Windows Error Reporting)
Fault bucket , type 0
Event Name: APPCRASH
Response: Not available
Cab Id: 0
Problem signature:
P1: sqlservr.exe
P2: 2011.110.2100.60
P3: 4f36496e
P4: StackHash_c079
P5: 6.1.7601.18247
P6: 521eaf24
P7: c0000374
P8: 00000000000c4102
P9:
P10:
Attached files:
These files may be available here:
C:\ProgramData\Microsoft\Windows\WER\ReportQueue\AppCrash_sqlservr.exe_bf484d3326613537d93ef323825fc4feebfe9_ab4b7bd9
Analysis symbol:
Rechecking for solution: 0
Report Id: 8d24c8aa-7191-11e5-8edb-a0b3cce3757a
Report Status: 4
Report.wer
Version=1
EventType=APPCRASH
EventTime=130892041669358970
ReportType=2
Consent=1
ReportIdentifier=8d24c8ab-7191-11e5-8edb-a0b3cce3757a
IntegratorReportIdentifier=8d24c8aa-7191-11e5-8edb-a0b3cce3757a
Response.type=4
Sig[0].Name=Application Name
Sig[0].Value=sqlservr.exe
Sig[1].Name=Application Version
Sig[1].Value=2011.110.2100.60
Sig[2].Name=Application Timestamp
Sig[2].Value=4f36496e
Sig[3].Name=Fault Module Name
Sig[3].Value=StackHash_c079
Sig[4].Name=Fault Module Version
Sig[4].Value=6.1.7601.18247
Sig[5].Name=Fault Module Timestamp
Sig[5].Value=521eaf24
Sig[6].Name=Exception Code
Sig[6].Value=c0000374
Sig[7].Name=Exception Offset
Sig[7].Value=00000000000c4102
DynamicSig[1].Name=OS Version
DynamicSig[1].Value=6.1.7601.2.1.0.272.7
DynamicSig[2].Name=Locale ID
DynamicSig[2].Value=2057
DynamicSig[22].Name=Additional Information 1
DynamicSig[22].Value=c079
DynamicSig[23].Name=Additional Information 2
DynamicSig[23].Value=c07955958d00d72cfd1cde3c5df47df8
DynamicSig[24].Name=Additional Information 3
DynamicSig[24].Value=d6a4
DynamicSig[25].Name=Additional Information 4
DynamicSig[25].Value=d6a440097cbd23c06c2f8f8604947e63
UI[2]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqlservr.exe
UI[5]=Check online for a solution (recommended)
UI[6]=Check for a solution later (recommended)
UI[7]=Close
UI[8]=SQL Server Windows NT - 64 Bit stopped working and was closed
UI[9]=A problem caused the application to stop working correctly. Windows will notify you if a solution is available.
UI[10]=&Close
LoadedModule[0]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqlservr.exe
LoadedModule[1]=C:\Windows\SYSTEM32tdll.dll
LoadedModule[2]=C:\Windows\system32\kernel32.dll
LoadedModule[3]=C:\Windows\system32\KERNELBASE.dll
LoadedModule[4]=C:\Windows\system32\ADVAPI32.dll
LoadedModule[5]=C:\Windows\system32\msvcrt.dll
LoadedModule[6]=C:\Windows\SYSTEM32\sechost.dll
LoadedModule[7]=C:\Windows\system32\RPCRT4.dll
LoadedModule[8]=C:\Windows\system32\MSVCR100.dll
LoadedModule[9]=C:\Windows\system32\MSVCP100.dll
LoadedModule[10]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqlos.dll
LoadedModule[11]=C:\Windows\system32\NETAPI32.dll
LoadedModule[12]=C:\Windows\system32etutils.dll
LoadedModule[13]=C:\Windows\system32\srvcli.dll
LoadedModule[14]=C:\Windows\system32\wkscli.dll
LoadedModule[15]=C:\Windows\system32\pdh.dll
LoadedModule[16]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\opends60.dll
LoadedModule[17]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqlmin.dll
LoadedModule[18]=C:\Windows\system32\USER32.dll
LoadedModule[19]=C:\Windows\system32\GDI32.dll
LoadedModule[20]=C:\Windows\system32\LPK.dll
LoadedModule[21]=C:\Windows\system32\USP10.dll
LoadedModule[22]=C:\Windows\system32\ole32.dll
LoadedModule[23]=C:\Windows\system32\OLEAUT32.dll
LoadedModule[24]=C:\Windows\system32\Secur32.dll
LoadedModule[25]=C:\Windows\system32\SSPICLI.DLL
LoadedModule[26]=C:\Windows\system32\PSAPI.DLL
LoadedModule[27]=C:\Windows\system32\WS2_32.dll
LoadedModule[28]=C:\Windows\system32\NSI.dll
LoadedModule[29]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqlTsEs.dll
LoadedModule[30]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqldk.dll
LoadedModule[31]=C:\Windows\system32\WINMM.dll
LoadedModule[32]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqllang.dll
LoadedModule[33]=C:\Windows\system32\USERENV.dll
LoadedModule[34]=C:\Windows\system32\profapi.dll
LoadedModule[35]=C:\Windows\system32\LOGONCLI.DLL
LoadedModule[36]=C:\Windows\system32\SAMCLI.DLL
LoadedModule[37]=C:\Windows\system32\AUTHZ.dll
LoadedModule[38]=C:\Windows\system32\WINTRUST.dll
LoadedModule[39]=C:\Windows\system32\CRYPT32.dll
LoadedModule[40]=C:\Windows\system32\MSASN1.dll
LoadedModule[41]=C:\Windows\system32\IMM32.DLL
LoadedModule[42]=C:\Windows\system32\MSCTF.dll
LoadedModule[43]=C:\Windows\system32\CRYPTBASE.dll
LoadedModule[44]=C:\Program Files\Microsoft SQL Server\110\Shared\instapi110.dll
LoadedModule[45]=C:\Windows\system32\cscapi.dll
LoadedModule[46]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1033\sqlevn70.rll
LoadedModule[47]=C:\Windows\system32\CRYPTSP.dll
LoadedModule[48]=C:\Windows\system32\rsaenh.dll
LoadedModule[49]=C:\Windows\system32\imagehlp.dll
LoadedModule[50]=C:\Windows\system32crypt.dll
LoadedModule[51]=C:\Windows\system32\bcrypt.dll
LoadedModule[52]=C:\Windows\system32\bcryptprimitives.dll
LoadedModule[53]=C:\Windows\system32\GPAPI.dll
LoadedModule[54]=C:\Windows\system32\cryptnet.dll
LoadedModule[55]=C:\Windows\system32\WLDAP32.dll
LoadedModule[56]=C:\Windows\system32\SHLWAPI.dll
LoadedModule[57]=C:\Windows\system32tmarta.dll
LoadedModule[58]=C:\Windows\system32\VERSION.dll
LoadedModule[59]=C:\Windows\system32\credssp.dll
LoadedModule[60]=C:\Windows\system32\msv1_0.DLL
LoadedModule[61]=C:\Windows\system32\cryptdll.dll
LoadedModule[62]=C:\Windows\system32\kerberos.DLL
LoadedModule[63]=C:\Windows\system32\schannel.DLL
LoadedModule[64]=C:\Windows\system32\MSCOREE.DLL
LoadedModule[65]=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\mscoreei.dll
LoadedModule[66]=C:\Windows\system32\CLUSAPI.DLL
LoadedModule[67]=C:\Windows\system32\RESUTILS.DLL
LoadedModule[68]=C:\Windows\system32\security.dll
LoadedModule[69]=C:\Windows\system32\CLBCatQ.DLL
LoadedModule[70]=C:\Windows\system32\sqlncli11.dll
LoadedModule[71]=C:\Windows\WinSxS\amd64_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.18201_none_a4d3b9377117c3df\COMCTL32.dll
LoadedModule[72]=C:\Windows\system32\COMDLG32.dll
LoadedModule[73]=C:\Windows\system32\SHELL32.dll
LoadedModule[74]=C:\Windows\system32\1033\SQLNCLIR11.RLL
LoadedModule[75]=C:\Windows\system32etbios.dll
LoadedModule[76]=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll
LoadedModule[77]=C:\Windows\system32\MSVCR110_CLR0400.dll
LoadedModule[78]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\BatchParser.dll
LoadedModule[79]=C:\Windows\assembly\NativeImages_v4.0.30319_64\mscorlib\abf62e6545d2802fc60286678a67e6bf\mscorlib.ni.dll
LoadedModule[80]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\SqlAccess.dll
LoadedModule[81]=C:\Windows\Microsoft.NET\Framework64\v4.0.30319lssorting.dll
LoadedModule[82]=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clrjit.dll
LoadedModule[83]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\ftimport.dll
LoadedModule[84]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\MSFTE.DLL
LoadedModule[85]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\dbghelp.dll
LoadedModule[86]=C:\Windows\system32\mswsock.dll
LoadedModule[87]=C:\Windows\System32\wship6.dll
LoadedModule[88]=C:\Windows\System32\wshtcpip.dll
LoadedModule[89]=C:\Windows\system32tdsapi.dll
LoadedModule[90]=C:\Windows\system32\DNSAPI.dll
LoadedModule[91]=C:\Windows\system32\IPHLPAPI.DLL
LoadedModule[92]=C:\Windows\system32\WINNSI.DLL
LoadedModule[93]=C:\Windows\system32\rasadhlp.dll
LoadedModule[94]=C:\Windows\System32\fwpuclnt.dll
LoadedModule[95]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\xpstar.dll
LoadedModule[96]=C:\Windows\system32\ATL100.DLL
LoadedModule[97]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\SQLSCM.dll
LoadedModule[98]=C:\Windows\system32\ODBC32.dll
LoadedModule[99]=C:\Windows\system32\odbcint.dll
LoadedModule[100]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1033\xpstar.rll
LoadedModule[101]=C:\Windows\system32\dsrole.dll
LoadedModule[102]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\xpsqlbot.dll
LoadedModule[103]=C:\Program Files\Microsoft SQL Server\110\Shared\msxmlsql.dll
LoadedModule[104]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\odsole70.dll
LoadedModule[105]=C:\Windows\system32\SXS.DLL
LoadedModule[106]=C:\Program Files\Microsoft SQL Server\90\Shared\instapi.dll
LoadedModule[107]=C:\Windows\WinSxS\amd64_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4940_none_88df89932faf0bf6\MSVCR80.dll
LoadedModule[108]=C:\Windows\system32\apphelp.dll
LoadedModule[109]=C:\Windows\Microsoft.Net\assembly\GAC_64\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll
LoadedModule[110]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\xprepl.dll
LoadedModule[111]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1031\sqlevn70.rll
LoadedModule[112]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1036\sqlevn70.rll
LoadedModule[113]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1041\sqlevn70.rll
LoadedModule[114]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1030\sqlevn70.rll
LoadedModule[115]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\3082\sqlevn70.rll
LoadedModule[116]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1040\sqlevn70.rll
LoadedModule[117]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1043\sqlevn70.rll
LoadedModule[118]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\2070\sqlevn70.rll
LoadedModule[119]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1035\sqlevn70.rll
LoadedModule[120]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1053\sqlevn70.rll
LoadedModule[121]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1029\sqlevn70.rll
LoadedModule[122]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1038\sqlevn70.rll
LoadedModule[123]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1045\sqlevn70.rll
LoadedModule[124]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1032\sqlevn70.rll
LoadedModule[125]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1049\sqlevn70.rll
LoadedModule[126]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1055\sqlevn70.rll
LoadedModule[127]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1046\sqlevn70.rll
LoadedModule[128]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1028\sqlevn70.rll
LoadedModule[129]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1042\sqlevn70.rll
LoadedModule[130]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\2052\sqlevn70.rll
LoadedModule[131]=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Resources\1044\sqlevn70.rll
LoadedModule[132]=C:\Windows\IDAutomationDMATRIX64.dll
FriendlyEventName=Stopped working
ConsentKey=APPCRASH
AppName=SQL Server Windows NT - 64 Bit
AppPath=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqlservr.exe
November 13, 2015 at 5:23 am
Hi,
I had the exact same problem..did u find any solution for this ?
Thanks
Santosh
November 13, 2015 at 8:28 am
Take a look here, may apply to you
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
October 11, 2016 at 7:22 am
Same problem here. Same exact faulting module, exception code, and offset. I checked the technet article referenced and it does not apply (we are not using linked servers to Oracle). Did anyone find a solution to this?
We are running SQL 2012 SP1. The server that keeps crashing is an Always On asynchronous secondary replica in a remote DR data center.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply