Jump to main content
Performance Tuning Settings
About this task
These are the recommended performance
tuning settings for your environment to achieve optimal performance. Procedure
Update database settings:-
Update the Cost Threshold for Parallelism
value:
- Open SSMS connect to the instance, where SOA db is
deployed.
- Select the instance, and then right-click, then select
Properties.
- Select the Advanced tab. In the
Parallelism section, in the
Cost Threshold for Parallelism box,
change the default value from 5 to
25.
- Ensure that statistics (sp_updatestats) is updated in the database.
-
We recommend to move the transaction logs to a different drive to
optimize disk I/O performance.