Estimated on-demand costs for cloud database servers

Turbonomic considers a variety of factors when calculating estimated on-demand monthly cost for cloud database servers.

Action Details page

Azure SQL Managed Instances

Cost Calculation

For Azure SQL Managed Instances, the calculation for Estimated On-demand Monthly Cost can be expressed as follows:

(On-demand Compute Rate * 730) + (Provisioned Database Storage Rate * (Provisioned Database Storage Amount - Included Storage Per Server)) + (Provisioned IOPS Rate * (Provisioned Database IOPS - Included IOPS Per Server)) = Estimated On-demand Monthly Cost

Where:

  • On-demand Compute Rate is the hourly cost for a Database Server's instance type.

    You can obtain on-demand rates via Azure SQL Managed Instance Pricing.

  • 730 represents the number of hours per month that Turbonomic uses to estimate monthly costs.

  • Provisioned Database Storage Rate is the hourly cost for a Database Server's provisioned database storage.

    You can obtain provisioned database storage rates via Azure SQL Managed Instance Pricing.

  • Provisioned Database Storage Amount is the amount of storage provisioned for the database server.

  • Included Storage Per Server is the amount of storage that is provided at no extra cost. Included storage is always 32 GB, regardless of configuration or service tier.

  • Provisioned IOPS Rate is the monthly cost for a Database Server's provisioned IOPS.

    Provisioned IOPS applies only to Database Servers on the Next-gen General Purpose service tier. Provisioned IOPS is either 300 IOPS or 3 * Provisioned Database Storage Amount in GB, whichever is greater.

    You can obtain information about Provisioned IOPS storage via Azure SQL Managed Instance Pricing.

  • Provisioned Database IOPS is the amount of IOPS provisioned for the database server.

  • Included IOPS Per Server is the amount of IOPS that is provided at no extra cost.

    Turbonomic checks the following values and picks the greater value:

    • 300 IOPS

    • 3 * number of IOPS in GB or the maximum amount of IOPS allowed for a given size, whichever is lower

The preceding items impact cost calculations and the scaling decisions that Turbonomic makes. These decisions also rely on other factors, such as resource utilization percentiles and scaling constraints set in policies.

Example

Assume the following data for a pending scale action for a SQL Managed Instance on General Purpose Premium-series. Turbonomic recommends scaling from GP_G8IM_10 to GP_G8IM_4 and reducing disk size to 64 GB.

Item

Current Values

Values After Action Execution

On-demand Compute Rate

$2.760/hr

$1.104/hr

Provisioned Database Storage Rate

$0.133/GB/month

$0.133/GB/month

Included Storage Per Server

32 GB

32 GB

Provisioned Database Storage Amount

750 GB

64 GB

Provisioned IOPS Rate

$0.038/IOPS

$0.038/IOPS

Included IOPS Per Server

300

300

Provisioned IOPS Amount

7000

300

Included IOPS

2208

300

