May 16, 2019 at 12:00 am
Comments posted to this topic are about the item Serverless Databases
May 16, 2019 at 10:30 am
Hi Steve,
For my opinion, Azure SQL DB Serverless is useful in development and testing environments
This makes it possible to have a database at a lower cost if you do not implement an automatic process to create test database that includes test data for your development teams.
Just take into account the restart time of the database in the tests.
Ideally, you can create on-demand test databases with up-to-date data. But this requires a real strategy of automatic deployment that also has a cost.
Regards
Jean-Michel
May 16, 2019 at 1:46 pm
I believe that concerns about page buffer pool, plan cache, and latency are outside the intended use case for this type of serverless databases. It's definitely not for high volume transaction applications. I rather see this platform useful for something like ETL staging or perhaps hosting a database for the corporation's quarterly surveys or employee benefit enrollment, where there a few days of heavy activity followed by weeks or months of sporadic usage as people return to occasionally view reports or get information. Having the database spin down automatically makes it essentially always available without capacity planning or intervention on the part of the DBA.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply