SQL数据库引擎服务SQL Server启动参数概述

In the SQL world, it is an important activity to perform SQL Server installation for a database administrator. Have you ever noticed ‘SQL Server Startup Parameters’ for the SQL Service? You might not have noticed them, but these parameters are beneficial for DBAs.

在SQL世界中，对数据库管理员执行SQL Server安装是一项重要的活动。 您是否曾经注意到SQL服务的“ SQL Server启动参数”？ 您可能没有注意到它们，但是这些参数对于DBA很有帮助。

Let’s say you install the SQL service database engine. After installation, services are running in the automatic mode and you can connect to the SQL instance.

假设您安装了SQL服务数据库引擎。 安装后，服务将以自动模式运行，您可以连接到SQL实例。

Let me start with a simple but logical question – What is the sequence for the SQL Service startup?

让我首先提出一个简单但合乎逻辑的问题-SQL Service启动的顺序是什么？

SQL Service启动的高级顺序 (The high-level sequence of SQL Service start-up)

It is a useful thing to know about the startup of SQL Services. The high-level steps are:

了解SQL Services的启动是很有用的。 较高级别的步骤是：

• The request failed, or the service did not respond in a timely fashionYou can go to the event viewer and check the logs for detailed information 请求失败，或者服务没有及时响应您可以转到事件查看器并检查日志以获取详细信息
• In the next step, it reads the SQL Server startup parameters from the registry (we will cover in detail in later part of this article) and verify the data file, log file location of the master database along with the error log path
  在下一步中，它将从注册表中读取SQL Server启动参数（我们将在本文的后面部分详细介绍），并验证数据文件，master数据库的日志文件位置以及错误日志路径。
• It allocates the memory and CPU to SQL Server as per the configuration
  它根据配置将内存和CPU分配给SQL Server
• It starts up the master database
  它启动主数据库
• The master database contains an entry for all other system databases and user databases. It reads the information of the data file and log file of the databases and starts the recovery process (Analysis, Redo and Undo phases) for the databases
  主数据库包含所有其他系统数据库和用户数据库的条目。 它读取数据库的数据文件和日志文件的信息，并开始数据库的恢复过程（分析，重做和撤消阶段）
• It creates the tempdb database file and logs files as per the initial size, number of data files etc.
  它会创建tempdb数据库文件并根据初始大小，数据文件数等记录日志文件。
• It starts the default trace audit; startup extended event sessions and records all events in the SQL Server error log
  它启动默认的跟踪审核； 启动扩展事件会话并在SQL Server错误日志中记录所有事件
• SQL Server attempts to register Service Principal Name ( SPN) to use Kerberos authentication
  SQL Server尝试注册服务主体名称（SPN）以使用Kerberos身份验证
• It opens the SQL Server port and starts accepting a connection to the database. Once it is ready, you get a message in the SQL Server error logSQL Server is now ready for client connections. This is an informational message; no user action is required
• 它打开SQL Server端口并开始接受与数据库的连接。 准备就绪后，您会在SQL Server错误日志中收到一条消息，表明SQL Server 现在已准备好进行客户端连接。 这是一条情报信息; 无需用户操作

SQL Server启动参数 (SQL Server startup parameters)

This article focuses on the startup parameters. To view the SQL Server startup parameters, right-click on the SQL Server Service and go to properties. It opens the SQL Services properties window.

本文重点介绍启动参数。 若要查看SQL Server启动参数，请右键单击“ SQL Server服务”，然后转到属性。 它打开“ SQL Services属性”窗口。

Click on the Startup Parameters. You can see the default configured SQL Server startup parameters -d, -e and -l and their values.

单击启动参数 。 您可以看到默认配置SQL Server启动参数-d，-e和-l及其值。