vsamantha35 - Tuesday, December 12, 2017 11:37 AM
Jeff has largely nailed it. Most of your queries shouldn't go parallel if you're tuning them and running them against a good structure with appropriate indexing. However, you don't have that control, so there really is no other solution for it at this time.
I really don't like using the MAXDOP hint or database configuration unless there is no other option. However, it's possible that you could see that kind of stress occurring if you do. Again, you have fewer knobs to tweak on Azure SQL Database.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning