In AzureSQL, I would like Redgate Monitor to not "keep awake" systems which are set to "sleep".
Within AzureSQL you can set SQL Servers to be Serverless and also to "sleep after" a time window. This means you can save money for systems which are not heavily used.
I think Redgate Monitor needs to have a "light touch" mode for such systems where it will firstly check the config and say "ok, this server is asleep, I dont need to look at it" before reporting maybe in the infomration status "system asleep". When the system wakes up, it should monitor as normal.
This is a cost saving exercise since, after adding Redgate to our Legacy AzureSQL servers, the cost went up by £250 a month per system. (we've gone from £10 purely storage, to £250 because Redgate is keeping it awake. IF this were a higher spec system, this cost could have been more.
Andy
shared this idea
-
Mark Freeman
commented
We are just starting to experiment with Azure SQL Serverless Databases and we simply cannot monitor them with Redgate Monitor without losing the ability to auto-pause, which is the main reason for wanting to use that technology.
You give us the choice of giving up Azure cost savings, or costing yourself in license fees for databases we have to stop monitoring.
-
Andy
commented
As well as a cost saving exercise, this also pushes us into the "fit for purpose" conversation.