Cost per consumtion for SQL Databases

Question

Hi All,

I have got few sql servers migrated to azure IAAS. It has a shared instance which contains databases of various projects.

Is there a formula to calculate the costs per database based on the usage?

Eg: If there are 3 databases.

Database A consumed 2/3rd resources --->will be billed 2/3 of total cost of server including licenses.

Do we have a standard practise which is generally followed?

Do we know how much weightage is given to CPU\Memory...

Thanks,

ACDBA

Answer 1

Use the Azure Pricing calculator

https://azure.microsoft.com/en-us/pricing/calculator

Answer 2

@ACDBA Thank you for reaching out.

You can also use Azure Cost Management to verify the cost of each database residing in a server based on usage. Azure Cost Management provides a comprehensive view of your cloud spending across multiple subscriptions and services, including Azure Database and many other Azure services.

To view the cost of each database in a server, you can follow these steps:

1. Go to the Azure portal and navigate to the Cost Management + Billing blade.
2. Select the subscription that contains the server and databases you want to view.
3. Click on the Cost analysis tab and select the appropriate time range.
4. In the Group by dropdown, select Resource.
5. In the Filter field, enter the name of the server to filter the results.
6. Click on Apply to view the cost breakdown by resource.
7. Locate the databases in the list and view their respective costs.

This will give you a breakdown of the cost of each database based on their resource consumption.

Regards,

Oury

Answer 3

Hi Oury,

I am looking at IAAS not PAAS databases.

Regards,

ACDBA