Tuning Microsoft Windows for Enhanced Siebel Server Performance

This topic describes how you can configure settings for your Microsoft Windows operating system to optimize the performance of Siebel CRM. It contains the following information:

Oracle strongly recommends that Siebel customers using Microsoft SQL Server follow the tuning guidelines and best practices provided by Microsoft to optimize the performance of their current MS SQL Server deployment.

Specifically, regarding the MS SQL Server Compatibility Mode, it has been determined through Oracle's Siebel performance and scalability testing that, in certain scenarios, setting the Compatibility Mode to 100 yields the most favorable performance outcomes for Siebel applications running on MS SQL Server. It's noteworthy that the default Compatibility Mode in MS SQL Server 2019 is 150. In cases where performance challenges arise, Oracle highly recommends conducting load testing with the Compatibility Mode set to 100. This assessment aims to gauge potential enhancements in performance for Siebel application deployments on MS SQL Server.

Another vital aspect to consider is the Max Degree of Parallelism. In all instances of Siebel application deployment on MS SQL Server, it is imperative to establish the Degree of Parallelism at a value of 1.