[Corestack] Downsize databases in Azure
The platform identifies oversized databases in Azure environments and recommends downsizing opportunities. Maintaining oversized databases leads to unnecessary resource consumption, increased costs, and higher environmental impact.
Recommendation Impact Across KPIs
| KPI | Impact | Calculated? |
|---|---|---|
| Reliability: | No impact identified | ❌ |
| Security Compliance: | No impact identified | ❌ |
| Economic: | No impact identified | ❌ |
| User Experience: | No impact identified | ❌ |
| Environment: | Reduction in carbon footprint calculated as: Current DB Carbon Usage - New Recommended DB Carbon Usage / Total Carbon Usage of all assets | ✅ |
Score Calculation
1. Data Ingestion
- Database instance name
- Current database size
- Current resource utilization
- Carbon usage metrics
2. Data Enrichment
- Mapping to Azure resource metrics
- Recommended database size
- Carbon usage optimization potential
3. Health Score
- Calculate the Environmental Health score based on potential carbon reduction
- Score derived from the ratio of potential carbon savings to total carbon usage
Example Graph
This recommendation is an update to KPI pillar scoring - visualization not applicable for this update.
Business Opportunities
Product Sales Opportunity
Not applicable - This is an update to KPI pillar scoring referring to original recommendation ID.
Professional Services Opportunity
Not applicable - This is an update to KPI pillar scoring referring to original recommendation ID.
Remediation Guidance
Not applicable - This is an update to KPI pillar scoring referring to original recommendation ID.
Supporting Information
Supported Data Sources
- Azure Advisor
- CoreStack
Recommendation Categorisation
- Database Optimization
- Resource Management
- Environmental Impact
Supported Instances
- Azure SQL Database
- Azure Managed Instance
- Azure Synapse Analytics
Planned Instances
- Azure Database for PostgreSQL
- Azure Database for MySQL
- Azure Cosmos DB
Note: This recommendation focuses on environmental impact calculation updates for database sizing in Azure environments.