February 4, 2022 at 6:40 am
I have a simple AG with a ready only secondary SQLSERVER 2016 Enterprise.
My question is rather simple, but I haven't been able to find anything on this
Should or does it matter for the Cost Threshold for Parallelism setting be the same on both the primary and secondary?
Does this matter? Best practice?
Thank you for any feedback!
February 4, 2022 at 7:12 am
IMHO: No
It should be set to support the workload of the instance: "Why Cost Threshold For Parallelism Shouldn’t Be Set To 5"
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 4, 2022 at 2:23 pm
How is the read-only secondary being used?
Is read only routing configured, and the applications that have their connection strings set to use the secondary actively running select queries against this node? In this case, setting CTFP to a higher level may provide the most benefit.
Or, is it used strictly for reporting or ad-hoc queries? If so, then it would probably be set lower.
In any case, 5 (default) is probably completely wrong.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
February 4, 2022 at 9:29 pm
Thank you for the responses! This is just a simple read only secondary.
I actually have both set at 50, but the primary needs to be bumped up. After 4 months of monitoring 50 just isn't enough, but wasn't sure if I had to do the secondary as well.
Thank again, appreciate you!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply