Skip to content

sql-server-properties-startup-parameters-tab.md

Latest commit

 

History

History
77 lines (54 loc) · 5.18 KB

sql-server-properties-startup-parameters-tab.md

File metadata and controls

77 lines (54 loc) · 5.18 KB
title SQL Server Properties (Startup Parameters Tab)
description Use the Startup Parameters tab of the SQL Server Properties dialog box to add or remove startup parameters, which can affect Database Engine performance.
author rwestMSFT
ms.author randolphwest
ms.date 03/14/2017
ms.service sql
ms.subservice tools-other
ms.topic conceptual
ms.collection
data-tools
monikerRange >=sql-server-2016

SQL Server Properties (Startup Parameters Tab)

[!INCLUDE SQL Server Windows Only] Use this dialog box to add or remove startup parameters for the [!INCLUDEssDE]. Startup parameters can have a large effect on the [!INCLUDEssDE] performance. Before adding or changing startup parameters, see the topic "Using the [!INCLUDEssNoVersion] Service Startup Options" in [!INCLUDEssNoVersion] Books Online.

Options

Specify a startup parameter
To add a parameter, type the parameter, and then click Add.

To modify one of the required parameters, select the parameter in the Existing parameters box, change the values in the Specify a startup parameter box, and then click Update.

Existing parameters
To remove a parameter, select a parameter, and then click Remove.

Parameter Format

Do not enter a separator between parameters. [!INCLUDEssNoVersion] Configuration Manager automatically adds the separator. [!INCLUDEssNoVersion] Configuration Manager enforces the following parameter requirements.

  • Leading and trailing spaces are trimmed from any startup parameter.

  • All startup parameters start with a - (dash) and the second value is a letter.

Required Parameters

The following parameters are required. They can be changed but not removed.

  • -d is the path of the master.mdf file (the master database data file).

  • -l is the path of the master.ldf file (the master database log file).

  • -e is the path of the [!INCLUDEssNoVersion] error log files.

Caution

If the file path parameters are incorrect [!INCLUDEssNoVersion] might not start.

For more information about how to move the master database, see the topic "Moving System Databases" in [!INCLUDEssNoVersion] Books Online.

Optional Parameters

All of the supported startup parameters are described in the topic "Using the [!INCLUDEssNoVersion] Service Startup Options," in [!INCLUDEssNoVersion] Books Online. A startup parameter of -Ttrace# indicates that an instance of [!INCLUDEssNoVersion] should be started with a specified trace flag (trace#) in effect. Trace flags are used to start the server with nonstandard behavior. For more information about trace flags, see Set trace flags with DBCC TRACEON.

Caution

You might see additional undocumented startup parameters and trace flags described on the Internet. Undocumented startup parameters and trace flags are created to address uncommon problems or to force certain conditions required for testing. Using undocumented startup parameters can have unexpected results. Do not use undocumented parameters unless directed by Microsoft Customer Support Services.

The following list describes some common optional parameters.

Parameter Short description
-m Starts an instance of [!INCLUDEssNoVersion] in single-user mode.
-T1204 Returns the resources and types of locks participating in a deadlock and also the current command affected.
-T1224 Disables lock escalation based on the number of locks.
-T3608 Prevents [!INCLUDEssNoVersion] from automatically starting and recovering any database except the master database.
-T7806 Enables a dedicated administrator connection (DAC) on [!INCLUDEssExpress].

Caution

Some optional parameters can change server behavior and may affect performance.

Permissions

Use of this page is restricted to users who can change the related entries in the registry. This includes the following users.

  • Members of the local administrators group.

  • The domain account that is used by [!INCLUDEssNoVersion], if the [!INCLUDEssDE] is configured to run under a domain account.

Books Online References

For additional information about [!INCLUDEssNoVersion] startup parameters, see "How to: Configure Server Startup Options ( [!INCLUDEssNoVersion] Configuration Manager)" in [!INCLUDEssNoVersion] Books Online.