Executive Summary
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.
$68K
Annual Cost
$200K
Annual Savings
194%
Annual ROI
At a Glance
Industry
Market
Publisher
Challenge
Solution
Infrastructure
Challenge
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.
By pairing DBmarlin’s live performance intelligence with the ArxPlatform’s licensing analytics, LicenseFortress delivered both a technical and financial transformation—proving that rightsizing could be achieved safely, systematically, and contractually.
Results
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.
This cross-functional visibility has transformed how the utility approaches software asset management, embedding continuous rightsizing as a standard operating practice rather than a one-time exercise.
Conclusion
Rightsizing that pays for itself—year after year
This engagement illustrates how LicenseFortress empowers customers to unlock sustainable value from their existing investments. By combining its independent licensing expertise with DBmarlin’s real-time performance insight, the company created a closed-loop system for continuous rightsizing and optimization.
The result wasn’t just lower costs—it was a smarter, more transparent, and future-ready SQL Server environment designed to evolve alongside the organization’s cloud strategy.
For enterprises facing similar challenges, the lesson is clear: true optimization happens when performance data and licensing intelligence work together. With the ArxPlatform and its integrated DBmarlin capabilities, LicenseFortress customers can quantify utilization, prove compliance, and make confident rightsizing decisions that deliver lasting ROI.
At a Glance
| Metric | Result |
|---|---|
| Databases Consolidated | 200 → 5 |
| Virtual Machines | 100 → 5 |
| Peak CPU Utilization | ≤ 30% |
| Licensed Cores | 40 → 8 |
| Annual Savings | ≈ $200K |
| Project Cost | $68K/year |
| ROI | ≈ 194% |
| Migration Path | VMware → Azure VMware Service |
About LicenseFortress & Application Performance Ltd.
LicenseFortress delivers software-asset-management services that combine contractual, technical, and legal expertise to help organizations achieve continuous compliance and measurable savings. Through its partnership with Application Performance Ltd., the creators of DBmarlin, LicenseFortress extends the capabilities of the ArxPlatform—linking performance telemetry directly to licensing data.
This integration gives customers the visibility to understand how software behaves in real environments, identify underutilized resources, and make informed rightsizing decisions that stand up to vendor scrutiny.
Turn Performance Insight into Rightsizing Savings
With the ArxPlatform and its DBmarlin integration, LicenseFortress empowers organizations to transform performance data into real licensing savings. By uniting visibility, compliance, and optimization, we help you consolidate workloads, rightsize your environments, and cut costs with confidence.
Discover how LicenseFortress can turn your SQL Server data into your next success story. Book a meeting.