Utility Cuts Licensing Costs 80% Rightsizing SQL Server with LicenseFortress + DBmarlin Integration

A large public utility provider that previously worked with LicenseFortress to resolve an $84 million Oracle compliance exposure has once again realized major cost savings—this time by rightsizing its Microsoft SQL Server environment.

After years of steady growth and scattered deployments, the company found itself maintaining more than 200 databases across 100 virtual machines (VMs)—each carrying a minimum licensing requirement under Microsoft's core-based model. By engaging LicenseFortress and leveraging its partnership with Application Performance Ltd., the provider combined licensing intelligence from the ArxPlatform with performance data from DBmarlin, a database monitoring solution developed by Application Performance.

This powerful integration enabled the team to safely rightsize workloads, optimize CPU allocation, and align licensed cores with real utilization. The result: an 80% reduction in SQL Server Enterprise Edition cores, nearly $200,000 in annual savings, and a streamlined path to Azure VMware Service (AVS) migration.

Uncontrolled SQL Server sprawl inflating licensing costs

Following their Oracle victory, the organization sought to apply the same discipline to its Microsoft licensing. Over time, departmental silos had created a sprawling SQL Server estate: hundreds of lightly used databases running on isolated VMs.

While this setup simplified application ownership, it introduced major inefficiencies. Under Microsoft's core-based licensing model, each VM required at least four licensed cores of SQL Server Enterprise Edition – even if it consumed only a fraction of that capacity.

Compounding the issue, the company lacked consolidated visibility into performance metrics across servers. Each database team managed its own environment with minimal shared insight into actual CPU utilization. Without accurate data, every attempt to reduce core counts carried perceived operational risk.

With an upcoming Enterprise Agreement renewal and a planned transition to Azure VMware Service, leadership recognized that optimizing its SQL Server footprint was both a financial and strategic imperative.

Integrating performance insight with licensing intelligence to drive rightsizing decisions

The provider re-engaged LicenseFortress to conduct a comprehensive optimization and rightsizing review. This initiative marked one of the first full deployments of DBmarlin integrated within the ArxPlatform—a collaboration between LicenseFortress and its technology partner, Application Performance Ltd.

How DBmarlin Works

DBmarlin is a modern database performance-monitoring tool that provides deep visibility into query behavior, CPU usage, I/O patterns, and wait events across SQL Server, Oracle, and other platforms. Within the ArxPlatform, it extends monitoring beyond compliance—helping organizations correlate performance data directly with licensing consumption.

By capturing precise workload metrics, DBmarlin enables LicenseFortress analysts to distinguish between performance-critical cores and idle capacity. This insight transforms licensing management from static entitlement tracking into a dynamic, data-driven rightsizing process.

Establishing the Baseline

Using DBmarlin, LicenseFortress collected detailed performance telemetry across two production clusters and one disaster-recovery environment. Analysis over a five-day period revealed that average CPU utilization was consistently below 20%, with peak usage rarely exceeding 30%.

These findings confirmed that the SQL Server estate was dramatically over-licensed compared to actual workload demand—an ideal candidate for rightsizing.

Modeling Licensing Scenarios

The LicenseFortress team used the ArxPlatform's entitlement engine to model core-reduction and consolidation options based on the DBmarlin data. Each scenario was evaluated for both technical performance and contractual compliance under Microsoft's Enterprise Edition terms.

The results guided a phased approach:

• Phase 1 (On-Premises Rightsizing): Reduce virtual cores from 20 to 8 per production node, cutting licensed cores from 40 to 16 while maintaining system responsiveness.
• Phase 2 (Post-Migration to AVS): Further reduction to 6 cores per node in the Azure VMware environment, decreasing total licensed cores to 12.

This phased execution allowed IT teams to validate end-user performance at each stage using DBmarlin's real-time metrics before committing to additional rightsizing actions.

Iterative Rightsizing and Consolidation

As confidence in the monitoring data grew, the team extended the initiative beyond core tuning to full workload rightsizing. Guided by DBmarlin's per-instance telemetry, the organization grouped databases with similar load profiles and gradually merged them onto fewer VMs.

Over successive rightsizing cycles, more than 200 databases were consolidated into just five VMs. Each iteration halved the footprint while maintaining service-level agreements and improving overall resource efficiency.

80% fewer licensed cores and sustained 194% ROI through rightsizing

The collaboration yielded measurable results across financial, technical, and operational domains.

Financial Impact

By aligning licensed cores to actual workload consumption, the organization reduced its SQL Server Enterprise Edition licensing exposure by approximately 80%—from 40 cores down to 8 in active production.

At Microsoft's list pricing, that represents nearly $200,000 in annual cost avoidance—savings that will continue in future Enterprise Agreement renewals and Software Assurance cycles.

Technical Efficiency

With over 200 databases now running on five high-efficiency VMs, CPU utilization averages remain below 30% while application performance has remained stable or improved. DBmarlin's granular analytics helped isolate bottlenecks during testing, ensuring no degradation in query response times despite aggressive rightsizing.

The streamlined infrastructure also reduced patching windows, improved backup consistency, and simplified disaster-recovery validation.

Operational Advancement

The integration of DBmarlin into the ArxPlatform provided the IT organization with unified dashboards for both compliance and performance. For the first time, the licensing, infrastructure, and application teams shared a single source of truth—bridging the gap between cost management and system reliability.