SQL Server 服务经常中止怎么办？

Question

由于出现异常 c0000005，SQL Server 正在终止。此错误可能是由未处理的 Win32 或 C++ 异常造成的，也可能是因在处理异常过程中遇到的访问冲突引起的。请查看 SQL 错误日志，获取任何相关的堆栈转储或消息。此异常会强制 SQL Server 关闭。若要从此错误中恢复，请重新启动服务器(除非已将 SQLAgent 配置为自动重新启动)。 日期,源,严重性,消息

05/06/2024 16:21:23,spid65,未知,Using 'dbghelp.dll' version '4.0.5'

05/06/2024 16:17:32,Server,未知,Software Usage Metrics is enabled.

05/06/2024 16:17:07,spid55,未知,Using 'xpstar.dll' version '2015.130.1601' to execute extended stored procedure 'xp_sqlagent_notify'. This is an informational message only; no user action is required.

05/06/2024 16:17:07,spid55,未知,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.

05/06/2024 16:17:07,spid55,未知,Using 'xpsqlbot.dll' version '2015.130.1601' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.

05/06/2024 16:17:07,spid55,未知,Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.

05/06/2024 16:17:03,spid5s,未知,Recovery is complete. This is an informational message only. No user action is required.

05/06/2024 16:17:03,spid15s,未知,CHECKDB for database 'Gwms' finished without errors on 2013-12-19 12:24:06.643 (local time). This is an informational message only; no user action is required.

05/06/2024 16:17:03,spid16s,未知,Service Broker manager has started.

05/06/2024 16:17:03,spid16s,未知,The Database Mirroring endpoint is in disabled or stopped state.

05/06/2024 16:17:03,spid16s,未知,The Service Broker endpoint is in disabled or stopped state.

05/06/2024 16:17:03,spid6s,未知,The tempdb database has 8 data file(s).

05/06/2024 16:17:02,spid5s,未知,0 transactions rolled back in database 'Gwms' (5:0). This is an informational message only. No user action is required.

05/06/2024 16:17:02,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [2] 'tempdb'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [2] 'tempdb'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid6s,未知,Starting up database 'tempdb'.

05/06/2024 16:17:02,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [2] 'tempdb'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid15s,未知,833 transactions rolled forward in database 'Gwms' (5:0). This is an informational message only. No user action is required.

05/06/2024 16:17:02,spid5s,未知,Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.

05/06/2024 16:17:02,spid5s,未知,0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.

05/06/2024 16:17:02,spid6s,未知,Clearing tempdb database.

05/06/2024 16:17:02,spid6s,未知,Polybase feature disabled.

05/06/2024 16:17:02,Server,未知,The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/iZt4yyra4m2u83Z:1389 ] for the SQL Server service. Windows return code: 0xffffffff<c/> state: 63. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.

05/06/2024 16:17:02,Server,未知,The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/iZt4yyra4m2u83Z ] for the SQL Server service. Windows return code: 0xffffffff<c/> state: 63. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.

05/06/2024 16:17:02,Server,未知,SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is registered for the SQL Server service. This is an informational message. No user action is required.

05/06/2024 16:17:02,spid11s,未知,SQL Server is now ready for client connections. This is an informational message; no user action is required.

05/06/2024 16:17:02,Server,未知,Dedicated admin connection support was established for listening locally on port 1434.

05/06/2024 16:17:02,Server,未知,Server is listening on [ 127.0.0.1 <ipv4> 1434].

05/06/2024 16:17:02,Server,未知,Server is listening on [ ::1 <ipv6> 1434].

05/06/2024 16:17:02,spid11s,未知,Server local connection provider is ready to accept connection on [ .\pipe\sql\query ].

05/06/2024 16:17:02,spid11s,未知,Server local connection provider is ready to accept connection on [ .\pipe\SQLLocal\MSSQLSERVER ].

05/06/2024 16:17:02,spid11s,未知,Server is listening on [ 'any' <ipv4> 1389].

05/06/2024 16:17:02,spid11s,未知,Server is listening on [ 'any' <ipv6> 1389].

05/06/2024 16:17:02,spid11s,未知,A self-generated certificate was successfully loaded for encryption.

