Please add ability to temporarily turn off/on SQL Azure server to pause billing for both the primary service admin and delegate admins.
Please add the ability to temporarily turn off/on SQL Azure servers to pause and re-enable billing for both the primary service admin and delegate admins. Make SQL Azure a truly Pay-As-You-Go service.
Thanks for your feedback here. I think we have several ways to achieve what you are looking for.
One is to use the import/export service to export a copy of your DB to blob storage, and another is to change the service tier to Basic to minimize your bill.
I’d love to learn more about your request, if these two options don’t work for you.
Fabiano Simões commented
This is not acceptable. What if I am building my app that will make money for me when going live? What if I depend on that money to pay the services hired with you guys?
This is very bad for developers, as we will surely look for another better way to develop our databases and, when it is ready for shipment, probably won`t look back to choose an Azure SQL Database. We will have everything ready and this product will have no chance to be chosen.
Bad strategy of Microsoft.
LEGRAND Julien commented
Please re-open this request, you cannot leave it this way.
This is the way MS operates. Pathetic , Azure in total should be a well oiled solution and ready to be Productionized. Since working with Azure we had to do so may Workarounds in Blob Storage , Data-Factory, Event-Hub and now Azure SQL , Clone of DB to another does not work properly , Database Security is a joke ( depending on the day the model changed and suddenly you have to redo privileges or drop login and user and recreate to get it to work ) etc... the list goes on and on ..
An now I cannot stop a Azure SQL DB to save cost .... and the response from the "Principal Product Planner" .... Just not good enough.
Busy investigating alternatives. No Way I'm risking my business on a Product that's build on workarounds etc.
This has not been solved so why is this closed?
Dumitru Ozunu commented
Hi, we need this feature for Azure SQL Database (PaaS) and also Azure SQL Managed Instance. Azure SQL Datawarehouse supports this feature, so why not also SQL Database?
I wouldn't consider this problem solved - I completely agree with Joe Martin's comment
as it does not matter whether you are charging or not. (for development purposes)
This official Microsoft response is a joke to all of us developers of its technology! that's how they treat us!
Joe Martin commented
This is a very poor setup. I'm paying $80/month for a test/demo environment that gets used 24-48 hours per month. AWS provides an easy way to shut these down and you only pay for static resources like storage, elastic IPs, NAT gateways, etc. That usually comes to around $5-10 for me. That makes a big difference to a startup which is already running on razor thin margins.
I prefer Azure. It's simple and it works, but this needs to change if you really care about your customer.
Fernando Hidalgo (SWBI) commented
This is the reason Snowflake is waaaaay better than Azure SQL or Azure DW.
3 years passed by and there is no decent option on Azure to pause a database
John Staveley commented
This is a great idea and the MS solution is not acceptable. Customers should be able to pauses charging and pay for storage of their data only
this really needs a good solution. Why shouldn't we be able to turn off an Azure MySQL server? Either let us pause for free, or reduce cost to less than $5 / month for a server that is active for only 24 hours a month.
Ian Newson commented
There definitely should be an easy way to pause billing for databases. Deleting and recreating the database is NOT the same thing.
The ability to pause resources and associated compute billing should be built into all Azure services. As someone else mentioned, being able to click 'pause' on a complete resource group is the most user friendly solution.
Let us stop whole Resource Groups (whatever can be stopped within is stopped, including SQL databases). I don't mind paying for the space taken up by the stopped Resource Group; you work that out. The idea is to rev up a Resource Group for say, a customer demo, and stop it afterwards.
Not very customer centric behaviour Microsoft to turn off voting for something that you just don't like (only explicable by penny pinching revenue maximisation objectives) to implement and provide workarounds that are not feasible. By now I would assume the votes for this would be in the hundreds.
Eric Hofer commented
Is MS so poor that it needs to nickel and dime developers? Why should we have to do extra work to pause suspend a project? Having chosen MS' platform over another service, why "fine" us for selecting Azure?
In this scenario MS is shooting himself in the foot. If you allow paying only for storage when DB are not needed to be on as VM I foresee much more usages. Those will start at development and will end up in production meaning $ for MS and happy customers.
Eugene Gusarov commented
Completely agree, suggested workaround is very unhandy
Upvote. The workarounds provided by Guy Haycock are not a solution. Isn't it what cloud was all about? I just pay for resources I use. If I don't use sth, I don't have to pay for it.
This delete/restore solution is not convenient at all and can not be intended for what is meant to be an easy and lightweight solution.
I really think this defeats the purpose of a PaaS database solution.