Report For Server WIN-EE0KSP7U5MA Which Occurred On 6/29/2023 9:51:39 PM
Dump Reason: The lock_acquired action of an Extended Events session was set to take a dump on occurrence.
The dump was caused due to an extended event session specifying an action to take a dump. This had to be setup by someone (person) or something (tools) and is not normal for any system XE session.
Solution:
Run the following query to find the extended event session(s) with the offending action and either disable the session or remove the action.
| DumpImageName | C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Binn\sqlservr.exe |
| DumpOccurredTime | 6/29/2023 9:51:39 PM |
| ProcessUptimeInSeconds | 788396 |
| SystemUptimeInSeconds | 103514 |
| OSVersion | 20348.1.amd64fre.fe_release.210507-1500 |
| ProcessCommandLine | "C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER |
| SQLInstanceName | MSSQLSERVER |
| DumpComments | Stack Trace Dump triggered by event 'lock_acquired'. <Identity><Element key="BranchName" val="SQL22_RTM"/><Element key="OfficialBuild" val="true"/><Element key="BuildFlavor" val="Release (GoldenBits)"/><Element key="QBuildGuid" val="96e93555-ae44-9e4d-d40a-38bd00316b3a"/><Element key="QBuildSyncChangeset" val="d4447b86676b1964399e1644b86b3fda1296f7a7"/><Element key="GitBranchName" val="SQL22_RTM"/></Identity> |
| ProcessID | 4240 |
| DomainDNSName | |
| UserDomain | NT Service |
| ComputerName | WIN-EE0KSP7U5MA |
| ServiceAccoutName | MSSQLSERVER |
| UserProfileLocation | C:\Windows\ServiceProfiles\MSSQLSERVER |
| SystemManufacturer | Microsoft Corporation |
| SystemProduct | Virtual Machine |
| SQLServerVersion | 2022.160.1000.6 |
| GoodSymbols | True |
| SQLMajorVersion | 16 |
| CalculatedMaxWorkerThreads | 512 |
| SOSThreads | 1 |
| ThreadsWaitingOnLatches | 0 |
| ThreadsWaitingOnLocks | 1 |
| ThreadsWaitingOnSpinlocks | 0 |
| ThreadsInParallelQueries | 0 |
| IOCPThreads | 0 |
| LogWriterThreads | 0 |
| SQLExceptionThreads | 0 |
| WindowsExceptionThreads | 1 |
| ThreadsWaiting | 0 |
| SerialRedoThreads | 0 |
| ParallelRedoThreads | 0 |
| RedoHelperThreads | 0 |
| HADRTaskThreads | 0 |
| Backupthreads | 0 |
| ParallelBackupThreads | 0 |
| NumberOfCPUs | 2 |
| TotalThreads | 1 |
These modules were loaded into the SQL Server process space. Look for 3rd party items if you're having issues.
| Name | Product Version | File Version |
|---|---|---|
| sqlservr.exe | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| ntdll.dll | 10.0.20348.1129 | 10.0.20348.1129 (WinBuild.160101.0800) |
| kernel32.dll | 10.0.20348.1366 | 10.0.20348.1366 (WinBuild.160101.0800) |
| KERNELBASE.dll | 10.0.20348.1366 | 10.0.20348.1366 (WinBuild.160101.0800) |
| crypt32.dll | 10.0.20348.1194 | 10.0.20348.1194 (WinBuild.160101.0800) |
| ucrtbase.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| ws2_32.dll | 10.0.20348.261 | 10.0.20348.261 (WinBuild.160101.0800) |
| rpcrt4.dll | 10.0.20348.803 | 10.0.20348.803 (WinBuild.160101.0800) |
| advapi32.dll | 10.0.20348.1129 | 10.0.20348.1129 (WinBuild.160101.0800) |
| msvcrt.dll | 7.0.20348.1 | 7.0.20348.1 (WinBuild.160101.0800) |
| sechost.dll | 10.0.20348.587 | 10.0.20348.587 (WinBuild.160101.0800) |
| ole32.dll | 10.0.20348.261 | 10.0.20348.261 (WinBuild.160101.0800) |
| msvcp_win.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| gdi32.dll | 10.0.20348.1129 | 10.0.20348.1129 (WinBuild.160101.0800) |
| win32u.dll | 10.0.20348.825 | 10.0.20348.825 (WinBuild.160101.0800) |
| gdi32full.dll | 10.0.20348.1366 | 10.0.20348.1366 (WinBuild.160101.0800) |
| user32.dll | 10.0.20348.1311 | 10.0.20348.1311 (WinBuild.160101.0800) |
| combase.dll | 10.0.20348.1311 | 10.0.20348.1311 (WinBuild.160101.0800) |
| shlwapi.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| oleaut32.dll | 10.0.20348.143 | 10.0.20348.143 (WinBuild.160101.0800) |
| IPHLPAPI.DLL | 10.0.20348.261 | 10.0.20348.261 (WinBuild.160101.0800) |
| netapi32.dll | 10.0.20348.1129 | 10.0.20348.1129 (WinBuild.160101.0800) |
| pdh.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| sqlos.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| sqltses.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| qds.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| sqlmin.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| sqldk.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| sqllang.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| svl.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| wintrust.dll | 10.0.20348.1311 | 10.0.20348.1311 (WinBuild.160101.0800) |
| shell32.dll | 10.0.20348.1311 | 10.0.20348.1311 (WinBuild.160101.0800) |
| urlmon.dll | 11.00.20348.1249 | 11.00.20348.1249 (WinBuild.160101.0800) |
| msvcp140.dll | 14.29.30139.0 | 14.29.30139.0 built by: vcwrkspc |
| VCRUNTIME140.dll | 14.29.30139.0 | 14.29.30139.0 built by: vcwrkspc |
| userenv.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| secur32.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| xolehlp.dll | 10.0.20348.803 | 2001.12.10941.16384 (WinBuild.160101.0800) |
| winhttp.dll | 10.0.20348.1194 | 10.0.20348.1194 (WinBuild.160101.0800) |
| wininet.dll | 11.00.20348.380 | 11.00.20348.380 (WinBuild.160101.0800) |
| odbc32.dll | 10.0.20348.740 | 10.0.20348.740 (WinBuild.160101.0800) |
| winmm.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| mswsock.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| authz.dll | 10.0.20348.469 | 10.0.20348.469 (WinBuild.160101.0800) |
| version.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| webservices.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| dhcpcsvc.dll | 10.0.20348.1129 | 10.0.20348.1129 (WinBuild.160101.0800) |
| VCRUNTIME140_1.dll | 14.29.30139.0 | 14.29.30139.0 built by: vcwrkspc |
| iertutil.dll | 11.00.20348.1129 | 11.00.20348.1129 (WinBuild.160101.0800) |
| srvcli.dll | 10.0.20348.643 | 10.0.20348.643 (WinBuild.160101.0800) |
| netutils.dll | 10.0.20348.469 | 10.0.20348.469 (WinBuild.160101.0800) |
| samcli.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| dpapi.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| secforwarder.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| sspicli.dll | 10.0.20348.1194 | 10.0.20348.1194 (WinBuild.160101.0800) |
| bcrypt.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| ncrypt.dll | 10.0.20348.1194 | 10.0.20348.1194 (WinBuild.160101.0800) |
| logoncli.dll | 10.0.20348.1194 | 10.0.20348.1194 (WinBuild.160101.0800) |
| ntasn1.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| psapi.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| bcryptPrimitives.dll | 10.0.20348.803 | 10.0.20348.803 (WinBuild.160101.0800) |
| msasn1.dll | 10.0.20348.1249 | 10.0.20348.1249 (WinBuild.160101.0800) |
| kernel.appcore.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| instapi160.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| cryptsp.dll | 10.0.20348.1194 | 10.0.20348.1194 (WinBuild.160101.0800) |
| rsaenh.dll | 10.0.20348.169 | 10.0.20348.169 (WinBuild.160101.0800) |
| CRYPTBASE.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| imagehlp.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| gpapi.dll | 10.0.20348.803 | 10.0.20348.803 (WinBuild.160101.0800) |
| wkscli.dll | 10.0.20348.643 | 10.0.20348.643 (WinBuild.160101.0800) |
| cscapi.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| clusapi.dll | 10.0.20348.1366 | 10.0.20348.1366 (WinBuild.160101.0800) |
| resutils.dll | 10.0.20348.1311 | 10.0.20348.1311 (WinBuild.160101.0800) |
| hkruntime.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| dbghelp.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| hkcompile.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| hkengine.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| xmllite.dll | 10.0.20348.143 | 10.0.20348.143 (WinBuild.160101.0800) |
| opends60.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| ncryptprov.dll | 10.0.20348.1194 | 10.0.20348.1194 (WinBuild.160101.0800) |
| msv1_0.dll | 10.0.20348.1070 | 10.0.20348.1070 (WinBuild.160101.0800) |
| NtlmShared.dll | 10.0.20348.887 | 10.0.20348.887 (WinBuild.160101.0800) |
| cryptdll.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| kerberos.dll | 10.0.20348.1311 | 10.0.20348.1311 (WinBuild.160101.0800) |
| schannel.dll | 10.0.20348.1311 | 10.0.20348.1311 (WinBuild.160101.0800) |
| security.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| mscoree.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| mscoreei.dll | 4.8.4380.0 | 4.8.4380.0 built by: NET48REL1LAST_B |
| SqlServerSpatial160.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| clbcatq.dll | 10.0.20348.1070 | 2001.12.10941.16384 (WinBuild.160101.0800) |
| msxml3.dll | 8.110.20348.558 | 8.110.20348.558 |
| msoledbsql.dll | 18.6.0005.0 | 2018.0186.0005.00 |
| comdlg32.dll | 10.0.20348.803 | 10.0.20348.803 (WinBuild.160101.0800) |
| SHCore.dll | 10.0.20348.740 | 10.0.20348.740 (WinBuild.160101.0800) |
| comctl32.dll | 10.0.20348.1 | 5.82 (WinBuild.160101.0800) |
| nsi.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| dhcpcsvc6.DLL | 10.0.20348.1129 | 10.0.20348.1129 (WinBuild.160101.0800) |
| dnsapi.dll | 10.0.20348.1194 | 10.0.20348.1194 (WinBuild.160101.0800) |
| clr.dll | 4.8.4515.0 | 4.8.4515.0 built by: NET48REL1LAST_C |
| VCRUNTIME140_CLR0400.dll | 14.10.25028.0 | 14.10.25028.0 built by: VCTOOLSD15RTM |
| ucrtbase_clr0400.dll | 14.10.25028.0 | 14.10.25028.0 built by: VCTOOLSD15RTM |
| BatchParser.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| ualapi.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| ntmarta.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| esent.dll | 10.0.20348.1194 | 10.0.20348.1194 (WinBuild.160101.0800) |
| SqlAccess.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| windows.storage.dll | 10.0.20348.1311 | 10.0.20348.1311 (WinBuild.160101.0800) |
| clrjit.dll | 4.8.4515.0 | 4.8.4515.0 built by: NET48REL1LAST_C |
| profapi.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| mskeyprotect.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| ntdsapi.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| dsparse.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| ncryptsslp.dll | 10.0.20348.1 | 10.0.20348.1 (WinBuild.160101.0800) |
| xplog70.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| xpsqlbot.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| XPStar.DLL | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| sqlscm.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
| apphelp.dll | 10.0.20348.1070 | 10.0.20348.1070 (WinBuild.160101.0800) |
| SqlAccess.dll | 16.0.1000.6 | 2022.0160.1000.06 ((SQL22_RTM).221008-0913) |
These modules were loaded into the SQL Server process space and then at some later point, unloaded. Look for 3rd party items if you're having issues.
| Name |
|---|
| SQLBOOT.DLL |
| SQLSCRIPTUPGRADE.DLL |
| SQLSCRIPTUPGRADE.DLL |
| sqlboot.dll |