Solution : https://service.sap.com/sap/support/notes/1654613 (SAP Service marketplace login required)
Summary :
SQL Server's configuration option "max degree of parallelism," recommended by SAP to be set to 1, limits parallel query execution but does not impact SAP BW systems. SAP BW manages SQL parallelism through RSADMIN parameters like MSS_MAXDOP_QUERY and MSS_MAXDOP_INDEXING for optimizing query execution and index operations. SAP Note improvements explicitly support parallel index creation and adjust SAP BW default settings to enhance performance, including adjustments for query parallelism and index creation thresholds based on CPU capabilities. The notes ensure backward compatibility with adjustments already included in newer SAP BW releases.
Key words :
parallel running bw batch jobs, support parallel index creation sap note 1126568, support parallel query executionthe correction, newer sap bw releases, sql server configuration option, setting mss_maxdop_indexing = false turns, including sap bw systems, setting mss_maxdop_query = false turns, maximum index creation performance, parallel index operations
Related Notes :
| 1454130 | DDIC support for using DB parallelism during index creation |
| 1237682 | Configuration Parameters for SQL Server 2008 |
| 1126568 | Enable star join optimization with SQL Server 2008 |
| 879941 | Configuration Parameters for SQL Server 2005 |