SQL Express 2022 database engine recovery handle failed

Question

Was attempting to download SQL express to follow instructions from Head first C# book.

I've followed microsoft document troubleshoot solutions and no luck yet.

The following are my error logs, any help or advice is appreciated. Thank you

TITLE: Microsoft SQL Server 2022 Setup

--------------------------------------------

The following error has occurred:

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

##############################################################################################################################################################################################################################################################################################

2022-12-06 00:26:43.86 Server Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64)
Oct 8 2022 05:58:25
Copyright (C) 2022 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 22000: ) (Hypervisor)

2022-12-06 00:26:43.86 Server UTC adjustment: -6:00
2022-12-06 00:26:43.86 Server (c) Microsoft Corporation.
2022-12-06 00:26:43.87 Server All rights reserved.
2022-12-06 00:26:43.87 Server Server process ID is 22392.
2022-12-06 00:26:43.87 Server System Manufacturer: 'LENOVO', System Model: '82JN'.
2022-12-06 00:26:43.87 Server Authentication mode is WINDOWS-ONLY.
2022-12-06 00:26:43.87 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2022-12-06 00:26:43.87 Server The service account is 'NT Service\MSSQL$SQLEXPRESS'. This is an informational message; no user action is required.
2022-12-06 00:26:43.87 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
2022-12-06 00:26:43.87 Server Command Line Startup Parameters:
-s "SQLEXPRESS"
-m "SqlSetup"
-Q
-q "SQL_Latin1_General_CP1_CI_AS"
-T 4022
-T 4010
-T 3659
-T 3610
-T 8015
-d "C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Template Data\master.mdf"
-l "C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Template Data\mastlog.ldf"
2022-12-06 00:26:43.87 Server SQL Server detected 1 sockets with 8 cores per socket and 16 logical processors per socket, 16 total logical processors; using 8 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2022-12-06 00:26:43.87 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2022-12-06 00:26:43.87 Server Detected 16167 MB of RAM. This is an informational message; no user action is required.
2022-12-06 00:26:43.87 Server Using conventional memory in the memory manager.
2022-12-06 00:26:43.87 Server Detected pause instruction latency: 88 cycles.
2022-12-06 00:26:43.87 Server Spin divider value used: 2
2022-12-06 00:26:43.87 Server Page exclusion bitmap is enabled.
2022-12-06 00:26:43.95 Server Buffer Pool: Allocating 4194304 bytes for 2539520 hashPages.
2022-12-06 00:26:43.96 Server Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2022-12-06 00:26:43.97 Server Buffer pool extension is already disabled. No action is necessary.
2022-12-06 00:26:44.02 Server CPU vectorization level(s) detected: SSE SSE2 SSE3 SSSE3 SSE41 SSE42 AVX AVX2 POPCNT BMI1 BMI2 AVX512 (F CD BW DQ VL IFMA VBMI VBMI2 VNNI BITALG VPOQCNTDQ VP2INTERSECT)
2022-12-06 00:26:44.04 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2022-12-06 00:26:44.05 Server Query Store settings initialized with enabled = 1,
2022-12-06 00:26:44.06 Server The maximum number of dedicated administrator connections for this instance is '1'
2022-12-06 00:26:44.06 Server Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2022-12-06 00:26:44.07 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2022-12-06 00:26:44.07 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
2022-12-06 00:26:44.08 Server In-Memory OLTP initialized on standard machine.
2022-12-06 00:26:44.09 Server [INFO] Created Extended Events session 'hkenginexesession'
2022-12-06 00:26:44.09 Server Database Instant File Initialization: enabled. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
2022-12-06 00:26:44.10 Server Total Log Writer threads: 2, Node CPUs: 4, Nodes: 1, Log Writer threads per CPU: 1, Log Writer threads per Node: 2
2022-12-06 00:26:44.10 Server Database Mirroring Transport is disabled in the endpoint configuration.
2022-12-06 00:26:44.10 Server clwb is selected for pmem flush operation.
2022-12-06 00:26:44.10 Server Software Usage Metrics is disabled.
2022-12-06 00:26:44.10 spid23s Warning ******************
2022-12-06 00:26:44.10 spid23s SQL Server started in single-user mode. This an informational message only. No user action is required.
2022-12-06 00:26:44.10 spid23s Starting up database 'master'.
2022-12-06 00:26:44.13 spid23s There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Template Data\master.mdf.
2022-12-06 00:26:44.15 spid23s Unable to create stack dump file due to stack shortage (ex_terminator - Last chance exception handling)
2022-12-06 00:26:44.15 spid23s Stack Signature for the dump is 0x0000000000000000
2022-12-06 00:26:44.15 spid23s CDmpClient::ExecuteAllCallbacks started.
2022-12-06 00:26:44.15 spid23s XE_DumpCallbacks is executing...
2022-12-06 00:26:44.16 spid23s DumpCallbackSOS is executing...
2022-12-06 00:26:44.16 spid23s DumpCallbackEE is executing...
2022-12-06 00:26:44.17 spid23s DumpCallbackSE is executing...
2022-12-06 00:26:44.17 spid23s DumpCallbackSEAM is executing...
2022-12-06 00:26:44.17 spid23s DumpCallbackSSB is executing...
2022-12-06 00:26:44.18 spid23s DumpCallbackQE is executing...
2022-12-06 00:26:44.18 spid23s DumpCallbackFullText is executing...
2022-12-06 00:26:44.18 spid23s DumpCallbackSQLCLR is executing...
2022-12-06 00:26:44.18 spid23s DumpCallbackHk is executing...
2022-12-06 00:26:44.19 spid23s DumpCallbackRepl is executing...
2022-12-06 00:26:44.19 spid23s DumpCallbackPolyBase is executing...
2022-12-06 00:26:44.19 spid23s CDmpClient::ExecuteAllCallbacks completed. Time elapsed: 0 seconds.
2022-12-06 00:26:44.21 Server CLR version v4.0.30319 loaded.
2022-12-06 00:26:44.26 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319.
2022-12-06 00:26:44.97 spid23s External dump process return code 0x20000001.
External dump process returned no errors.

