Performance Tuning Settings

About this task

These are the recommended performance tuning settings for your environment to achieve optimal performance.

Procedure

Update database settings:
  1. Update the Cost Threshold for Parallelism value:
    1. Open SSMS connect to the instance, where SOA db is deployed.
    2. Select the instance, and then right-click, then select Properties.

    3. Select the Advanced tab. In the Parallelism section, in the Cost Threshold for Parallelism box, change the default value from 5 to 25.

  2. Ensure that statistics (sp_updatestats) is updated in the database.
  3. We recommend to move the transaction logs to a different drive to optimize disk I/O performance.