Hi, recently we are starting getting lock on our SQL DB. please support us why these lock is triggering.

Malintha Mendis 21 Reputation points
2021-09-06T10:48:32.913+00:00

021-09-06 13:02:01.80 spid1132 **Dump thread - spid = 0, EC = 0x0000001370752890
2021-09-06 13:02:01.80 spid1132 ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\LOG\SQLDump0134.txt
2021-09-06 13:02:01.80 spid1132 * *******************************************************************************
2021-09-06 13:02:01.80 spid1132 *
2021-09-06 13:02:01.80 spid1132 * BEGIN STACK DUMP:
2021-09-06 13:02:01.80 spid1132 * 09/06/21 13:02:01 spid 1132
2021-09-06 13:02:01.80 spid1132 *
2021-09-06 13:02:01.80 spid1132 * Location: tmpilb.cpp:2576
2021-09-06 13:02:01.80 spid1132 * Expression: fFalse
2021-09-06 13:02:01.80 spid1132 * SPID: 1132
2021-09-06 13:02:01.80 spid1132 * Process ID: 1916
2021-09-06 13:02:01.80 spid1132 * Description: Attempt to access expired blob handle (3)
2021-09-06 13:02:01.80 spid1132 *
2021-09-06 13:02:01.80 spid1132 * Input Buffer 380 bytes -
2021-09-06 13:02:01.80 spid1132 * Select Comments As Comment,[User],DateTime From EasternpakSys
2021-09-06 13:02:01.80 spid1132 * DB.dbo.Dashboard_Comments With(nolock) Where Item_ID='213522' And Item_S
2021-09-06 13:02:01.80 spid1132 * lNO='3' And Item_Type=4 Order by DateTime Desc
2021-09-06 13:02:01.80 spid1132 *
2021-09-06 13:02:01.80 spid1132 *
2021-09-06 13:02:01.80 spid1132 * MODULE BASE END SIZE
2021-09-06 13:02:01.80 spid1132 * sqlservr 00007FF713EA0000 00007FF713EF9FFF 0005a000
2021-09-06 13:02:01.80 spid1132 * ntdll 00007FFE05120000 00007FFE052CCFFF 001ad000
2021-09-06 13:02:01.80 spid1132 * KERNEL32 00007FFE04B80000 00007FFE04CBEFFF 0013f000
2021-09-06 13:02:01.80 spid1132 * KERNELBASE 00007FFE02440000 00007FFE02554FFF 00115000
2021-09-06 13:02:01.80 spid1132 * ADVAPI32 00007FFE027A0000 00007FFE02849FFF 000aa000
2021-09-06 13:02:01.80 spid1132 * MSVCR100 0000000055400000 00000000554D1FFF 000d2000
2021-09-06 13:02:01.80 spid1132 * MSVCP100 0000000055330000 00000000553C7FFF 00098000
2021-09-06 13:02:01.80 spid1132 * sqlos 0000000055320000 0000000055326FFF 00007000
2021-09-06 13:02:01.80 spid1132 * NETAPI32 00007FFE003C0000 00007FFE003D5FFF 00016000
2021-09-06 13:02:01.80 spid1132 * pdh 00007FFDF7B50000 00007FFDF7B9EFFF 0004f000
2021-09-06 13:02:01.80 spid1132 * opends60 0000000055310000 0000000055317FFF 00008000
2021-09-06 13:02:01.80 spid1132 * sqlmin 00007FFDF5BE0000 00007FFDF7B4EFFF 01f6f000
2021-09-06 13:02:01.80 spid1132 * sqllang 00007FFDF3AF0000 00007FFDF5BD6FFF 020e7000
2021-09-06 13:02:01.80 spid1132 * sqlTsEs 00007FFDF3160000 00007FFDF39E6FFF 00887000
2021-09-06 13:02:01.80 spid1132 * sqldk 00007FFDF2CD0000 00007FFDF3153FFF 00484000
2021-09-06 13:02:01.80 spid1132 * msvcrt 00007FFE028C0000 00007FFE02969FFF 000aa000
2021-09-06 13:02:01.80 spid1132 * sechost 00007FFE04B20000 00007FFE04B77FFF 00058000
2021-09-06 13:02:01.80 spid1132 * RPCRT4 00007FFE04360000 00007FFE04499FFF 0013a000
2021-09-06 13:02:01.80 spid1132 * netutils 00007FFE008E0000 00007FFE008EBFFF 0000c000
2021-09-06 13:02:01.80 spid1132 * srvcli 00007FFE01FC0000 00007FFE01FE5FFF 00026000
2021-09-06 13:02:01.80 spid1132 * wkscli 00007FFE008F0000 00007FFE00906FFF 00017000
2021-09-06 13:02:01.80 spid1132 * USER32 00007FFE040F0000 00007FFE04266FFF 00177000
2021-09-06 13:02:01.80 spid1132 * ole32 00007FFE04EE0000 00007FFE05074FFF 00195000
2021-09-06 13:02:01.80 spid1132 * OLEAUT32 00007FFE049F0000 00007FFE04AB5FFF 000c6000
2021-09-06 13:02:01.80 spid1132 * CRYPT32 00007FFE02560000 00007FFE0273DFFF 001de000
2021-09-06 13:02:01.80 spid1132 * Secur32 00007FFDFD7A0000 00007FFDFD7ABFFF 0000c000
2021-09-06 13:02:01.80 spid1132 * PSAPI 00007FFE04880000 00007FFE04886FFF 00007000
2021-09-06 13:02:01.80 spid1132 * WS2_32 00007FFE050C0000 00007FFE05119FFF 0005a000
2021-09-06 13:02:01.80 spid1132 * USERENV 00007FFE01810000 00007FFE01830FFF 00021000
2021-09-06 13:02:01.80 spid1132 * AUTHZ 00007FFE01570000 00007FFE015B7FFF 00048000
2021-09-06 13:02:01.80 spid1132 * WINTRUST 00007FFE02740000 00007FFE02790FFF 00051000
2021-09-06 13:02:01.80 spid1132 * WINMM 00007FFDF2CA0000 00007FFDF2CC1FFF 00022000
2021-09-06 13:02:01.80 spid1132 * SspiCli 00007FFE02410000 00007FFE0243DFFF 0002e000
2021-09-06 13:02:01.80 spid1132 * GDI32 00007FFE044A0000 00007FFE045EDFFF 0014e000
2021-09-06 13:02:01.80 spid1132 * combase 00007FFE04CC0000 00007FFE04ED0FFF 00211000
2021-09-06 13:02:01.80 spid1132 * MSASN1 00007FFE022F0000 00007FFE02300FFF 00011000
2021-09-06 13:02:01.80 spid1132 * NSI 00007FFE04870000 00007FFE04878FFF 00009000
2021-09-06 13:02:01.80 spid1132 * profapi 00007FFE02240000 00007FFE02254FFF 00015000
2021-09-06 13:02:01.80 spid1132 * WINMMBASE 00007FFDF2C70000 00007FFDF2C99FFF 0002a000
2021-09-06 13:02:01.80 spid1132 * LOGONCLI 00007FFE01840000 00007FFE0187EFFF 0003f000
2021-09-06 13:02:01.80 spid1132 * cfgmgr32 00007FFE02310000 00007FFE0235EFFF 0004f000
2021-09-06 13:02:01.80 spid1132 * DEVOBJ 00007FFE01090000 00007FFE010B7FFF 00028000
2021-09-06 13:02:01.80 spid1132 * SAMCLI 00007FFDFD7D0000 00007FFDFD7E6FFF 00017000
2021-09-06 13:02:01.80 spid1132 * CRYPTBASE 00007FFE020B0000 00007FFE020BAFFF 0000b000
2021-09-06 13:02:01.80 spid1132 * bcryptPrimitives 00007FFE02040000 00007FFE020A2FFF 00063000
2021-09-06 13:02:01.80 spid1132 * instapi110 00007FFDFD6F0000 00007FFDFD6FDFFF 0000e000
2021-09-06 13:02:01.80 spid1132 * cscapi 00007FFDF2C20000 00007FFDF2C31FFF 00012000
2021-09-06 13:02:01.80 spid1132 * sqlevn70 0000000055090000 000000005530AFFF 0027b000
2021-09-06 13:02:01.80 spid1132 * CRYPTSP 00007FFE01AE0000 00007FFE01AFFFFF 00020000
2021-09-06 13:02:01.80 spid1132 * rsaenh 00007FFE01720000 00007FFE01755FFF 00036000
2021-09-06 13:02:01.80 spid1132 * bcrypt 00007FFE01D20000 00007FFE01D45FFF 00026000
2021-09-06 13:02:01.80 spid1132 * imagehlp 00007FFE04340000 00007FFE04355FFF 00016000
2021-09-06 13:02:01.80 spid1132 * ncrypt 00007FFE01CF0000 00007FFE01D14FFF 00025000
2021-09-06 13:02:01.80 spid1132 * NTASN1 00007FFE01CB0000 00007FFE01CE6FFF 00037000
2021-09-06 13:02:01.80 spid1132 * gpapi 00007FFE01460000 00007FFE01483FFF 00024000
2021-09-06 13:02:01.80 spid1132 * VERSION 00007FFDFD7C0000 00007FFDFD7C9FFF 0000a000
2021-09-06 13:02:01.80 spid1132 * msv1_0 00007FFE01A10000 00007FFE01A7AFFF 0006b000
2021-09-06 13:02:01.80 spid1132 * cryptdll 00007FFE01BF0000 00007FFE01C09FFF 0001a000
2021-09-06 13:02:01.80 spid1132 * kerberos 00007FFE01B00000 00007FFE01BEEFFF 000ef000
2021-09-06 13:02:01.80 spid1132 * schannel 00007FFE016B0000 00007FFE0171DFFF 0006e000
2021-09-06 13:02:01.80 spid1132 * MSCOREE 00007FFDFC5F0000 00007FFDFC653FFF 00064000
2021-09-06 13:02:01.80 spid1132 * mscoreei 00007FFDFC4C0000 00007FFDFC569FFF 000aa000
2021-09-06 13:02:01.80 spid1132 * SqlServerSpatial110 0000000054D80000 0000000054E3CFFF 000bd000
2021-09-06 13:02:01.80 spid1132 * CLUSAPI 00007FFDF1510000 00007FFDF157DFFF 0006e000
2021-09-06 13:02:01.80 spid1132 * RESUTILS 00007FFDF14C0000 00007FFDF150BFFF 0004c000
2021-09-06 13:02:01.80 spid1132 * security 00007FFDF2C40000 00007FFDF2C42FFF 00003000
2021-09-06 13:02:01.80 spid1132 * ualapi 00007FFDFDB00000 00007FFDFDB18FFF 00019000
2021-09-06 13:02:01.80 spid1132 * ESENT 00007FFDFD830000 00007FFDFDAF9FFF 002ca000
2021-09-06 13:02:01.80 spid1132 * ntmarta 00007FFDFED40000 00007FFDFED71FFF 00032000
2021-09-06 13:02:01.80 spid1132 * SHELL32 00007FFE02BC0000 00007FFE040EDFFF 0152e000
2021-09-06 13:02:01.80 spid1132 * SHLWAPI 00007FFE04AC0000 00007FFE04B13FFF 00054000
2021-09-06 13:02:01.80 spid1132 * kernel.appcore 00007FFE00EB0000 00007FFE00EBAFFF 0000b000
2021-09-06 13:02:01.80 spid1132 * clbcatq 00007FFE047B0000 00007FFE04865FFF 000b6000
2021-09-06 13:02:01.80 spid1132 * sqlncli11 00007FFDF0B90000 00007FFDF0EE2FFF 00353000
2021-09-06 13:02:01.80 spid1132 * COMCTL32 00007FFDF0AE0000 00007FFDF0B83FFF 000a4000
2021-09-06 13:02:01.80 spid1132 * COMDLG32 00007FFE04280000 00007FFE04335FFF 000b6000
2021-09-06 13:02:01.80 spid1132 * SHCORE 00007FFE00910000 00007FFE009C1FFF 000b2000
2021-09-06 13:02:01.80 spid1132 * BatchParser 00007FFDF0400000 00007FFDF042AFFF 0002b000
2021-09-06 13:02:01.80 spid1132 * DPAPI 00007FFE00EA0000 00007FFE00EA9FFF 0000a000
2021-09-06 13:02:01.80 spid1132 * SQLNCLIR11 0000000054C30000 0000000054C67FFF 00038000
2021-09-06 13:02:01.80 spid1132 * netbios 00007FFDF0AD0000 00007FFDF0ADAFFF 0000b000
2021-09-06 13:02:01.80 spid1132 * clr 00007FFDFB9F0000 00007FFDFC4B0FFF 00ac1000
2021-09-06 13:02:01.80 spid1132 * VCRUNTIME140_CLR0400 00007FFDFC880000 00007FFDFC895FFF 00016000
2021-09-06 13:02:01.80 spid1132 * ucrtbase_clr0400 00007FFDFC7C0000 00007FFDFC87CFFF 000bd000
2021-09-06 13:02:01.80 spid1132 * mscorlib.ni 00007FFDFA120000 00007FFDFB71FFFF 01600000
2021-09-06 13:02:01.80 spid1132 * ftimport 000000003A900000 000000003A924FFF 00025000
2021-09-06 13:02:01.80 spid1132 * MSFTE 0000000049980000 0000000049D2DFFF 003ae000
2021-09-06 13:02:01.80 spid1132 * dbghelp 00000000547E0000 0000000054975FFF 00196000
2021-09-06 13:02:01.80 spid1132 * clrjit 00007FFDF0430000 00007FFDF057EFFF 0014f000
2021-09-06 13:02:01.80 spid1132 * mswsock 00007FFE01A80000 00007FFE01AD8FFF 00059000
2021-09-06 13:02:01.80 spid1132 * ntdsapi 00007FFE002C0000 00007FFE002E8FFF 00029000
2021-09-06 13:02:01.80 spid1132 * DSPARSE 00007FFDFD790000 00007FFDFD79CFFF 0000d000
2021-09-06 13:02:01.80 spid1132 * DNSAPI 00007FFE01880000 00007FFE01923FFF 000a4000
2021-09-06 13:02:01.80 spid1132 * rasadhlp 00007FFDFDC10000 00007FFDFDC19FFF 0000a000
2021-09-06 13:02:01.80 spid1132 * IPHLPAPI 00007FFDFF870000 00007FFDFF899FFF 0002a000
2021-09-06 13:02:01.80 spid1132 * WINNSI 00007FFE00320000 00007FFE00329FFF 0000a000
2021-09-06 13:02:01.80 spid1132 * fwpuclnt 00007FFDFF8A0000 00007FFDFF90AFFF 0006b000
2021-09-06 13:02:01.80 spid1132 * ncryptsslp 00007FFDF14A0000 00007FFDF14BCFFF 0001d000
2021-09-06 13:02:01.80 spid1132 * SAMLIB 00007FFDFDB70000 00007FFDFDB91FFF 00022000
2021-09-06 13:02:01.80 spid1132 * xpsqlbot 0000000054200000 0000000054207FFF 00008000
2021-09-06 13:02:01.80 spid1132 * xpstar 00007FFDE8450000 00007FFDE84BFFFF 00070000
2021-09-06 13:02:01.80 spid1132 * ATL100 00000000553D0000 00000000553FAFFF 0002b000
2021-09-06 13:02:01.80 spid1132 * SQLSCM 00007FFDF0730000 00007FFDF073EFFF 0000f000
2021-09-06 13:02:01.80 spid1132 * ODBC32 00007FFDF0780000 00007FFDF0841FFF 000c2000
2021-09-06 13:02:01.80 spid1132 * xpstar 00007FFDE8420000 00007FFDE8444FFF 00025000
2021-09-06 13:02:01.80 spid1132 * xplog70 00007FFDE8400000 00007FFDE8413FFF 00014000
2021-09-06 13:02:01.80 spid1132 * BROWCLI 00007FFDFC5D0000 00007FFDFC5E2FFF 00013000
2021-09-06 13:02:01.80 spid1132 * xplog70 00000000541F0000 00000000541F2FFF 00003000
2021-09-06 13:02:01.80 spid1132 * oledb32 00007FFDE5000000 00007FFDE50F9FFF 000fa000
2021-09-06 13:02:01.80 spid1132 * MSDART 00007FFDE6880000 00007FFDE68A4FFF 00025000
2021-09-06 13:02:01.80 spid1132 * comsvcs 00007FFDE4E50000 00007FFDE4FFCFFF 001ad000
2021-09-06 13:02:01.80 spid1132 * OraOLEDB11 0000000001650000 00000000016DEFFF 0008f000
2021-09-06 13:02:01.80 spid1132 * OraOLEDBgmr11 0000000038830000 0000000038856FFF 00027000
2021-09-06 13:02:01.80 spid1132 * OraOLEDBrst11 0000000039C30000 0000000039C64FFF 00035000
2021-09-06 13:02:01.80 spid1132 * OraOLEDButl11 00000000016E0000 00000000016E8FFF 00009000
2021-09-06 13:02:01.80 spid1132 * OCI 0000000039C70000 0000000039D1AFFF 000ab000
2021-09-06 13:02:01.80 spid1132 * MSVCR80 0000000054F30000 0000000054FF8FFF 000c9000
2021-09-06 13:02:01.80 spid1132 * OraClient11 000000004E930000 000000004EDCDFFF 0049e000
2021-09-06 13:02:01.80 spid1132 * oracore11 0000000039DB0000 0000000039F0FFFF 00160000
2021-09-06 13:02:01.80 spid1132 * oranls11 0000000039F10000 000000003A00EFFF 000ff000
2021-09-06 13:02:01.80 spid1132 * oraunls11 0000000039D60000 0000000039D7FFFF 00020000
2021-09-06 13:02:01.80 spid1132 * oracommon11 000000004EDD0000 000000004F086FFF 002b7000
2021-09-06 13:02:01.80 spid1132 * orageneric11 000000004F090000 000000004FF90FFF 00f01000
2021-09-06 13:02:01.80 spid1132 * oran11 000000004FFA0000 00000000503F3FFF 00454000
2021-09-06 13:02:01.80 spid1132 * orancrypt11 000000003A010000 000000003A033FFF 00024000
2021-09-06 13:02:01.80 spid1132 * oraldapclnt11 000000003BF10000 000000003C101FFF 001f2000
2021-09-06 13:02:01.80 spid1132 * oranl11 000000003A040000 000000003A0AEFFF 0006f000
2021-09-06 13:02:01.80 spid1132 * oranro11 000000003A0B0000 000000003A10AFFF 0005b000
2021-09-06 13:02:01.80 spid1132 * orapls11 0000000050400000 0000000050920FFF 00521000
2021-09-06 13:02:01.80 spid1132 * orasql11 000000003A110000 000000003A16DFFF 0005e000
2021-09-06 13:02:01.80 spid1132 * orauts 0000000038880000 0000000038886FFF 00007000
2021-09-06 13:02:01.80 spid1132 * orasnls11 00000000498D0000 000000004990CFFF 0003d000
2021-09-06 13:02:01.80 spid1132 * oraxml11 0000000050930000 0000000050E0EFFF 004df000
2021-09-06 13:02:01.80 spid1132 * oracell11 0000000049910000 000000004995AFFF 0004b000
2021-09-06 13:02:01.80 spid1132 * orannzsbb11 0000000050E10000 0000000050F93FFF 00184000
2021-09-06 13:02:01.80 spid1132 * orahasgen11 0000000050FA0000 0000000051275FFF 002d6000
2021-09-06 13:02:01.80 spid1132 * oraocr11 0000000051280000 0000000051347FFF 000c8000
2021-09-06 13:02:01.80 spid1132 * orazt11 0000000051350000 000000005153FFFF 001f0000
2021-09-06 13:02:01.80 spid1132 * oranldap11 0000000051540000 000000005158AFFF 0004b000
2021-09-06 13:02:01.80 spid1132 * oranhost11 0000000049970000 0000000049979FFF 0000a000
2021-09-06 13:02:01.80 spid1132 * orancds11 0000000051590000 0000000051596FFF 00007000
2021-09-06 13:02:01.80 spid1132 * orantns11 00000000515A0000 00000000515B0FFF 00011000
2021-09-06 13:02:01.80 spid1132 * oraztkg11 00000000515C0000 0000000051672FFF 000b3000
2021-09-06 13:02:01.80 spid1132 * WSOCK32 00007FFDEB800000 00007FFDEB808FFF 00009000
2021-09-06 13:02:01.80 spid1132 * orantcp11 00000000516B0000 00000000516E4FFF 00035000
2021-09-06 13:02:01.80 spid1132 * oraslax11 0000000051710000 000000005171EFFF 0000f000
2021-09-06 13:02:01.80 spid1132 * oravsn11 0000000051720000 0000000051726FFF 00007000
2021-09-06 13:02:01.80 spid1132 * oraplp11 0000000051730000 0000000051B24FFF 003f5000
2021-09-06 13:02:01.80 spid1132 * MSVCP80 0000000054620000 0000000054728FFF 00109000
2021-09-06 13:02:01.80 spid1132 * oraocrutl11 0000000051BA0000 0000000051BB0FFF 00011000
2021-09-06 13:02:01.80 spid1132 * oraocrb11 0000000051BD0000 0000000051CC3FFF 000f4000
2021-09-06 13:02:01.80 spid1132 * OraPlc11 0000000051EB0000 0000000051ECFFFF 00020000
2021-09-06 13:02:01.80 spid1132 * OraOLEDB11us 0000000051FD0000 0000000051FD5FFF 00006000
2021-09-06 13:02:01.80 spid1132 * OraOLEDBpus11 0000000051FE0000 0000000051FE7FFF 00008000
2021-09-06 13:02:01.80 spid1132 * DSROLE 00007FFE00360000 00007FFE00369FFF 0000a000
2021-09-06 13:02:01.80 spid1132 * activeds 00007FFDED360000 00007FFDED3A8FFF 00049000
2021-09-06 13:02:01.80 spid1132 * adsldpc 00007FFDED3D0000 00007FFDED411FFF 00042000
2021-09-06 13:02:01.80 spid1132 * WLDAP32 00007FFE02970000 00007FFE029CBFFF 0005c000
2021-09-06 13:02:01.80 spid1132 * instapi 0000000048060000 000000004806CFFF 0000d000
2021-09-06 13:02:01.80 spid1132 * COMRES 00007FFDE54E0000 00007FFDE561DFFF 0013e000
2021-09-06 13:02:01.80 spid1132 * XOLEHLP 00007FFDFFB10000 00007FFDFFB25FFF 00016000
2021-09-06 13:02:01.80 spid1132 * MSDTCPRX 00007FFDFFB60000 00007FFDFFC41FFF 000e2000
2021-09-06 13:02:01.80 spid1132 * MTXCLU 00007FFDEB3E0000 00007FFDEB446FFF 00067000
2021-09-06 13:02:01.80 spid1132 * ktmw32 00007FFDFF250000 00007FFDFF25AFFF 0000b000
2021-09-06 13:02:01.80 spid1132 * Sort00060101 00007FFDF0AB0000 00007FFDF0AC2FFF 00013000
2021-09-06 13:02:01.80 spid1132 * System.ni 00007FFDF94A0000 00007FFDFA110FFF 00c71000
2021-09-06 13:02:01.80 spid1132 * System.Core.ni 00007FFDF8980000 00007FFDF93F4FFF 00a75000
2021-09-06 13:02:01.80 spid1132 * System.Data 00007FFDED690000 00007FFDED9FBFFF 0036c000
2021-09-06 13:02:01.80 spid1132 * System.Transactions 00007FFDED220000 00007FFDED26EFFF 0004f000
2021-09-06 13:02:01.80 spid1132 * System.Security.ni 00007FFDE6200000 00007FFDE62F7FFF 000f8000
2021-09-06 13:02:01.80 spid1132 * System.Xml.ni 00007FFDF7F90000 00007FFDF883AFFF 008ab000
2021-09-06 13:02:01.80 spid1132 * Sort00001000 00007FFDE1AD0000 00007FFDE1BA4FFF 000d5000
2021-09-06 13:02:01.80 spid1132 * ACEOLEDB 00007FFDED1B0000 00007FFDED21BFFF 0006c000
2021-09-06 13:02:01.80 spid1132 * VCRUNTIME140 00007FFDF0590000 00007FFDF05A6FFF 00017000
2021-09-06 13:02:01.80 spid1132 * api-ms-win-crt-string-l1-1-0 00007FFDFFC70000 00007FFDFFC73FFF 00004000
2021-09-06 13:02:01.80 spid1132 * api-ms-win-crt-heap-l1-1-0 00007FFDFC770000 00007FFDFC772FFF 00003000
2021-09-06 13:02:01.80 spid1132 * api-ms-win-crt-utility-l1-1-0 00007FFDFC5C0000 00007FFDFC5C2FFF 00003000
2021-09-06 13:02:01.80 spid1132 * api-ms-win-crt-time-l1-1-0 00007FFDF0AA0000 00007FFDF0AA2FFF 00003000
2021-09-06 13:02:01.80 spid1132 * api-ms-win-crt-stdio-l1-1-0 00007FFDEE7D0000 00007FFDEE7D3FFF 00004000
2021-09-06 13:02:01.80 spid1132 * api-ms-win-crt-runtime-l1-1-0 00007FFDEE7C0000 00007FFDEE7C3FFF 00004000
2021-09-06 13:02:01.80 spid1132 * api-ms-win-crt-locale-l1-1-0 00007FFDEE7B0000 00007FFDEE7B2FFF 00003000
2021-09-06 13:02:01.80 spid1132 * api-ms-win-crt-convert-l1-1-0 00007FFDEE7A0000 00007FFDEE7A3FFF 00004000
2021-09-06 13:02:01.80 spid1132 * ucrtbase 00007FFDE6720000 00007FFDE6813FFF 000f4000
2021-09-06 13:02:01.80 spid1132 * mso20win32client 00007FFDE6310000 00007FFDE6617FFF 00308000
2021-09-06 13:02:01.80 spid1132 * MSVCP140 00007FFDE6040000 00007FFDE60DDFFF 0009e000
2021-09-06 13:02:01.80 spid1132 * api-ms-win-crt-math-l1-1-0 00007FFDEE790000 00007FFDEE794FFF 00005000
2021-09-06 13:02:01.81 spid1132 * api-ms-win-crt-multibyte-l1-1-0 00007FFDEE780000 00007FFDEE784FFF 00005000
2021-09-06 13:02:01.81 spid1132 * api-ms-win-crt-filesystem-l1-1-0 00007FFDED2D0000 00007FFDED2D2FFF 00003000
2021-09-06 13:02:01.81 spid1132 * api-ms-win-crt-environment-l1-1-0 00007FFDED2C0000 00007FFDED2C2FFF 00003000
2021-09-06 13:02:01.81 spid1132 * mso30win32client 00007FFDE11E0000 00007FFDE1670FFF 00491000
2021-09-06 13:02:01.81 spid1132 * mso40uiwin32client 00007FFDDFBE0000 00007FFDE04CFFFF 008f0000
2021-09-06 13:02:01.81 spid1132 * gdiplus 00007FFDE5A20000 00007FFDE5BD0FFF 001b1000
2021-09-06 13:02:01.81 spid1132 * mso99Lwin32client 00007FFDDF400000 00007FFDDFBD1FFF 007d2000
2021-09-06 13:02:01.81 spid1132 * MSIMG32 00007FFDE4730000 00007FFDE4736FFF 00007000
2021-09-06 13:02:01.81 spid1132 * SLC 00007FFDFEE30000 00007FFDFEE5AFFF 0002b000
2021-09-06 13:02:01.81 spid1132 * sppc 00007FFDFED80000 00007FFDFEDA1FFF 00022000
2021-09-06 13:02:01.81 spid1132 * mso 00007FFDDD1A0000 00007FFDDE4A0FFF 01301000
2021-09-06 13:02:01.81 spid1132 * msi 00007FFDE0EA0000 00007FFDE11D3FFF 00334000
2021-09-06 13:02:01.81 spid1132 * Comctl32 00007FFDFFCD0000 00007FFDFFF4AFFF 0027b000
2021-09-06 13:02:01.81 spid1132 * ACECORE 00007FFDDF1B0000 00007FFDDF3FAFFF 0024b000
2021-09-06 13:02:01.81 spid1132 * d2d1 00007FFDFDF00000 00007FFDFE380FFF 00481000
2021-09-06 13:02:01.81 spid1132 * WTSAPI32 00007FFDFF820000 00007FFDFF831FFF 00012000
2021-09-06 13:02:01.81 spid1132 * WINSTA 00007FFE02160000 00007FFE021B9FFF 0005a000
2021-09-06 13:02:01.81 spid1132 * dxgi 00007FFDFF180000 00007FFDFF206FFF 00087000
2021-09-06 13:02:01.81 spid1132 * DWrite 00007FFDFE580000 00007FFDFE76BFFF 001ec000
2021-09-06 13:02:01.81 spid1132 * IMM32 00007FFE05080000 00007FFE050B5FFF 00036000
2021-09-06 13:02:01.81 spid1132 * MSCTF 00007FFE04890000 00007FFE049E0FFF 00151000
2021-09-06 13:02:01.81 spid1132 * d3d11 00007FFDFF570000 00007FFDFF7A2FFF 00233000
2021-09-06 13:02:01.81 spid1132 * d3d10_1 00007FFDED0D0000 00007FFDED102FFF 00033000
2021-09-06 13:02:01.81 spid1132 * d3d10_1core 00007FFDE5470000 00007FFDE54D3FFF 00064000
2021-09-06 13:02:01.81 spid1132 * ACEINTL 00007FFDE59A0000 00007FFDE59D4FFF 00035000
2021-09-06 13:02:01.81 spid1132 * ACEWSTR 00007FFDDED30000 00007FFDDEE04FFF 000d5000
2021-09-06 13:02:01.81 spid1132 * XmlLite 00007FFDFF210000 00007FFDFF248FFF 00039000
2021-09-06 13:02:01.81 spid1132 * mlang 00007FFDF29D0000 00007FFDF2A0DFFF 0003e000
2021-09-06 13:02:01.81 spid1132 * ACEES 00007FFDDEC50000 00007FFDDED2EFFF 000df000
2021-09-06 13:02:01.81 spid1132 * VBAJET32 00007FFDED2A0000 00007FFDED2A7FFF 00008000
2021-09-06 13:02:01.81 spid1132 * expsrv 00007FFDDEBD0000 00007FFDDEC4CFFF 0007d000
2021-09-06 13:02:01.81 spid1132 * msadce 00007FFDDE8D0000 00007FFDDE96FFFF 000a0000
2021-09-06 13:02:01.81 spid1132 * msadcer 00007FFDED2B0000 00007FFDED2B1FFF 00002000
2021-09-06 13:02:01.81 spid1132 * dbghelp 000000003EDA0000 000000003EF35FFF 00196000
2021-09-06 13:02:01.81 spid1132 *
2021-09-06 13:02:01.81 spid1132 * P1Home: 0000002CEE9BB0F0: 0000000000000000 0000000000000000 00009BD9012E0F9F 0000001000000000 000000000000000A 00000000FFFFFFFF
2021-09-06 13:02:01.81 spid1132 * P2Home: 0000000000000000:
2021-09-06 13:02:01.81 spid1132 * P3Home: 0000000000A10000: 0000000000000000 0100C67F18DBCF87 00000002FFEEFFEE 00000000022F0018 0000000000A10120 0000000000A10000
2021-09-06 13:02:01.81 spid1132 * P4Home: 0000000000000000:
2021-09-06 13:02:01.81 spid1132 * P5Home: 0000000000000000:
2021-09-06 13:02:01.81 spid1132 * P6Home: 000000000000000C:
2021-09-06 13:02:01.81 spid1132 * ContextFlags: 000000000010004F:
2021-09-06 13:02:01.81 spid1132 * MxCsr: 0000000000001FB0:
2021-09-06 13:02:01.81 spid1132 * SegCs: 0000000000000033:
2021-09-06 13:02:01.81 spid1132 * SegDs: 000000000000002B:
2021-09-06 13:02:01.81 spid1132 * SegEs: 000000000000002B:
2021-09-06 13:02:01.81 spid1132 * SegFs: 0000000000000053:
2021-09-06 13:02:01.81 spid1132 * SegGs: 000000000000002B:
2021-09-06 13:02:01.81 spid1132 * SegSs: 000000000000002B:
2021-09-06 13:02:01.81 spid1132 * EFlags: 0000000000000206:
2021-09-06 13:02:01.81 spid1132 * Rax: 000000A600000053:
2021-09-06 13:02:01.81 spid1132 * Rcx: 0000005300000000:
2021-09-06 13:02:01.81 spid1132 * Rdx: 0000000000000104:
2021-09-06 13:02:01.81 spid1132 * Rbx: 0000000000000000:
2021-09-06 13:02:01.81 spid1132 * Rsp: 0000002CEE9BB840: 0000000000000000 0000000000000000 0000001370752890 0000002CEE9BBAD0 00000000000042AC 0000000000000000
2021-09-06 13:02:01.81 spid1132 * Rbp: 0000002CEE9BD510: 00000A1000000000 FFFFFFFF00000001 0000000100000001 0000002CEE9BDE80 FFFFFFFFFFFFFFFE 0000000000000085
2021-09-06 13:02:01.81 spid1132 * Rsi: 0000001370752890: 0000001370752890 0000001370737020 0000000000000000 0000000000000000 00000013707528B0 00000013707528B0
2021-09-06 13:02:01.81 spid1132 * Rdi: 0000002CEE9BBAD0: 0000002D0365EA60 0000000036635DD0 0000000000000000 00007FFDF5CA0D54 0000001FB26FBC60 0000001C00000001
2021-09-06 13:02:01.81 spid1132 * R8: 0000000000000000:
2021-09-06 13:02:01.81 spid1132 * R9: 0000020800000003:
2021-09-06 13:02:01.81 spid1132 * R10: 0000000000000000:
2021-09-06 13:02:01.81 spid1132 * R11: 0000000000000000:
2021-09-06 13:02:01.81 spid1132 * R12: 0000000000000001:
2021-09-06 13:02:01.81 spid1132 * R13: 0000000000000001:
2021-09-06 13:02:01.81 spid1132 * R14: 0000000000000000:
2021-09-06 13:02:01.81 spid1132 * R15: 00000000000000BF:
2021-09-06 13:02:01.81 spid1132 * Rip: 00007FFE02447AFC: 000000C0248C8B48 FFFF9934E8CC3348 C3000000D8C48148 9090909090909090 38418B4D28EC8348 11E8D18B49CA8B48
2021-09-06 13:02:01.81 spid1132 * *******************************************************************************
2021-09-06 13:02:01.81 spid1132 * -------------------------------------------------------------------------------
2021-09-06 13:02:01.81 spid1132 * Short Stack Dump
2021-09-06 13:02:01.85 spid1132 00007FFE02447AFC Module(KERNELBASE+0000000000007AFC)
2021-09-06 13:02:01.85 spid1132 00007FFDF4C9F86E Module(sqllang+00000000011AF86E)
2021-09-06 13:02:01.86 spid1132 00007FFDF4CA4763 Module(sqllang+00000000011B4763)
2021-09-06 13:02:01.86 spid1132 00007FFDF4C9B7CC Module(sqllang+00000000011AB7CC)
2021-09-06 13:02:01.86 spid1132 00007FFDF2D44DC5 Module(sqldk+0000000000074DC5)
2021-09-06 13:02:01.86 spid1132 00007FFDF5E5A896 Module(sqlmin+000000000027A896)
2021-09-06 13:02:01.86 spid1132 00007FFDF3178773 Module(sqlTsEs+0000000000018773)
2021-09-06 13:02:01.86 spid1132 00007FFDF4052224 Module(sqllang+0000000000562224)
2021-09-06 13:02:01.86 spid1132 00007FFDF3B62123 Module(sqllang+0000000000072123)
2021-09-06 13:02:01.86 spid1132 00007FFDF3B623CB Module(sqllang+00000000000723CB)
2021-09-06 13:02:01.86 spid1132 00007FFDF3FF0D68 Module(sqllang+0000000000500D68)
2021-09-06 13:02:01.86 spid1132 00007FFDF3B1C6A7 Module(sqllang+000000000002C6A7)
2021-09-06 13:02:01.86 spid1132 00007FFDF3B1C872 Module(sqllang+000000000002C872)
2021-09-06 13:02:01.86 spid1132 00007FFDF3B59D04 Module(sqllang+0000000000069D04)
2021-09-06 13:02:01.86 spid1132 00007FFDF3B59B5B Module(sqllang+0000000000069B5B)
2021-09-06 13:02:01.87 spid1132 00007FFDF3B43DD8 Module(sqllang+0000000000053DD8)
2021-09-06 13:02:01.87 spid1132 00007FFDF3B3B237 Module(sqllang+000000000004B237)
2021-09-06 13:02:01.87 spid1132 00007FFDF2CE0480 Module(sqldk+0000000000010480)
2021-09-06 13:02:01.87 spid1132 00007FFDF2CE0264 Module(sqldk+0000000000010264)
2021-09-06 13:02:01.87 spid1132 00007FFDF2CDFF47 Module(sqldk+000000000000FF47)
2021-09-06 13:02:01.87 spid1132 00007FFDF2CFF3AF Module(sqldk+000000000002F3AF)
2021-09-06 13:02:01.87 spid1132 00007FFDF2CFF430 Module(sqldk+000000000002F430)
2021-09-06 13:02:01.87 spid1132 00007FFDF2CFE95E Module(sqldk+000000000002E95E)
2021-09-06 13:02:01.87 spid1132 00007FFDF2CFF209 Module(sqldk+000000000002F209)
2021-09-06 13:02:01.88 spid1132 00007FFE04B81412 Module(KERNEL32+0000000000001412)
2021-09-06 13:02:01.88 spid1132 00007FFE051354F4 Module(ntdll+00000000000154F4)
2021-09-06 13:02:01.88 spid1132 Stack Signature for the dump is 0x0000000010B9F8D9
2021-09-06 13:05:50.34 spid1132 Timeout waiting for external dump process 2708.