##############################################################################################################################################################################################################################################################################################

2022-12-06 00:26:45.23 Server Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64)
Oct 8 2022 05:58:25
Copyright (C) 2022 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 22000: ) (Hypervisor)

2022-12-06 00:26:45.23 Server UTC adjustment: -6:00
2022-12-06 00:26:45.23 Server (c) Microsoft Corporation.
2022-12-06 00:26:45.23 Server All rights reserved.
2022-12-06 00:26:45.23 Server Server process ID is 6184.
2022-12-06 00:26:45.23 Server System Manufacturer: 'LENOVO', System Model: '82JN'.
2022-12-06 00:26:45.23 Server Authentication mode is WINDOWS-ONLY.
2022-12-06 00:26:45.23 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2022-12-06 00:26:45.23 Server The service account is 'NT Service\MSSQL$SQLEXPRESS'. This is an informational message; no user action is required.
2022-12-06 00:26:45.23 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
2022-12-06 00:26:45.23 Server Command Line Startup Parameters:
-s "SQLEXPRESS"
-m "SqlSetup"
-Q
-q "SQL_Latin1_General_CP1_CI_AS"
-T 4022
-T 4010
-T 3659
-T 3610
-T 8015
-d "C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Template Data\master.mdf"
-l "C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Template Data\mastlog.ldf"
2022-12-06 00:26:45.23 Server SQL Server detected 1 sockets with 8 cores per socket and 16 logical processors per socket, 16 total logical processors; using 8 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2022-12-06 00:26:45.23 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2022-12-06 00:26:45.23 Server Detected 16167 MB of RAM. This is an informational message; no user action is required.
2022-12-06 00:26:45.23 Server Using conventional memory in the memory manager.
2022-12-06 00:26:45.23 Server Detected pause instruction latency: 94 cycles.
2022-12-06 00:26:45.23 Server Spin divider value used: 2
2022-12-06 00:26:45.23 Server Page exclusion bitmap is enabled.
2022-12-06 00:26:45.33 Server Buffer Pool: Allocating 4194304 bytes for 2539520 hashPages.
2022-12-06 00:26:45.34 Server Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2022-12-06 00:26:45.35 Server Buffer pool extension is already disabled. No action is necessary.
2022-12-06 00:26:45.37 Server CPU vectorization level(s) detected: SSE SSE2 SSE3 SSSE3 SSE41 SSE42 AVX AVX2 POPCNT BMI1 BMI2 AVX512 (F CD BW DQ VL IFMA VBMI VBMI2 VNNI BITALG VPOQCNTDQ VP2INTERSECT)
2022-12-06 00:26:45.38 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2022-12-06 00:26:45.39 Server Query Store settings initialized with enabled = 1,
2022-12-06 00:26:45.39 Server The maximum number of dedicated administrator connections for this instance is '1'
2022-12-06 00:26:45.39 Server This instance of SQL Server last reported using a process ID of 22392 at 12/6/2022 12:26:44 AM (local) 12/6/2022 6:26:44 AM (UTC). This is an informational message only; no user action is required.
2022-12-06 00:26:45.40 Server Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2022-12-06 00:26:45.41 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2022-12-06 00:26:45.41 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
2022-12-06 00:26:45.41 Server In-Memory OLTP initialized on standard machine.
2022-12-06 00:26:45.42 Server [INFO] Created Extended Events session 'hkenginexesession'
2022-12-06 00:26:45.42 Server Database Instant File Initialization: enabled. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
2022-12-06 00:26:45.42 Server Total Log Writer threads: 2, Node CPUs: 4, Nodes: 1, Log Writer threads per CPU: 1, Log Writer threads per Node: 2
2022-12-06 00:26:45.43 Server Database Mirroring Transport is disabled in the endpoint configuration.
2022-12-06 00:26:45.43 Server clwb is selected for pmem flush operation.
2022-12-06 00:26:45.43 Server Software Usage Metrics is disabled.
2022-12-06 00:26:45.43 spid26s Warning ******************
2022-12-06 00:26:45.43 spid26s SQL Server started in single-user mode. This an informational message only. No user action is required.
2022-12-06 00:26:45.43 spid26s Starting up database 'master'.
2022-12-06 00:26:45.44 spid26s There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Template Data\master.mdf.
2022-12-06 00:26:45.44 spid26s 12/06/22 00:26:45 Stack Overflow Dump not possible - Exception c00000fd EXCEPTION_STACK_OVERFLOW at 0x00007FF89F6CF009
2022-12-06 00:26:45.44 spid26s SqlDumpExceptionHandler: Address=0x00007FF89F6CF009 Exception Code = c00000fd
2022-12-06 00:26:45.44 spid26s Rax=0000000000001118 Rbx=000000009d4a4180 Rcx=00000000a7882040 Rdx=00000000a9141000
2022-12-06 00:26:45.44 spid26s Rsi=00000000a9141000 Rdi=0000000000008000 Rip=000000009f6cf009 Rsp=00000000fc212f30
2022-12-06 00:26:45.44 spid26s Rbp=00000000fc211f30 EFlags=0000000000010206
2022-12-06 00:26:45.44 spid26s cs=0000000000000033 ss=000000000000002b ds=000000000000002b
es=000000000000002b fs=0000000000000053 gs=000000000000002b
2022-12-06 00:26:45.53 Server CLR version v4.0.30319 loaded.
2022-12-06 00:26:45.53 spid26s Frame 0: 0x00007FF89CA45F16
2022-12-06 00:26:45.53 spid26s Frame 1: 0x00007FF89D97D6B6
2022-12-06 00:26:45.53 spid26s Frame 2: 0x00007FF89CA458A0
2022-12-06 00:26:45.53 spid26s Frame 3: 0x00007FF8F7B29C16
2022-12-06 00:26:45.53 spid26s Frame 4: 0x00007FF8F7AC4BDC
2022-12-06 00:26:45.53 spid26s Frame 5: 0x00007FF8F7AC4E5B
2022-12-06 00:26:45.53 spid26s Frame 6: 0x00007FF94C78F155
2022-12-06 00:26:45.53 spid26s Frame 7: 0x00007FF94C783950
2022-12-06 00:26:45.53 spid26s Frame 8: 0x00007FF94C783368
2022-12-06 00:26:45.53 spid26s Frame 9: 0x00007FF94C784248
2022-12-06 00:26:45.53 spid26s Frame 10: 0x00007FF94C78FD11
2022-12-06 00:26:45.53 spid26s Frame 11: 0x00007FF9708E8B1F
2022-12-06 00:26:45.53 spid26s Frame 12: 0x00007FF970875B9A
2022-12-06 00:26:45.53 spid26s Frame 13: 0x00007FF9708E7B2E
2022-12-06 00:26:45.53 spid26s Frame 14: 0x00007FF89F6CF009
2022-12-06 00:26:45.53 spid26s Frame 15: 0x00007FF8A086A79F
2022-12-06 00:26:45.53 spid26s
2022-12-06 00:26:45.53 spid26s TotalPhysicalMemory = 16952647680, AvailablePhysicalMemory = 7398719488
2022-12-06 00:26:45.53 spid26s AvailableVirtualMemory = 140700103696384, AvailablePagingFile = 18477596672
2022-12-06 00:26:45.53 spid26s Stack Signature for the dump is 0x0000000179C38DE2
2022-12-06 00:26:45.57 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319.
2022-12-06 00:26:46.21 spid26s External dump process return code 0x20000001.
External dump process returned no errors.
2022-12-06 00:26:46.23 spid26s Unable to create stack dump file due to stack shortage (ex_terminator - Last chance exception handling)
2022-12-06 00:26:46.23 spid26s Stack Signature for the dump is 0x0000000000000000
2022-12-06 00:26:46.23 spid26s CDmpClient::ExecuteAllCallbacks started.
2022-12-06 00:26:46.23 spid26s XE_DumpCallbacks is executing...
2022-12-06 00:26:46.24 spid26s DumpCallbackSOS is executing...
2022-12-06 00:26:46.24 spid26s DumpCallbackEE is executing...
2022-12-06 00:26:46.24 spid26s DumpCallbackSE is executing...
2022-12-06 00:26:46.24 spid26s DumpCallbackSEAM is executing...
2022-12-06 00:26:46.24 spid26s DumpCallbackSSB is executing...
2022-12-06 00:26:46.26 spid26s DumpCallbackQE is executing...
2022-12-06 00:26:46.26 spid26s DumpCallbackFullText is executing...
2022-12-06 00:26:46.26 spid26s DumpCallbackSQLCLR is executing...
2022-12-06 00:26:46.26 spid26s DumpCallbackHk is executing...
2022-12-06 00:26:46.26 spid26s DumpCallbackRepl is executing...
2022-12-06 00:26:46.26 spid26s DumpCallbackPolyBase is executing...
2022-12-06 00:26:46.26 spid26s CDmpClient::ExecuteAllCallbacks completed. Time elapsed: 0 seconds.
2022-12-06 00:26:46.99 spid26s External dump process return code 0x20000001.
External dump process returned no errors.