05/06/2024 16:17:02,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [3] 'model'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [3] 'model'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid6s,未知,Starting up database 'model'.

05/06/2024 16:17:02,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [3] 'model'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid14s,未知,150 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.

05/06/2024 16:17:02,spid15s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [5] 'Gwms'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid14s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [4] 'msdb'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [32767] 'mssqlsystemresource'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid14s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [4] 'msdb'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid15s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [5] 'Gwms'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [32767] 'mssqlsystemresource'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid6s,未知,The resource database build version is 13.00.1601. This is an informational message only. No user action is required.

05/06/2024 16:17:02,spid14s,未知,Starting up database 'msdb'.

05/06/2024 16:17:02,spid15s,未知,Starting up database 'Gwms'.

05/06/2024 16:17:02,spid6s,未知,Starting up database 'mssqlsystemresource'.

05/06/2024 16:17:02,spid15s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [5] 'Gwms'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid14s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [4] 'msdb'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [32767] 'mssqlsystemresource'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid5s,未知,Server name is 'IZT4YYRA4M2U83Z'. This is an informational message only. No user action is required.

05/06/2024 16:17:02,spid5s,未知,SQL Trace ID 1 was started by login "sa".

05/06/2024 16:17:02,Server,未知,Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319.

05/06/2024 16:17:02,spid5s,未知,SQL Server Audit has started the audits. This is an informational message. No user action is required.

05/06/2024 16:17:02,spid5s,未知,SQL Server Audit is starting the audits. This is an informational message. No user action is required.

05/06/2024 16:17:02,spid5s,未知,Resource governor reconfiguration succeeded.

05/06/2024 16:17:02,spid5s,未知,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.

05/06/2024 16:17:02,spid5s,未知,0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.

05/06/2024 16:17:02,Server,未知,CLR version v4.0.30319 loaded.

05/06/2024 16:17:02,spid5s,未知,180 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.

05/06/2024 16:17:02,spid5s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [1] 'master'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid5s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [1] 'master'. XTP Engine version is 0.0.

05/06/2024 16:17:02,spid5s,未知,Starting up database 'master'.

05/06/2024 16:17:02,spid5s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [1] 'master'. XTP Engine version is 0.0.

05/06/2024 16:17:02,Server,未知,Query Store settings initialized with enabled = 1<c/>

05/06/2024 16:17:02,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.

05/06/2024 16:17:02,Server,未知,Lock partitioning is enabled. This is an informational message only. No user action is required.

05/06/2024 16:17:02,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.

05/06/2024 16:17:02,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.

05/06/2024 16:17:02,Server,未知,This instance of SQL Server last reported using a process ID of 4964 at 2024/5/6 15:53:50 (local) 2024/5/6 7:53:50 (UTC). This is an informational message only; no user action is required.

05/06/2024 16:17:02,Server,未知,The maximum number of dedicated administrator connections for this instance is '1'

05/06/2024 16:17:02,Server,未知,Implied authentication manager initialization failed. Implied authentication will be disabled.

05/06/2024 16:17:02,Server,未知,InitializeExternalUserGroupSid failed. Implied authentication will be disabled.

05/06/2024 16:17:02,Server,未知,Buffer pool extension is already disabled. No action is necessary.

05/06/2024 16:17:02,Server,未知,Default collation: Chinese_PRC_CI_AS (简体中文 2052)

05/06/2024 16:17:02,Server,未知,Using conventional memory in the memory manager.

05/06/2024 16:17:02,Server,未知,Detected 64494 MB of RAM. This is an informational message; no user action is required.

05/06/2024 16:17:02,Server,未知,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

05/06/2024 16:17:02,Server,未知,SQL Server detected 1 sockets with 8 cores per socket and 16 logical processors per socket<c/> 16 total logical processors; using 16 logical processors based on SQL Server licensing. This is an informational message; no user action is required.

05/06/2024 16:17:02,Server,未知,Command Line Startup Parameters:<nl/> -s "MSSQLSERVER"

05/06/2024 16:17:02,Server,未知,Registry startup parameters: <nl/> -d D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\master.mdf<nl/> -e D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG<nl/> -l D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\mastlog.ldf

