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 will benefit the performance of your system.
For recommendations on how to tune the SQL Server in the SAP environment see Database Performance Tuning.
The most commonly used server options can be modified directly in the Enterprise Manager. Other, more specialized options can be set using the sp_configure stored procedure as described in the SQL Server Books Online. Also refer to the books to find out which options are self-configuring.
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 see Configuring Databases
1. In the Enterprise Manager select the server and choose Action ®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.
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.