level 1
ERROR LOG如下
2021-05-19 10:43:27.53 Server Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)
Sep 24 2019 13:48:23
Copyright (C) 2019 Microsoft Corporation
Enterprise Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19043: ) (Hypervisor)
2021-05-19 10:43:27.53 Server UTC adjustment: 8:00
2021-05-19 10:43:27.53 Server (c) Microsoft Corporation.
2021-05-19 10:43:27.53 Server All rights reserved.
2021-05-19 10:43:27.54 Server Server process ID is 7084.
2021-05-19 10:43:27.54 Server System Manufacturer: 'LENOVO', System Model: '82B6'.
2021-05-19 10:43:27.54 Server Authentication mode is MIXED.
2021-05-19 10:43:27.54 Server Logging SQL Server messages in file 'D:\Program Files\SQL2019\MSSQL15.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2021-05-19 10:43:27.54 Server The service account is 'WORKGROUP\LAPTOP-IUEDPU41$'. This is an informational message; no user action is required.
2021-05-19 10:43:27.54 Server Registry startup parameters:
-d D:\Program Files\SQL2019\MSSQL15.MSSQLSERVER\MSSQL\DATA\master.mdf
-e D:\Program Files\SQL2019\MSSQL15.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l D:\Program Files\SQL2019\MSSQL15.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2021-05-19 10:43:27.54 Server Command Line Startup Parameters:
-s "MSSQLSERVER"
2021-05-19 10:43:27.54 Server SQL Server detected 1 sockets with 8 cores per socket and 16 logical processors per socket, 16 total logical processors; using 16 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2021-05-19 10:43:27.54 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2021-05-19 10:43:27.54 Server Detected 15741 MB of RAM. This is an informational message; no user action is required.
2021-05-19 10:43:27.54 Server Using locked pages in the memory manager.
2021-05-19 10:43:27.54 Server Page exclusion bitmap is enabled.
2021-05-19 10:43:27.69 Server Buffer Pool: Allocating 4194304 bytes for 2518610 hashPages.
2021-05-19 10:43:27.72 Server Default collation: Chinese_PRC_CI_AS (简体中文 2052)
2021-05-19 10:43:27.77 Server Buffer pool extension is already disabled. No action is necessary.
2021-05-19 10:43:27.87 Server Query Store settings initialized with enabled = 1,
2021-05-19 10:43:27.88 Server The maximum number of dedicated administrator connections for this instance is '1'
2021-05-19 10:43:27.88 Server This instance of SQL Server last reported using a process ID of 19664 at 2021/5/19 10:38:28 (local) 2021/5/19 2:38:28 (UTC). This is an informational message only; no user action is required.
2021-05-19 10:43:27.89 Server Node configuration: node 0: CPU mask: 0x000000000000ffff:0 Active CPU mask: 0x000000000000ffff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2021-05-19 10:43:27.89 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.
2021-05-19 10:43:27.89 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
2021-05-19 10:43:27.90 Server In-Memory OLTP initialized on standard machine.
2021-05-19 10:43:27.93 Server [INFO] Created Extended Events session 'hkenginexesession'
2021-05-19 10:43:27.94 Server Database Instant File Initialization: 已启用. 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.
2021-05-19 10:43:27.94 Server Total Log Writer threads: 2. This is an informational message; no user action is required.
2021-05-19 10:43:27.95 Server clwb is selected for pmem flush operation.
2021-05-19 10:43:27.96 Server Software Usage Metrics is disabled.
2021-05-19 10:43:27.96 spid10s Starting up database 'master'.
2021-05-19 10:43:28.02 spid10s 69 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
2021-05-19 10:43:28.02 Server CLR version v4.0.30319 loaded.
2021-05-19 10:43:28.02 spid10s 0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
2021-05-19 10:43:28.13 spid10s Resource governor reconfiguration succeeded.
2021-05-19 10:43:28.13 spid10s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2021-05-19 10:43:28.13 spid10s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2021-05-19 10:43:28.13 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
2021-05-19 10:43:28.15 spid10s SQL Trace ID 1 was started by login "sa".
2021-05-19 10:43:28.15 spid10s Server name is 'LAPTOP-IUEDPU41'. This is an informational message only. No user action is required.
2021-05-19 10:43:28.17 spid21s The certificate [Cert Hash(sha1) "5C9E15CDE0E2B9CFB9D8BA2E17B318B37E93220A"] was successfully loaded for encryption.
2021-05-19 10:43:28.17 spid21s Error: 26023, Severity: 16, State: 1.
2021-05-19 10:43:28.17 spid21s Server TCP provider failed to listen on [ 'any' <ipv6> 1437]. Tcp port is already in use.
2021-05-19 10:43:28.17 spid21s Error: 17182, Severity: 16, State: 1.
2021-05-19 10:43:28.17 spid21s TDSSNIClient initialization failed with error 0x271d, status code 0xa. Reason: Unable to initialize the TCP/IP listener. An attempt was made to access a socket in a way forbidden by its access permissions.
2021-05-19 10:43:28.18 spid21s Error: 17182, Severity: 16, State: 1.
2021-05-19 10:43:28.18 spid21s TDSSNIClient initialization failed with error 0x271d, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. An attempt was made to access a socket in a way forbidden by its access permissions.
2021-05-19 10:43:28.18 spid21s Server is listening on [ ::1 <ipv6> 5049].
2021-05-19 10:43:28.18 spid21s Server is listening on [ 127.0.0.1 <ipv4> 5049].
2021-05-19 10:43:28.18 spid21s Server local connection provider is ready to accept connection on [ \\.\pipe\sqlsatellitelaunch ].
2021-05-19 10:43:28.18 spid21s Resource governor reconfiguration encountered an issue (HRESULT code : 0x80040002, reason: Construction of Launchpad Connection failed), while sending active external resource pool ids to launchpad. This will not fail reconfigure.
2021-05-19 10:43:28.18 spid21s Error: 17826, Severity: 18, State: 3.
2021-05-19 10:43:28.18 spid21s Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2021-05-19 10:43:28.18 spid21s Error: 17120, Severity: 16, State: 1.
2021-05-19 10:43:28.18 spid21s SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the operating system error log for information about possible related problems.
2021年05月19日 02点05分