Menu

We Let Our Reporting Database Pause Itself at Night and Most Mornings Its First Visitor Was Turned Away
📰

We Let Our Reporting Database Pause Itself at Night and Most Mornings Its First Visitor Was Turned Away

DEV Community: azure·Serguey Shinder·about 18 hours ago
#rDDPQq3a
#devtoazure#devto#dev#database#refresh
Long article (400 words) — no AI summary yet.
Reading 0:00
15s threshold

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.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.