SQL Server services set to Delayed Start - Why?

MVP

Reference: SQL Server services are set to Automatic (Delayed Start) start mode
In SQL Server 2022 (16.x), setting the Start Mode for a SQL Server service to Automatic in Configuration Manager, will configure that service to start in Automatic (Delayed Start) mode instead, even though the Start Mode shows as Automatic.

Why did Microsoft make this default standard starting SQL Server 2022?
What are the pros of doing this?

Should we manually set to Delayed Start in lower versions of SQL Servers that are set to automatic start mode?

0 Replies