Show TOC

Configuring SQL ServerLocate this document in the navigation structure

Use

You can optimize the performance of the SQL Server by setting or adapting server configuration options. If you intend to change options, keep in mind that SQL Server has internal features that enable it to manage and optimize resources automatically, depending on runtime conditions. Only change configuration settings, if you are sure they improve the performance of your system.

For recommendations about how to tune the SQL Server in the SAPenvironment, seeDatabase Server Configuration.

The most commonly used server options can be modified directly in the SQL Server Management Studio. Other, more specialized options can be set using the sp_configure stored procedure as described in the SQL Server Books Online. To find out which options are self-configuring, also refer to the SQL Server Books Online.

Note

When server properties are modified this affects the entire server. If you want to adjust settings that only affect a particular database, you have to change the configuration of the database. For more information seeConfiguring Databases.

For recommendations about the settings for the SQL Server, refer to the SAP Notes 1702408 (SQL Server 2012), or 1237682 (SQL Server 2008 (R2)) or 879941 (SQL Server 2005).

Procedure

  1. In the SQL Server Management Studio right-click the server and choose Properties.

    The Server Properties dialog box opens. It offers a tab for each category of available configuration options.

  2. Choose the tab for the resource you wish to configure.
  3. Enter the information required and choose OK.
    Note

    Some settings only take effect after the server has been restarted. If a server restart is necessary, a dialog box appears asking you whether you wish to stop and restart the server.