SQL Server Health Check

SQL Server Startup Parameters

Updated June 26, 20262 min read

SQL Server startup parameters. A row of small switches sits under one big round start button on a panel.

What are SQL Server startup parameters?

When you install SQL Server, setup writes a set of default startup options in the Microsoft Windows registry that influences how it is started.

You can use these startup parameters to specify an alternate path to specific file locations needed during startup and specify some server-wide conditions.

Also, you can set startup parameters that use trace flags that affect the SQL Server behavior.

How can I check it?

You will find these startup options using the SQL Server Configuration Manager.

In the right pane, right-click SQL Server (<instance_name>), and then click Properties.

Figure 1 - SQL Engine startup settings
Figure 1 - SQL Server Database Engine startup settings

The Startup Parameters tab has three parameters by default.

  1. Location of the master database data file (-d)
  2. Location of the master database log file path (-l)
  3. SQL Server error logs path (-e)

How can I add trace flags as parameters?

To enable a trace flag and ensure the trace flag stays enabled through restarts, use a -T and the trace flag number (no spaces) as the sample below.

Figure 2 - Adding trace flag to SQL Server startup parameters
Figure 2 - Adding trace flag to SQL Server startup parameters

Note: improper use of startup options can affect server performance and can prevent SQL Server from starting.

More information

Check Red9's SQL Server Services

SQL Server Consulting

Perfect for one-time projects like SQL migrations or upgrades, and short-term fixes such as performance issues or SQL remediation.

Discover More ➜

SQL Server Managed Services

Continuous SQL support, proactive monitoring, and expert DBA help with one predictable monthly fee.

Discover More ➜

Emergency SQL Support

Take the stress out of emergencies with immediate access to a SQL Server Sr. DBA 24x7x365

Discover More ➜

Explore All Services ➜