here have been 256 misaligned log IOs which required falling
A known issue in combination of Win 11, some SSD as storage and SQL Server, see
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
2023-05-04 00:51:24.81 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 22621: )
2023-05-04 00:51:24.81 Server UTC adjustment: -7:00
2023-05-04 00:51:24.81 Server (c) Microsoft Corporation.
2023-05-04 00:51:24.81 Server All rights reserved.
2023-05-04 00:51:24.81 Server Server process ID is 11800.
2023-05-04 00:51:24.81 Server System Manufacturer: 'Micro-Star International Co., Ltd.', System Model: 'MS-7C56'.
2023-05-04 00:51:24.81 Server Authentication mode is WINDOWS-ONLY.
2023-05-04 00:51:24.81 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS03\MSSQL\Log\ERRORLOG'.
2023-05-04 00:51:24.81 Server The service account is 'NT Service\MSSQL$SQLEXPRESS03'. This is an informational message; no user action is required.
2023-05-04 00:51:24.81 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS03\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS03\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS03\MSSQL\DATA\mastlog.ldf
2023-05-04 00:51:24.81 Server Command Line Startup Parameters:
-s "SQLEXPRESS03"
-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.SQLEXPRESS03\MSSQL\Template Data\master.mdf"
-l "C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS03\MSSQL\Template Data\mastlog.ldf"
2023-05-04 00:51:24.82 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.
2023-05-04 00:51:24.82 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2023-05-04 00:51:24.82 Server Detected 16310 MB of RAM. This is an informational message; no user action is required.
2023-05-04 00:51:24.82 Server Using conventional memory in the memory manager.
2023-05-04 00:51:24.82 Server Detected pause instruction latency: 34 cycles.
2023-05-04 00:51:24.82 Server Page exclusion bitmap is enabled.
2023-05-04 00:51:24.88 Server Buffer Pool: Allocating 4194304 bytes for 2560000 hashPages.
2023-05-04 00:51:24.88 Server Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2023-05-04 00:51:24.90 Server Buffer pool extension is already disabled. No action is necessary.
2023-05-04 00:51:24.94 Server CPU vectorization level(s) detected: SSE SSE2 SSE3 SSSE3 SSE41 SSE42 AVX AVX2 POPCNT BMI1 BMI2
2023-05-04 00:51:24.95 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2023-05-04 00:51:24.97 Server Query Store settings initialized with enabled = 1,
2023-05-04 00:51:24.98 Server The maximum number of dedicated administrator connections for this instance is '1'
2023-05-04 00:51:24.98 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.
2023-05-04 00:51:24.98 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.
2023-05-04 00:51:24.98 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
2023-05-04 00:51:24.99 Server In-Memory OLTP initialized on standard machine.
2023-05-04 00:51:24.99 Server [INFO] Created Extended Events session 'hkenginexesession'
2023-05-04 00:51:24.99 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.
2023-05-04 00:51:25.00 Server Total Log Writer threads: 2, Node CPUs: 4, Nodes: 1, Log Writer threads per CPU: 1, Log Writer threads per Node: 2
2023-05-04 00:51:25.00 Server Database Mirroring Transport is disabled in the endpoint configuration.
2023-05-04 00:51:25.00 Server clwb is selected for pmem flush operation.
2023-05-04 00:51:25.00 Server Software Usage Metrics is disabled.
2023-05-04 00:51:25.00 spid23s Warning ******************
2023-05-04 00:51:25.00 spid23s SQL Server started in single-user mode. This an informational message only. No user action is required.
2023-05-04 00:51:25.01 spid23s Starting up database 'master'.
2023-05-04 00:51:25.01 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.SQLEXPRESS03\MSSQL\Template Data\master.mdf.
2023-05-04 00:51:25.02 spid23s 05/04/23 00:51:25 Stack Overflow Dump not possible - Exception c00000fd EXCEPTION_STACK_OVERFLOW at 0x00007FFF0E73A386
2023-05-04 00:51:25.02 spid23s SqlDumpExceptionHandler: Address=0x00007FFF0E73A386 Exception Code = c00000fd
2023-05-04 00:51:25.02 spid23s Rax=00000000108fffd8 Rbx=0000000000000000 Rcx=00000000c1804040 Rdx=00000000c2499000
2023-05-04 00:51:25.02 spid23s Rsi=00000000c1804040 Rdi=0000000000004000 Rip=000000000e73a386 Rsp=0000000062a11f70
2023-05-04 00:51:25.02 spid23s Rbp=0000000062a12190 EFlags=0000000000010202
2023-05-04 00:51:25.02 spid23s cs=0000000000000033 ss=000000000000002b ds=000000000000002b
es=000000000000002b fs=0000000000000053 gs=000000000000002b
2023-05-04 00:51:25.09 Server CLR version v4.0.30319 loaded.
2023-05-04 00:51:25.11 spid23s Frame 0: 0x00007FFF0BAE5F16
2023-05-04 00:51:25.11 spid23s Frame 1: 0x00007FFF0CA1D6B6
2023-05-04 00:51:25.11 spid23s Frame 2: 0x00007FFF0BAE58A0
2023-05-04 00:51:25.11 spid23s Frame 3: 0x00007FFF13A59C16
2023-05-04 00:51:25.11 spid23s Frame 4: 0x00007FFF139F4BDC
2023-05-04 00:51:25.11 spid23s Frame 5: 0x00007FFF139F4E5B
2023-05-04 00:51:25.11 spid23s Frame 6: 0x00007FFFC074F285
2023-05-04 00:51:25.11 spid23s Frame 7: 0x00007FFFC0743970
2023-05-04 00:51:25.11 spid23s Frame 8: 0x00007FFFC0743388
2023-05-04 00:51:25.11 spid23s Frame 9: 0x00007FFFC0744268
2023-05-04 00:51:25.11 spid23s Frame 10: 0x00007FFFC074FE41
2023-05-04 00:51:25.11 spid23s Frame 11: 0x00007FFFD4FB3CFF
2023-05-04 00:51:25.11 spid23s Frame 12: 0x00007FFFD4F2E456
2023-05-04 00:51:25.11 spid23s Frame 13: 0x00007FFFD4FB2CEE
2023-05-04 00:51:25.11 spid23s Frame 14: 0x00007FFF0E73A386
2023-05-04 00:51:25.11 spid23s Frame 15: 0x00007FFF0F90A898
2023-05-04 00:51:25.11 spid23s
2023-05-04 00:51:25.11 spid23s TotalPhysicalMemory = 17102372864, AvailablePhysicalMemory = 8132927488
2023-05-04 00:51:25.11 spid23s AvailableVirtualMemory = 140699920330752, AvailablePagingFile = 43161690112
2023-05-04 00:51:25.11 spid23s Stack Signature for the dump is 0x000000013236016E
2023-05-04 00:51:25.13 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
2023-05-04 00:51:25.65 spid23s External dump process return code 0x20000001.
External dump process returned no errors.
2023-05-04 00:51:25.67 spid23s Unable to create stack dump file due to stack shortage (ex_terminator - Last chance exception handling)
2023-05-04 00:51:25.67 spid23s Stack Signature for the dump is 0x0000000000000000
2023-05-04 00:51:25.67 spid23s CDmpClient::ExecuteAllCallbacks started.
2023-05-04 00:51:25.67 spid23s XE_DumpCallbacks is executing...
2023-05-04 00:51:25.68 spid23s DumpCallbackSOS is executing...
2023-05-04 00:51:25.68 spid23s DumpCallbackEE is executing...
2023-05-04 00:51:25.68 spid23s DumpCallbackSE is executing...
2023-05-04 00:51:25.68 spid23s DumpCallbackSEAM is executing...
2023-05-04 00:51:25.68 spid23s DumpCallbackSSB is executing...
2023-05-04 00:51:25.70 spid23s DumpCallbackQE is executing...
2023-05-04 00:51:25.70 spid23s DumpCallbackFullText is executing...
2023-05-04 00:51:25.70 spid23s DumpCallbackSQLCLR is executing...
2023-05-04 00:51:25.70 spid23s DumpCallbackHk is executing...
2023-05-04 00:51:25.70 spid23s DumpCallbackRepl is executing...
2023-05-04 00:51:25.70 spid23s DumpCallbackPolyBase is executing...
2023-05-04 00:51:25.70 spid23s CDmpClient::ExecuteAllCallbacks completed. Time elapsed: 0 seconds.
2023-05-04 00:51:26.28 spid23s External dump process return code 0x20000001.
External dump process returned no errors.
here have been 256 misaligned log IOs which required falling
A known issue in combination of Win 11, some SSD as storage and SQL Server, see
As Olaf answered, it is a known issue when install on windows 11. Windows 11 uses different block sizes for disc alignment (32k) which aren't supported by SQL Server.
Please troubleshoot follow by this tech document: Troubleshoot errors related to system disk sector size greater than 4 KB.
Best regards,
Cosmog Hong
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.