SQL Server startup parameters

Category: Reliability
Item: SQL Engine startup settings

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 found 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.

The Startup Parameters tab has three parameters by default.

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

How can I add trace Flags at 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.

 

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

More information

Microsoft – Database Engine Service Startup Options

Share this post

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email

Leave a Comment

Your email address will not be published. Required fields are marked *

4.8/5

42

TESTIMONIALS

FREE Scripts to Instantly
Improve SQL Server Performance

3 FREE Scripts to Instantly
Improve SQL Server Performance

Learn how to increase Performance of SQL Server INSTANTLY with 3 free scripts.