SSMS wakes up paused Azure SQL databases if you connect to the server using AD account without specifying a database to connect to
GregObleshchuk opened this issue · 2 comments
I have several Azure SQL Database all using the same SQL Server. Some of the databases are serverless and will pause when no activity happens for 1 hour.
When I use SSMS to connect to the SQL Server using my Azure Active Directory admin account without specifying a database name in the connection dialog box, the connect "wakes" up all the paused databases. This is without expanding any items on the server tree.
Because I will connect and disconnect serveral times a day the databases are changing from paused to online for at least 1 hour and I am then being charged for this compute.
I'm currently using 18.11.1. I checked the release notes of later versions and can't find anything that would say this issue has been addressed
cheers
Greg O
.
@GregObleshchuk this is power of clouds)