05/06/2024 16:17:02,Server,未知,The service account is 'NT Service\MSSQLSERVER'. This is an informational message; no user action is required.

05/06/2024 16:17:02,Server,未知,Logging SQL Server messages in file 'D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG'.

05/06/2024 16:17:02,Server,未知,Authentication mode is MIXED.

05/06/2024 16:17:02,Server,未知,System Manufacturer: 'Alibaba Cloud'<c/> System Model: 'Alibaba Cloud ECS'.

05/06/2024 16:17:02,Server,未知,Server process ID is 6792.

05/06/2024 16:17:02,Server,未知,All rights reserved.

05/06/2024 16:17:02,Server,未知,(c) Microsoft Corporation.

05/06/2024 16:17:02,Server,未知,UTC adjustment: 8:00

05/06/2024 16:17:02,Server,未知,Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) <nl/> Apr 29 2016 23:23:58 <nl/> Copyright (c) Microsoft Corporation<nl/> Enterprise Edition (64-bit) on Windows Server 2012 R2 Datacenter 6.3 <X64> (Build 9600: ) (Hypervisor)

05/06/2024 15:53:50,spid9s,未知,SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

05/06/2024 15:53:50,Server,未知,SQL Server shutdown has been initiated

05/06/2024 15:53:50,Server,未知,Problem creating stack dump file due to internal exception

05/06/2024 15:53:50,Server,未知,SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception<c/> or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error<c/> restart the server (unless SQLAgent is configured to auto restart).

05/06/2024 15:53:50,Server,未知,错误: 17311，严重性: 16，状态: 1。

05/06/2024 00:00:00,spid16s,未知,This instance of SQL Server has been using a process ID of 4964 since 2024/5/5 12:36:45 (local) 2024/5/5 4:36:45 (UTC). This is an informational message only; no user action is required.

05/05/2024 12:38:45,spid64,未知,Using 'dbghelp.dll' version '4.0.5'

05/05/2024 12:37:16,Server,未知,Software Usage Metrics is enabled.

05/05/2024 12:36:51,spid54,未知,Using 'xpstar.dll' version '2015.130.1601' to execute extended stored procedure 'xp_sqlagent_notify'. This is an informational message only; no user action is required.

05/05/2024 12:36:51,spid54,未知,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.

05/05/2024 12:36:51,spid54,未知,Using 'xpsqlbot.dll' version '2015.130.1601' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.

05/05/2024 12:36:51,spid54,未知,Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.

05/05/2024 12:36:46,spid5s,未知,Recovery is complete. This is an informational message only. No user action is required.

05/05/2024 12:36:46,spid15s,未知,CHECKDB for database 'Gwms' finished without errors on 2013-12-19 12:24:06.643 (local time). This is an informational message only; no user action is required.

05/05/2024 12:36:46,spid25s,未知,Service Broker manager has started.

05/05/2024 12:36:46,spid25s,未知,The Database Mirroring endpoint is in disabled or stopped state.

05/05/2024 12:36:46,spid25s,未知,The Service Broker endpoint is in disabled or stopped state.

05/05/2024 12:36:46,spid6s,未知,The tempdb database has 8 data file(s).

05/05/2024 12:36:46,spid5s,未知,Recovery is writing a checkpoint in database 'Gwms' (5). This is an informational message only. No user action is required.

05/05/2024 12:36:46,spid5s,未知,0 transactions rolled back in database 'Gwms' (5:0). This is an informational message only. No user action is required.

05/05/2024 12:36:46,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [2] 'tempdb'. XTP Engine version is 0.0.

05/05/2024 12:36:46,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [2] 'tempdb'. XTP Engine version is 0.0.

05/05/2024 12:36:46,spid6s,未知,Starting up database 'tempdb'.

05/05/2024 12:36:46,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [2] 'tempdb'. XTP Engine version is 0.0.

05/05/2024 12:36:46,spid5s,未知,Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.

05/05/2024 12:36:46,spid5s,未知,0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.

05/05/2024 12:36:46,spid15s,未知,1612 transactions rolled forward in database 'Gwms' (5:0). This is an informational message only. No user action is required.

