Parallelism and CPU
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.
The challenge for me and many for others is that the Cost Threshold for Parallelism on Azure SQL Databases is set to 5 and it cannot be changed.
While I do think that the emphasis should be on the logic and indexes it really is a disadvantage for something so important. I hope this will be changed in the future.
But the important thing is that it gives you the illusion you need to pay more for a bigger instance with more CPUs.