2021-09-06 13:05:50.34 spid1132 Error: 17065, Severity: 16, State: 1.
2021-09-06 13:05:50.34 spid1132 SQL Server Assertion: File: <tmpilb.cpp>, line = 2576 Failed Assertion = 'fFalse' Atte

SQL Server | Other
{count} votes

Accepted answer
  1. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2021-09-07T02:39:46.96+00:00

    Hi @Malintha Mendis ,

    Please apply the latest patch to your SQL server instance as others mentioned. Few people on this forum could analysis the dump file. If the issue still exist, suggest you asking professional engineer for help, and they will deal with your problem separately and confidentially. They have the tool to analysis the dump file. https://support.microsoft.com/en-us/assistedsupportproducts


    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Dan Guzman 9,406 Reputation points
    2021-09-06T12:21:49.8+00:00

    Errors causing stack dumps may be due to database corruption, hardware issues, or SQL Server bugs. Have you taken the actions suggested in the error message (DBCC CHECKDB, server restart)?

    Make sure you have the latest service pack installed (e.g. SP4 if you are on SQL 2012). If the problem persists, open a support case with Microsoft.

    0 comments No comments

  2. Vidhya Sagar Karthikeyan 396 Reputation points
    2021-09-06T16:07:11.613+00:00

    @Malintha Mendis - If I recall correctly, this was a bug in SQL 2016, 2017 & 2019. However, these were fixed in the later Cumulative updates. Make sure your server is patched with the CU mentioned in the KB article.

    Mark this as answer, if it helped you.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.