Database Server Configuration

If you notice that the response times of your system are too slow and you are dissatisfied with the throughput, there are a number of Windows and SQL Server settings you can adapt manually to improve the performance. Changing these settings can be of benefit not only to a system experiencing problems, but also to a system running satisfactorily. By making the recommended adjustments, you can effectively avoid bottlenecks at peak processing times and ensure continual smooth operation of your system.

Windows Configuration

SAP recommends the following adjustments:

• Increasing the size of the Windows page file
• Optimizing the Virtual Memory Manager
• Removing the screen saver

SQL Server

SQL Server optimizes many configuration settings automatically. This means configuration options are dynamically adapted to meet requirements at runtime. For example, the allocated memory and lock resources are increased or decreased depending on the nature of the current workload. Despite the performance benefits provided by automatic tuning, it is nevertheless still worthwhile to manually adjust some settings to improve the throughput of the system in the SAP environment.

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