Symptom
1> sp_configure "max query parallel degree"
2> go
Parameter Name Default Memory Used Config Value Run Value Unit Type
------------------------------------------------------------------------
max query parallel degree 1 0 1 1 number dynamic
(1row affected)
(return status = 0)
1> sp_configure "max query parallel degree", 6
2> go
Msg 10893, Level 16, State 1:
Server 'SID', Procedure 'sp_configure', Line 1344:
The value of 'max query parallel degree' ('6') cannot be less than the value of 'max parallel degree' ('10').
Use sp_configure to lower the value of 'max parallel degree' or raise the value of 'max query parallel degree'.
Msg 5849, Level 16, State 1:
Server 'SID', Procedure 'sp_configure'. Line 1344:
Verification failed for parameter 'max query parallel degree'.
(return status = 1)
1> sp_configure "max parallel degree"
2> go
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------------------------------------------------------------
max parallel degree 1 0 10 10 number dynamic
(1 row affected)
(return status = 0)
1> sp_configure "max parallel degree", 1
2> go
Msg 10807, Level 16, State 1:
Server 'SID', Procedure 'sp_configure', Line 1344:
The value of 'max parallel degree' ('1') cannot be less than the value of 'max scan parallel degree' ('4').
Use sp_configure to lower the value of 'max scan parallel degree' or raise the value of 'max parallel degree'.
Msg 5849, Level 16, State 1:
Server 'SID', Procedure 'sp_configure', Line 1344:
Verification failed for parameter 'max parallel degree'.
(return status = 1)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP NetWeaver (NW) - All versions
- SAP Adaptive Server Enterprise (ASE)
Product
Keywords
KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview