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.
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
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
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.
Turbonomic treats the action as an investment and shows an estimated investment of $17.52/month.
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
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.