Compare resource usage month over month

Asset Library / FinOps Use Cases / Compare resource usage month over month

Context

FinOps Practitioners can compare usage and costs across charge periods to identify changes in usage month over month.

FOCUS Columns

FOCUS SQL Query

SELECT 
  MONTH(ChargePeriodStart),
  ProviderName,
  ServiceName,
  ResourceId,
  SkuId,
  ConsumedUnit,
  SUM(ConsumedQuantity) AS TotalConsumedQuantity
FROM focus_data_table
WHERE ChargeCategory='Usage'
  AND ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
  MONTH(ChargePeriodStart),
  ProviderName,
  ServiceName,
  ResourceId,
  SkuId,
  ConsumedUnit
Related KPIs
Total Unpredicted Variance of Spend

Measures the unpredicted variance of cost associated with CSP Cloud usage recorded over a given period of time.

Power Schedule Adherence Rate

Measures the practice of autoscalers or schedulers, or modifying the power state of virtual machines (VMs) or other cloud resources.

Percentage Resource Utilization

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

Percentage of Legacy Resource

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

Percent Storage on Frequent Access Tier

Measure of the percent of object storage stored on a Frequent Access Tier.

Percent of Unused Resources

Measure of unused cloud resources, e.g., unattached storage volumes, load balancers, EIPS, and more.

Auto-scaling Efficiency Rate

Measures effectiveness of an auto-scaling system.

Anomaly-Detected Cost Avoidance

Measures amount of cost avoidance as a result of identifying and correcting an anomaly.

Related Personas
FinOps Practitioner