search

ktaranov / sqlserver-kit

Useful links, scripts, tools and best practice for Microsoft SQL Server Database
http://sqlserver-kit.org
MIT License
2.14k stars 669 forks source link

SSMS wakes up paused Azure SQL databases if you connect to the server using AD account without specifying a database to connect to #210

Closed GregObleshchuk closed 1 year ago

GregObleshchuk commented 1 year ago

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 commented 1 year ago

.

ktaranov commented 1 year ago

@GregObleshchuk this is power of clouds)