05/05/2024 12:36:46,Server,未知,The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/iZt4yyra4m2u83Z:1389 ] for the SQL Server service. Windows return code: 0xffffffff<c/> state: 63. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.

05/05/2024 12:36:46,Server,未知,The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/iZt4yyra4m2u83Z ] for the SQL Server service. Windows return code: 0xffffffff<c/> state: 63. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.

05/05/2024 12:36:46,spid6s,未知,Clearing tempdb database.

05/05/2024 12:36:46,spid6s,未知,Polybase feature disabled.

05/05/2024 12:36:46,Server,未知,SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is registered for the SQL Server service. This is an informational message. No user action is required.

05/05/2024 12:36:46,spid11s,未知,SQL Server is now ready for client connections. This is an informational message; no user action is required.

05/05/2024 12:36:46,Server,未知,Dedicated admin connection support was established for listening locally on port 1434.

05/05/2024 12:36:46,Server,未知,Server is listening on [ 127.0.0.1 <ipv4> 1434].

05/05/2024 12:36:46,Server,未知,Server is listening on [ ::1 <ipv6> 1434].

05/05/2024 12:36:46,spid11s,未知,Server local connection provider is ready to accept connection on [ .\pipe\sql\query ].

05/05/2024 12:36:46,spid11s,未知,Server local connection provider is ready to accept connection on [ .\pipe\SQLLocal\MSSQLSERVER ].

05/05/2024 12:36:46,spid11s,未知,Server is listening on [ 'any' <ipv4> 1389].

05/05/2024 12:36:46,spid11s,未知,Server is listening on [ 'any' <ipv6> 1389].

05/05/2024 12:36:46,spid11s,未知,A self-generated certificate was successfully loaded for encryption.

05/05/2024 12:36:46,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [3] 'model'. XTP Engine version is 0.0.

05/05/2024 12:36:46,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [3] 'model'. XTP Engine version is 0.0.

05/05/2024 12:36:46,spid6s,未知,Starting up database 'model'.

05/05/2024 12:36:46,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [3] 'model'. XTP Engine version is 0.0.

05/05/2024 12:36:46,spid15s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [5] 'Gwms'. XTP Engine version is 0.0.

05/05/2024 12:36:46,spid14s,未知,128 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.

05/05/2024 12:36:46,spid14s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [4] 'msdb'. XTP Engine version is 0.0.

05/05/2024 12:36:46,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [32767] 'mssqlsystemresource'. XTP Engine version is 0.0.

05/05/2024 12:36:46,spid15s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [5] 'Gwms'. XTP Engine version is 0.0.

05/05/2024 12:36:46,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [32767] 'mssqlsystemresource'. XTP Engine version is 0.0.

05/05/2024 12:36:46,spid6s,未知,The resource database build version is 13.00.1601. This is an informational message only. No user action is required.

05/05/2024 12:36:46,spid14s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [4] 'msdb'. XTP Engine version is 0.0.

05/05/2024 12:36:46,spid6s,未知,Starting up database 'mssqlsystemresource'.

05/05/2024 12:36:46,spid15s,未知,Starting up database 'Gwms'.

05/05/2024 12:36:46,spid14s,未知,Starting up database 'msdb'.

05/05/2024 12:36:46,spid15s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [5] 'Gwms'. XTP Engine version is 0.0.

05/05/2024 12:36:46,spid6s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [32767] 'mssqlsystemresource'. XTP Engine version is 0.0.

05/05/2024 12:36:46,spid14s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [4] 'msdb'. XTP Engine version is 0.0.

05/05/2024 12:36:46,spid5s,未知,Server name is 'IZT4YYRA4M2U83Z'. This is an informational message only. No user action is required.

05/05/2024 12:36:46,spid5s,未知,SQL Trace ID 1 was started by login "sa".

05/05/2024 12:36:46,Server,未知,Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319.

05/05/2024 12:36:46,spid5s,未知,SQL Server Audit has started the audits. This is an informational message. No user action is required.

05/05/2024 12:36:46,spid5s,未知,SQL Server Audit is starting the audits. This is an informational message. No user action is required.

