SQL Server reboot Internal workflow

Summary:

2024-01-28 01:35:31.76 Server      Microsoft SQL Server 2019 (RTM-CU24) (KB5031908) - 15.0.4345.5 (X64) Dec  4 2023 14:44:16 Copyright (C) 2019 Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)

2024-01-28 01:35:31.77 Server      Authentication mode is MIXED.

2024-01-28 01:35:31.77 Server      Logging SQL Server messages in file 'D:\MSSQL15.MSSQLSERVER\MSSQL\Log\ERRORLOG'.

2024-01-28 01:35:31.77 Server      The service account is 'service-account'. 

2024-01-28 01:35:31.77 Server      Registry startup parameters: 

2024-01-28 01:35:32.03 Server      Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)

2024-01-28 01:35:32.75 Server      The maximum number of dedicated administrator connections for this instance is '1'

2024-01-28 01:35:33.05 spid11s     Starting up database 'master'.

2024-01-28 01:35:33.47 spid11s     CHECKDB for database 'master' finished without errors on 2023-12-31 22:00:02.127 (local time). 

2024-01-28 01:35:33.49 spid11s     Resource governor reconfiguration succeeded.

2024-01-28 01:35:33.50 spid11s     SQL Server Audit has started the audits. 

2024-01-28 01:35:33.86 Server      Dedicated admin connection support was established for listening remotely on port 1434.

2024-01-28 01:35:33.86 spid25s     SQL Server is now ready for client connections. 

2024-01-28 01:35:34.05 spid13s     Starting up database 'mssqlsystemresource'.

2024-01-28 01:35:34.05 spid26s     Starting up database 'msdb'.

2024-01-28 01:35:34.05 spid33s     Starting up database 'sqldbahub'.

2024-01-28 01:35:34.06 spid13s     The resource database build version is 15.00.4345. 

2024-01-28 01:35:34.11 spid13s     Starting up database 'model'.

2024-01-28 01:35:34.15 spid13s     CHECKDB for database 'model' finished without errors on 2023-12-31 22:00:04.637 (local time). 

2024-01-28 01:35:34.16 spid13s     Clearing tempdb database.

2024-01-28 01:35:34.20 spid26s     CHECKDB for database 'msdb' finished without errors on 2023-12-31 22:00:06.540 (local time). 

2024-01-28 01:35:34.69 spid13s     Starting up database 'tempdb'.

2024-01-28 01:35:36.01 spid13s     The tempdb database has 4 data file(s).

2024-01-28 01:35:36.02 spid11s     Recovery is complete. This is an informational message only. No user action is required.

 


Detailed steps as below:

2024-01-28 01:35:31.76 Server      Microsoft SQL Server 2019 (RTM-CU24) (KB5031908) - 15.0.4345.5 (X64) Dec  4 2023 14:44:16 

Copyright (C) 2019 Microsoft Corporation

Enterprise Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)


2024-01-28 01:35:31.76 Server      UTC adjustment: -5:00

2024-01-28 01:35:31.76 Server      (c) Microsoft Corporation.

2024-01-28 01:35:31.76 Server      All rights reserved.

2024-01-28 01:35:31.76 Server      Server process ID is 5244.

2024-01-28 01:35:31.76 Server      System Manufacturer: 'VMware, Inc.', System Model: 'VMware Virtual Platform'.

2024-01-28 01:35:31.77 Server      Authentication mode is MIXED.

2024-01-28 01:35:31.77 Server      Logging SQL Server messages in file 'D:\MSSQL15.MSSQLSERVER\MSSQL\Log\ERRORLOG'.

2024-01-28 01:35:31.77 Server      The service account is 'service-account'. 

2024-01-28 01:35:31.77 Server      Registry startup parameters: 

-d D:\MSSQL15.MSSQLSERVER\MSSQL\DATA\master.mdf

-e D:\MSSQL15.MSSQLSERVER\MSSQL\Log\ERRORLOG

-l D:\MSSQL15.MSSQLSERVER\MSSQL\DATA\mastlog.ldf

2024-01-28 01:35:31.77 Server      Command Line Startup Parameters: -s "MSSQLSERVER"

2024-01-28 01:35:31.79 Server      SQL Server detected 12 sockets with 1 cores per socket and 1 logical processors per socket, 

   12 total logical processors; using 12 logical processors based on SQL Server licensing. 

