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 NT and SQL 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.

SAP recommends the following adjustments:

SQL Server 7.0 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 R/3 environment.

For recommendations on settings for the SQL Server, refer to the R/3 Note 126808.