We’ve just migrated from Sitecore 8.2.5 on-prem to 9.3 Azure PaaS. Performance seems ok most of the time, but we’re seeing regular spikes to 100% DTU on the web db.
The db is standard S2 50 DTU and we’re running 8 websites. I’m not convinced this adequate but need to convince my company. Is there any optimisations we can do and what tier are others using for their db’s? Thanks.