2024-01-28 01:35:31.79 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2024-01-28 01:35:31.79 Server      Detected 131071 MB of RAM. This is an informational message; no user action is required.

2024-01-28 01:35:32.03 Server      Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)

2024-01-28 01:35:32.75 Server      The maximum number of dedicated administrator connections for this instance is '1'

2024-01-28 01:35:32.76 Server      This instance of SQL Server last reported using a process ID of 1108 at 1/28/2024 1:34:57 AM (local) 1/28/2024 6:34:57 AM (UTC). 

2024-01-28 01:35:32.78 Server      Node configuration: node 0: CPU mask: 0x000000000000003f:0 Active CPU mask: 0x000000000000003f:0. 

2024-01-28 01:35:32.91 Server      In-Memory OLTP initialized on standard machine.

2024-01-28 01:35:33.05 spid11s     Starting up database 'master'.

2024-01-28 01:35:33.13 Server      CLR version v4.0.30319 loaded.

2024-01-28 01:35:33.37 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.

2024-01-28 01:35:33.47 spid11s     CHECKDB for database 'master' finished without errors on 2023-12-31 22:00:02.127 (local time). 

2024-01-28 01:35:33.49 spid11s     Resource governor reconfiguration succeeded.

2024-01-28 01:35:33.49 spid11s     SQL Server Audit is starting the audits. 

2024-01-28 01:35:33.50 spid11s     SQL Server Audit has started the audits. 

2024-01-28 01:35:33.61 spid11s     SQL Trace ID 1 was started by login "sa".

2024-01-28 01:35:33.85 spid25s     A self-generated certificate was successfully loaded for encryption.

2024-01-28 01:35:33.85 spid25s     Server is listening on [ 'any' <ipv4> 15018].

2024-01-28 01:35:33.85 spid25s     Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].

2024-01-28 01:35:33.85 spid25s     Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].

2024-01-28 01:35:33.86 Server      Server is listening on [ 'any' <ipv4> 1434].

2024-01-28 01:35:33.86 Server      Dedicated admin connection support was established for listening remotely on port 1434.

2024-01-28 01:35:33.86 spid25s     SQL Server is now ready for client connections. This is an informational message; no user action is required.

2024-01-28 01:35:33.86 Server      SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service. 

2024-01-28 01:35:33.98 spid26s     A new instance of the full-text filter daemon host process has been successfully started.

2024-01-28 01:35:34.05 spid26s     Always On: The availability replica manager is starting. This is an informational message only. No user action is required.

2024-01-28 01:35:34.05 spid13s     Starting up database 'mssqlsystemresource'.

2024-01-28 01:35:34.05 spid26s     Starting up database 'msdb'.

2024-01-28 01:35:34.05 spid33s     Starting up database 'sqldbahub'.

2024-01-28 01:35:34.06 spid13s     The resource database build version is 15.00.4345. This is an informational message only. No user action is required.

2024-01-28 01:35:34.11 spid13s     Starting up database 'model'.

2024-01-28 01:35:34.15 spid13s     CHECKDB for database 'model' finished without errors on 2023-12-31 22:00:04.637 (local time). 

2024-01-28 01:35:34.16 spid13s     Clearing tempdb database.

2024-01-28 01:35:34.20 spid26s     CHECKDB for database 'msdb' finished without errors on 2023-12-31 22:00:06.540 (local time). 

2024-01-28 01:35:34.69 spid13s     Starting up database 'tempdb'.

2024-01-28 01:35:36.01 spid13s     The tempdb database has 4 data file(s).

2024-01-28 01:35:36.01 spid26s     The Service Broker endpoint is in disabled or stopped state.

2024-01-28 01:35:36.01 spid26s     The Database Mirroring endpoint is in disabled or stopped state.

2024-01-28 01:35:36.02 spid26s     Service Broker manager has started.

2024-01-28 01:35:36.02 spid11s     Recovery is complete. This is an informational message only. No user action is required.

2024-01-28 01:41:36.87 spid59      Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.

2024-01-28 01:41:36.89 spid59      Using 'xplog70.dll' version '2019.150.4345' to execute extended stored procedure 'xp_msver'. 

2024-01-28 08:55:34.73 spid61      Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.

2024-01-28 08:55:34.78 spid61      Using 'xpstar.dll' version '2019.150.4345' to execute extended stored procedure 'xp_instance_regread'. 


No comments:

Post a Comment

Popular Posts