How do I reduce LOG_RATE_GOVERNOR waits in SQL Database
I have a client with a SQL Database in Azure and the highest wait type is LOG_RATE_GOVERNOR. Is the only option to upgrade to the next edition (P3) or to shard the database into multiple smaller once? With the P3 They will get 4times more DTU:s but the price is also 4times higher. The client is considering to move everything to "onpremises" SQL Server due to the performance issues and the cost of the P3 edition.
That's transactional in nature so the best way is probably to shard, not even to do the upgrade to the higher tier. So the costs wouldn't be four times or even two times as much, but it would be higher plus the work of setting up a sharding mechanism.