------------------------------------------------------------------------------------------------------------------------------------------

2022-12-06 00:26:45.23 Server Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64)
Oct 8 2022 05:58:25
Copyright (C) 2022 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 22000: ) (Hypervisor)

2022-12-06 00:26:45.23 Server UTC adjustment: -6:00
2022-12-06 00:26:45.23 Server (c) Microsoft Corporation.
2022-12-06 00:26:45.23 Server All rights reserved.
2022-12-06 00:26:45.23 Server Server process ID is 6184.
2022-12-06 00:26:45.23 Server System Manufacturer: 'LENOVO', System Model: '82JN'.
2022-12-06 00:26:45.23 Server Authentication mode is WINDOWS-ONLY.
2022-12-06 00:26:45.23 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2022-12-06 00:26:45.23 Server The service account is 'NT Service\MSSQL$SQLEXPRESS'. This is an informational message; no user action is required.
2022-12-06 00:26:45.23 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
2022-12-06 00:26:45.23 Server Command Line Startup Parameters:
-s "SQLEXPRESS"
-m "SqlSetup"
-Q
-q "SQL_Latin1_General_CP1_CI_AS"
-T 4022
-T 4010
-T 3659
-T 3610
-T 8015
-d "C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Template Data\master.mdf"
-l "C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Template Data\mastlog.ldf"
2022-12-06 00:26:45.23 Server SQL Server detected 1 sockets with 8 cores per socket and 16 logical processors per socket, 16 total logical processors; using 8 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2022-12-06 00:26:45.23 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2022-12-06 00:26:45.23 Server Detected 16167 MB of RAM. This is an informational message; no user action is required.
2022-12-06 00:26:45.23 Server Using conventional memory in the memory manager.
2022-12-06 00:26:45.23 Server Detected pause instruction latency: 94 cycles.
2022-12-06 00:26:45.23 Server Spin divider value used: 2
2022-12-06 00:26:45.23 Server Page exclusion bitmap is enabled.
2022-12-06 00:26:45.33 Server Buffer Pool: Allocating 4194304 bytes for 2539520 hashPages.
2022-12-06 00:26:45.34 Server Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2022-12-06 00:26:45.35 Server Buffer pool extension is already disabled. No action is necessary.
2022-12-06 00:26:45.37 Server CPU vectorization level(s) detected: SSE SSE2 SSE3 SSSE3 SSE41 SSE42 AVX AVX2 POPCNT BMI1 BMI2 AVX512 (F CD BW DQ VL IFMA VBMI VBMI2 VNNI BITALG VPOQCNTDQ VP2INTERSECT)
2022-12-06 00:26:45.38 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2022-12-06 00:26:45.39 Server Query Store settings initialized with enabled = 1,
2022-12-06 00:26:45.39 Server The maximum number of dedicated administrator connections for this instance is '1'
2022-12-06 00:26:45.39 Server This instance of SQL Server last reported using a process ID of 22392 at 12/6/2022 12:26:44 AM (local) 12/6/2022 6:26:44 AM (UTC). This is an informational message only; no user action is required.
2022-12-06 00:26:45.40 Server Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2022-12-06 00:26:45.41 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2022-12-06 00:26:45.41 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
2022-12-06 00:26:45.41 Server In-Memory OLTP initialized on standard machine.
2022-12-06 00:26:45.42 Server [INFO] Created Extended Events session 'hkenginexesession'
2022-12-06 00:26:45.42 Server Database Instant File Initialization: enabled. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
2022-12-06 00:26:45.42 Server Total Log Writer threads: 2, Node CPUs: 4, Nodes: 1, Log Writer threads per CPU: 1, Log Writer threads per Node: 2
2022-12-06 00:26:45.43 Server Database Mirroring Transport is disabled in the endpoint configuration.
2022-12-06 00:26:45.43 Server clwb is selected for pmem flush operation.
2022-12-06 00:26:45.43 Server Software Usage Metrics is disabled.
2022-12-06 00:26:45.43 spid26s Warning ******************
2022-12-06 00:26:45.43 spid26s SQL Server started in single-user mode. This an informational message only. No user action is required.
2022-12-06 00:26:45.43 spid26s Starting up database 'master'.
2022-12-06 00:26:45.44 spid26s There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Template Data\master.mdf.
2022-12-06 00:26:45.44 spid26s 12/06/22 00:26:45 Stack Overflow Dump not possible - Exception c00000fd EXCEPTION_STACK_OVERFLOW at 0x00007FF89F6CF009
2022-12-06 00:26:45.44 spid26s SqlDumpExceptionHandler: Address=0x00007FF89F6CF009 Exception Code = c00000fd
2022-12-06 00:26:45.44 spid26s Rax=0000000000001118 Rbx=000000009d4a4180 Rcx=00000000a7882040 Rdx=00000000a9141000
2022-12-06 00:26:45.44 spid26s Rsi=00000000a9141000 Rdi=0000000000008000 Rip=000000009f6cf009 Rsp=00000000fc212f30
2022-12-06 00:26:45.44 spid26s Rbp=00000000fc211f30 EFlags=0000000000010206
2022-12-06 00:26:45.44 spid26s cs=0000000000000033 ss=000000000000002b ds=000000000000002b
es=000000000000002b fs=0000000000000053 gs=000000000000002b
2022-12-06 00:26:45.53 Server CLR version v4.0.30319 loaded.
2022-12-06 00:26:45.53 spid26s Frame 0: 0x00007FF89CA45F16
2022-12-06 00:26:45.53 spid26s Frame 1: 0x00007FF89D97D6B6
2022-12-06 00:26:45.53 spid26s Frame 2: 0x00007FF89CA458A0
2022-12-06 00:26:45.53 spid26s Frame 3: 0x00007FF8F7B29C16
2022-12-06 00:26:45.53 spid26s Frame 4: 0x00007FF8F7AC4BDC
2022-12-06 00:26:45.53 spid26s Frame 5: 0x00007FF8F7AC4E5B
2022-12-06 00:26:45.53 spid26s Frame 6: 0x00007FF94C78F155
2022-12-06 00:26:45.53 spid26s Frame 7: 0x00007FF94C783950
2022-12-06 00:26:45.53 spid26s Frame 8: 0x00007FF94C783368
2022-12-06 00:26:45.53 spid26s Frame 9: 0x00007FF94C784248
2022-12-06 00:26:45.53 spid26s Frame 10: 0x00007FF94C78FD11
2022-12-06 00:26:45.53 spid26s Frame 11: 0x00007FF9708E8B1F
2022-12-06 00:26:45.53 spid26s Frame 12: 0x00007FF970875B9A
2022-12-06 00:26:45.53 spid26s Frame 13: 0x00007FF9708E7B2E
2022-12-06 00:26:45.53 spid26s Frame 14: 0x00007FF89F6CF009
2022-12-06 00:26:45.53 spid26s Frame 15: 0x00007FF8A086A79F
2022-12-06 00:26:45.53 spid26s
2022-12-06 00:26:45.53 spid26s TotalPhysicalMemory = 16952647680, AvailablePhysicalMemory = 7398719488
2022-12-06 00:26:45.53 spid26s AvailableVirtualMemory = 140700103696384, AvailablePagingFile = 18477596672
2022-12-06 00:26:45.53 spid26s Stack Signature for the dump is 0x0000000179C38DE2
2022-12-06 00:26:45.57 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319.
2022-12-06 00:26:46.21 spid26s External dump process return code 0x20000001.
External dump process returned no errors.
2022-12-06 00:26:46.23 spid26s Unable to create stack dump file due to stack shortage (ex_terminator - Last chance exception handling)
2022-12-06 00:26:46.23 spid26s Stack Signature for the dump is 0x0000000000000000
2022-12-06 00:26:46.23 spid26s CDmpClient::ExecuteAllCallbacks started.
2022-12-06 00:26:46.23 spid26s XE_DumpCallbacks is executing...
2022-12-06 00:26:46.24 spid26s DumpCallbackSOS is executing...
2022-12-06 00:26:46.24 spid26s DumpCallbackEE is executing...
2022-12-06 00:26:46.24 spid26s DumpCallbackSE is executing...
2022-12-06 00:26:46.24 spid26s DumpCallbackSEAM is executing...
2022-12-06 00:26:46.24 spid26s DumpCallbackSSB is executing...
2022-12-06 00:26:46.26 spid26s DumpCallbackQE is executing...
2022-12-06 00:26:46.26 spid26s DumpCallbackFullText is executing...
2022-12-06 00:26:46.26 spid26s DumpCallbackSQLCLR is executing...
2022-12-06 00:26:46.26 spid26s DumpCallbackHk is executing...
2022-12-06 00:26:46.26 spid26s DumpCallbackRepl is executing...
2022-12-06 00:26:46.26 spid26s DumpCallbackPolyBase is executing...
2022-12-06 00:26:46.26 spid26s CDmpClient::ExecuteAllCallbacks completed. Time elapsed: 0 seconds.
2022-12-06 00:26:46.99 spid26s External dump process return code 0x20000001.
External dump process returned no errors.