Turbonomic calculates the following:

  • Current Estimated On-demand Monthly Cost:

    (2.760 * 730) + (0.133 * (750 - 32) + (0.038 * (7000 - 300)) = 2364.89
  • Estimated On-demand Monthly Cost after executing the action:

    (1.104 * 730) + (0.133 * (64 - 32) + (0.038 * (300 - 300)) = 810.18
Note:

Turbonomic rounds the calculated values that it displays in the user interface.

The Estimated On-demand Monthly Cost is projected to reduce from $2364.89/month to $810.18/month.

Turbonomic treats the action as a cost-saving measure and shows estimated savings of $1554.71/month.

AWS RDS database servers

Cost Calculation

For AWS RDS Database Servers, the calculation for Estimated On-demand Monthly Cost can be expressed as follows:

(On-demand Compute Rate * 730) + (Provisioned Database Storage Rate * Provisioned Database Storage Amount) + (Provisioned IOPS Rate * Provisioned IOPS Amount) = Estimated On-demand Monthly Cost

Where:

  • On-demand Compute Rate is the hourly cost for a Database Server's instance type.

    You can obtain on-demand rates via AWS RDS Pricing.

  • 730 represents the number of hours per month that Turbonomic uses to estimate monthly costs.

  • Provisioned Database Storage Rate is the hourly cost for a Database Server's provisioned database storage.

    You can obtain provisioned database storage rates via AWS RDS Pricing.

  • Provisioned IOPS Rate is the monthly cost for a Database Server's provisioned IOPS.

    Provisioned IOPS apply only to Database Servers on Provisioned IOPS SSD (io1) storage. You can obtain information about Provisioned IOPS SSD storage via the RDS User Guide.

    You can obtain provisioned IOPS rates via AWS RDS Pricing.

The preceding items impact cost calculations and the scaling decisions that Turbonomic makes. These decisions also rely on other factors, such as resource utilization percentiles and scaling constraints set in policies.

Example

Assume the following data for a pending scale action for SQL Server Express Edition (Single A-Z deployment):

Item

Current Values

Values After Action Execution

On-demand Compute Rate

$0.024/hr

$0.048/hr

Provisioned Database Storage Rate

$0.133/hr

$0.133/hr

Provisioned Database Storage Amount

20 GB

20 GB

Provisioned IOPS Rate

$0.00

$0.00

Provisioned IOPS Amount

0

0

Turbonomic calculates the following:

  • Current Estimated On-demand Monthly Cost:

    (0.024 * 730) + (0.133 * 20) + (0.00 * 0) = 20.18
  • Estimated On-demand Monthly Cost after executing the action:

    (0.048 * 730) + (0.133 * 20) + (0.00 * 0) = 37.7
Note:

Turbonomic rounds the calculated values that it displays in the user interface.

The Estimated On-demand Monthly Cost is projected to increase from $20.18/month to $37.7/month, as shown in the Details section of the pending action.

Details section of pending action highlighting Total Cost

Turbonomic treats the action as an investment and shows an estimated investment of $17.52/month.

Details section highlighting Total Investments

AWS Aurora database servers

Cost Calculation

For AWS Aurora Database Servers, the calculation for Estimated On-demand Monthly Cost can be expressed as follows:

(On-demand Compute Rate * 730) + (Provisioned Database Storage Rate * Provisioned Database Storage Amount) + (I/O Request Rate * (Hourly Billed I/O Operation Count * 730)) = Estimated On-demand Monthly Cost

Where:

  • On-demand Compute Rate is the hourly cost for a Database Server's instance type

    You can obtain on-demand rates via AWS Aurora Pricing.

  • 730 represents the number of hours per month that Turbonomic uses to estimate monthly costs.

  • Provisioned Database Storage Rate is the hourly cost for a Database Server's provisioned database storage

    You can obtain provisioned database storage rates via AWS Aurora Pricing.

  • I/O Request Rate is the cost per one million read/write I/O requests

    You can obtain I/O request rates via AWS Aurora Pricing.

  • Hourly Billed I/O Operation Count is the average sum of read and write I/O operations per hour over the last month

The preceding items impact cost calculations. Except for I/O request rate, these items affect the actual scaling decisions that Turbonomic makes. These decisions also rely on other factors, such as resource utilization percentiles and scaling constraints set in policies.

Example

Assume the following data for a pending scale action for Aurora MySQL-Compatible Edition:

Item

Current Values

Values After Action Execution

On-demand Compute Rate

$0.164/hr

$0.041/hr

Provisioned Database Storage Rate

$0.10/hr

$0.10/hr

Provisioned Database Storage Amount

100

100

I/O Request Rate

$0.20/one million requests

$0.20/one million requests

Hourly Billed I/O Operation Count

2000

2000

Turbonomic calculates the following:

  • Current Estimated On-demand Monthly Cost:

    (0.164 * 730) + (0.10 * 100) + ((0.20 / 1000000) * (2000 * 730)) = 130.01
  • Estimated On-demand Monthly Cost after executing the action:

    (0.041 * 730) + (0.10 * 100) + ((0.20 / 1000000) * (2000 * 730)) = 40.22
Note:

Turbonomic rounds the calculated values that it displays in the user interface.

Since the Estimated On-demand Monthly Cost is projected to decrease from $130.01/month to $40.22/month, Turbonomic treats the action as a cost-saving measure and shows estimated savings of $89.79/month.