05/05/2024 12:36:46,spid5s,未知,Resource governor reconfiguration succeeded.

05/05/2024 12:36:46,Server,未知,CLR version v4.0.30319 loaded.

05/05/2024 12:36:46,spid5s,未知,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.

05/05/2024 12:36:46,spid5s,未知,0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.

05/05/2024 12:36:46,spid5s,未知,261 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.

05/05/2024 12:36:45,spid5s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [1] 'master'. XTP Engine version is 0.0.

05/05/2024 12:36:45,spid5s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [1] 'master'. XTP Engine version is 0.0.

05/05/2024 12:36:45,spid5s,未知,Starting up database 'master'.

05/05/2024 12:36:45,spid5s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [1] 'master'. XTP Engine version is 0.0.

05/05/2024 12:36:45,Server,未知,Query Store settings initialized with enabled = 1<c/>

05/05/2024 12:36:45,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.

05/05/2024 12:36:45,Server,未知,Lock partitioning is enabled. This is an informational message only. No user action is required.

05/05/2024 12:36:45,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.

05/05/2024 12:36:45,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.

05/05/2024 12:36:45,Server,未知,This instance of SQL Server last reported using a process ID of 6728 at 2024/5/5 12:14:10 (local) 2024/5/5 4:14:10 (UTC). This is an informational message only; no user action is required.

05/05/2024 12:36:45,Server,未知,The maximum number of dedicated administrator connections for this instance is '1'

05/05/2024 12:36:45,Server,未知,Implied authentication manager initialization failed. Implied authentication will be disabled.

05/05/2024 12:36:45,Server,未知,InitializeExternalUserGroupSid failed. Implied authentication will be disabled.

05/05/2024 12:36:45,Server,未知,Buffer pool extension is already disabled. No action is necessary.

05/05/2024 12:36:45,Server,未知,Default collation: Chinese_PRC_CI_AS (简体中文 2052)

05/05/2024 12:36:45,Server,未知,Using conventional memory in the memory manager.

05/05/2024 12:36:45,Server,未知,Detected 64494 MB of RAM. This is an informational message; no user action is required.

05/05/2024 12:36:45,Server,未知,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

05/05/2024 12:36:45,Server,未知,SQL Server detected 1 sockets with 8 cores per socket and 16 logical processors per socket<c/> 16 total logical processors; using 16 logical processors based on SQL Server licensing. This is an informational message; no user action is required.

05/05/2024 12:36:45,Server,未知,Command Line Startup Parameters:<nl/> -s "MSSQLSERVER"

05/05/2024 12:36:45,Server,未知,Registry startup parameters: <nl/> -d D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\master.mdf<nl/> -e D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG<nl/> -l D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\mastlog.ldf

05/05/2024 12:36:45,Server,未知,The service account is 'NT Service\MSSQLSERVER'. This is an informational message; no user action is required.

05/05/2024 12:36:45,Server,未知,Logging SQL Server messages in file 'D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG'.

05/05/2024 12:36:45,Server,未知,Authentication mode is MIXED.

05/05/2024 12:36:45,Server,未知,System Manufacturer: 'Alibaba Cloud'<c/> System Model: 'Alibaba Cloud ECS'.

05/05/2024 12:36:45,Server,未知,Server process ID is 4964.

05/05/2024 12:36:45,Server,未知,All rights reserved.

05/05/2024 12:36:45,Server,未知,(c) Microsoft Corporation.

05/05/2024 12:36:45,Server,未知,UTC adjustment: 8:00

05/05/2024 12:36:45,Server,未知,Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) <nl/> Apr 29 2016 23:23:58 <nl/> Copyright (c) Microsoft Corporation<nl/> Enterprise Edition (64-bit) on Windows Server 2012 R2 Datacenter 6.3 <X64> (Build 9600: ) (Hypervisor)

Answer 1

Hi @leo lee，

你有看过错误日志吗，先看下日志里有没有相关信息。

同时你看可以请参考这篇文章，它可能会帮助您解决此问题。

如果这个问题持续出现并且影响到你的生产环境，你可以开case给微软支持，抓一下dump文件看看具体的问题。

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.