Question
Nationwide Building Society
GB
Last activity: 4 Jun 2024 7:28 EDT
What is the Impact of MAXDOP setting at DB to Pega application performance ?
Hello Everyone,
There is an observation highlighted by our DBA that the current max degree of parallelism (MAXDOP) is not set properly and they would like to change it.
Can someone please advise how changing this MAXDOP setting at DB impacts the Pega application performance?
We are using Pega 8.8.2 on-prem version hosted on MS SQL 2019.
Thank You!
Regards,
Guhanathan Vijayanarayanan
Accepted Solution
Updated: 4 Jun 2024 7:28 EDT
Pegasystems Inc.
GB
@GuhanathanV4521 The MAXDOP setting in SQL Server controls the number of processors that are used for the execution of a query in a parallel plan. This option determines the computing and thread resources that are used for the query plan operators that perform the work in parallel. Depending on the nature of the queries and the database setup, changing this setting could potentially improve the performance of your Pega application. However, it's important to thoroughly test these changes in a non-production environment first, as increasing the MAXDOP value could also lead to increased resource contention in some cases.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
PDC shows slow query on PEGA.PR_DATA_QP_RUN_PARTITION table.
Increase max number of ACTIVE requestors
Managing inactive branches in branched application development [SDR-A1]