This work is licensed under CC BY 4.0 - Read how use or adaptation requires attribution
Early Bird registration is available for FinOps X Europe 2024

Analyze cost per compute service for a subaccount

Asset Library / FinOps Use Cases / Analyze cost per compute service for a subaccount

Context

Compute spend tends to be the largest component of spend in most cloud bills. Drilling into the resource-level view of cost for a given day can provide a detailed view of the heaviest spending compute resources, including a view of which time periods the consumption was at its highest level.

FOCUS Columns

SQL Query

SELECT
  Min(ChargePeriodStart),
  Max(ChargePeriodEnd),
  ServiceName,
  ResourceId,
  ResourceName,
  SUM(PricingQuantity),
  SUM(EffectiveCost) AS MonthlyEffectiveCost
FROM focus_data_table
WHERE SubAccountId = ?
  AND ServiceCategory = 'Compute'
  AND ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
  ServiceName,
  ResourceId,
  ResourceName
ORDER BY MonthlyEffectiveCost DESC
Related KPIs
Effective Average Compute Cost per Core

Track average cost, after amortization of unused commitment discounts, of each Core per calendar month.

Percent of Compute Spend Covered by Commitment Discounts

Measures the percentage of compute cost (excluding Spot) covered by commitment discount for the previous month.

Percentage of Legacy Resource

Measure of the percentage of resources running on 'modern' types (e.g. instance types, volume type).

Percentage Resource Utilization

Measure of cloud compute resource utilization, e.g. Compute (EC2), Block Storage (EBS), or Object Storage (S3).

Related Personas
Engineering
Related Capabilities
Workload Optimization