Our branch dashboards read from a reporting database that is loaded overnight from our trading system. Last year we moved it to Azure SQL Database on the serverless option, which charges for computing power only while the database is working. It is busy for a few hours each morning, when branch managers check yesterday's sales and today's deliveries, and idle for much of the night. Serverless can also pause a database completely when nobody has used it for a set time, so that you pay only for storage. We set it to pause after an hour, and the bill fell by more than half.
Three weeks later, branch managers began telling us the dashboards were showing the day before yesterday. Not every morning, but most.
The cause was the first connection of the day. The overnight load finished at about one o'clock, and an hour later the database paused. At half past five the dashboard tool connected to refresh its figures.…