Active connections when database not open to public access

Question

I have an Azure MySQL database which is currently running a high daily cost just in IO operations, even on days when I'm not using the database.

I'm trying to cut costs and I noticed that I have an average of 100 select queries being run every 5 minutes even though I'm not using it, I tried to disable public access but its still showing as having 4 active connections and 100 select queries every 5 minutes

I'm wondering is there any services being run on the database that I can disable to reduce costs?

I would appreciate any tips on keeping costs down as well!

Answer 1

@Mark Buckley Welcome to Microsoft Q&A thanks for posting your question.

If your compute resources are underutilized, consider scaling down your compute tier or size (vCores). If your workload doesn't require continuous full compute capacity, switching to the Burstable compute tier might be more cost-effective.

Use Azure Advisor to get recommendations on server right-sizing and other cost optimization strategies. It provides daily checks and suggestions based on your server's performance history

https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-service-tiers-storage

https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-azure-advisor-recommendations

Regards

Geetha