##############################################################################################################################################################################################################################################################################################

2022-12-06 00:26:47.21 Server Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64)
Oct 8 2022 05:58:25
Copyright (C) 2022 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 22000: ) (Hypervisor)

2022-12-06 00:26:47.21 Server UTC adjustment: -6:00
2022-12-06 00:26:47.21 Server (c) Microsoft Corporation.
2022-12-06 00:26:47.21 Server All rights reserved.
2022-12-06 00:26:47.21 Server Server process ID is 30100.
2022-12-06 00:26:47.21 Server System Manufacturer: 'LENOVO', System Model: '82JN'.
2022-12-06 00:26:47.21 Server Authentication mode is WINDOWS-ONLY.
2022-12-06 00:26:47.21 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2022-12-06 00:26:47.21 Server The service account is 'NT Service\MSSQL$SQLEXPRESS'. This is an informational message; no user action is required.
2022-12-06 00:26:47.21 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
2022-12-06 00:26:47.21 Server Command Line Startup Parameters:
-s "SQLEXPRESS"
-m "SqlSetup"
-Q
-q "SQL_Latin1_General_CP1_CI_AS"
-T 4022
-T 4010
-T 3659
-T 3610
-T 8015
-d "C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Template Data\master.mdf"
-l "C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Template Data\mastlog.ldf"
2022-12-06 00:26:47.21 Server SQL Server detected 1 sockets with 8 cores per socket and 16 logical processors per socket, 16 total logical processors; using 8 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2022-12-06 00:26:47.21 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2022-12-06 00:26:47.21 Server Detected 16167 MB of RAM. This is an informational message; no user action is required.
2022-12-06 00:26:47.21 Server Using conventional memory in the memory manager.
2022-12-06 00:26:47.21 Server Detected pause instruction latency: 90 cycles.
2022-12-06 00:26:47.21 Server Spin divider value used: 2
2022-12-06 00:26:47.21 Server Page exclusion bitmap is enabled.
2022-12-06 00:26:47.31 Server Buffer Pool: Allocating 4194304 bytes for 2539520 hashPages.
2022-12-06 00:26:47.33 Server Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2022-12-06 00:26:47.34 Server Buffer pool extension is already disabled. No action is necessary.
2022-12-06 00:26:47.36 Server CPU vectorization level(s) detected: SSE SSE2 SSE3 SSSE3 SSE41 SSE42 AVX AVX2 POPCNT BMI1 BMI2 AVX512 (F CD BW DQ VL IFMA VBMI VBMI2 VNNI BITALG VPOQCNTDQ VP2INTERSECT)
2022-12-06 00:26:47.37 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2022-12-06 00:26:47.38 Server Query Store settings initialized with enabled = 1,
2022-12-06 00:26:47.38 Server The maximum number of dedicated administrator connections for this instance is '1'
2022-12-06 00:26:47.38 Server This instance of SQL Server last reported using a process ID of 6184 at 12/6/2022 12:26:45 AM (local) 12/6/2022 6:26:45 AM (UTC). This is an informational message only; no user action is required.
2022-12-06 00:26:47.39 Server Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2022-12-06 00:26:47.39 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2022-12-06 00:26:47.39 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
2022-12-06 00:26:47.40 Server In-Memory OLTP initialized on standard machine.
2022-12-06 00:26:47.41 Server [INFO] Created Extended Events session 'hkenginexesession'

Answer 1

Any update on this? This problem wasted me 10+ hours. It is really disappointing to see that all the products involved in this problem belong to Microsoft and we still have no viable solutions. I cannot upgrade to Windows 11 just because of this error.

Answer 2

Hi @SergioHernandez-3805，

From your error information, it mentions

There have been 256 misaligned log IOs which required falling back to synchronous IO.

Please check out this article:
https://techcommunity.microsoft.com/t5/running-sap-applications-on-the/message-misaligned-log-ios-which-required-falling-back-to/ba-p/367796

SQL Server storage engine logic detects the disk Sector Size and will align the Transaction Log Files metadata and internal boundaries to match the Sector Size (either 512 or 4096 bytes). The error message 9012 is generated when SQL Server has detected that Log Entries have been written assuming a Sector Size different to the Sector Size found on the current SQL Server instance

You need to fix mismatched physical sector settings for SQL Server, a simple way is to enable SQL Server trace flag 1800

Please open your SQL Server configuration Manager, choose SQL Server service and select the instance

add "-T1800" as a Start up parameter

https://www.mssqltips.com/sqlservertip/5942/sql-server-misaligned-log-ios-which-required-falling-back-to-synchronous-io/

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hi @SergioHernandez-3805

it looks like the actual problem when installing SQL Server on a Windows 11 machine.

Windows 11 handles disk block sizes different (if it is an upgrade or new installation), it changes the block size to 32k which is not supported by SQL Server.
You have two options:

1.) Change block size to a support value => e.g. 4k
or
2.) try to run your SQL Server engine with traceflag 1800

It looks like you already tried to change the blocksize to 4095, but it looks like a not 100% correct cmdline (maybe due to copy and paste and the editor)

Try again it is "* 4095" and not just " 4095"

Otherwise try the traceflag 1800
https://learn.microsoft.com/en-us/troubleshoot/sql/admin/troubleshoot-os-4kb-disk-sector-size

Hope that helps