Free cost saving Consultation

Book us for a free 15 minute consultation to discuss how we can lower your Microsoft SQL Server license and opeational costs.

Get in Touch

free-consult

Book a free consultation

Join us for a free, no obligation discussion about how we can reduce your Microsoft SQL Server licensing and operational costs.

We analyse your usage of SQL Server licenses, allocation of licenseable compute resources, efficiency of query workload and feature usage to determine your ideal configuration of SQL Server infrastructure to both minimise cost and maximise performance.

An initial assessment of cost reduction opportunity can usually be provided if you bring a summary of your environment, including a list of systems with installed versions & editions of SQL Server and the current costs based on your licensing model.

Who you will meet with

free-consult
Greg Linwood

Founder & CEO

Founder & CEO. Greg is the founder of MyDBA and was the first Australian awarded Microsoft's Most Valuable Professional, SQL Server in 2003. Greg is passionate about helping others achieve cost effective database excellence and is also interested in piano, history and sports.

free-consult
Glenn Dorling

Practice Manager

Practice Manager, Melbourne. Glenn is a highly experienced database expert with 35+ years profressional experience with the Microsoft and other database platforms. Glenn leads our Melbourne based practice and is also a qualified pharmacist.

free-consult
Shaun Finnegan

Practice Manager

Practice Manager, Sydney. Shaun Finnegan leads our Sydney based practice and has many years experience with the Microsoft SQL Server database platform, with a particular focus on Performance, High Availability and cloud cost management services.

MyDBA's cost reduction methodology

MyDBA's cost reduction methodology looks deeply into the configuration, efficiency & provisioning of your existing Microsoft SQL Server systems, determining the ideal configuration to minimize cost and maximise performance.

To achieve the best results, we use our SQLBench telemetry platform to collect necessary statistics and configuration details including:
Installed systems & their configuration
Provisioned compute resources and their utilization
Query workload efficiency and database table / index structures
Feature edition usage, to identify downgrade opportunities

Example

Below is a typical example of how our cost saving methodology reduces costs.
In this scenario we migrate 5 production SQL Server systems to cloud IaaS VMs, before consolidating them & reducing SQL Server Editions.
Through this process, total operating costs are reduced from $125,400 / year down to $45,260 / year - a saving of $80,140 / year.

1. Starting On-prem systems

  • 5 database servers VMs running in an on premise VMWare infrastructure

  • 1 physical server / VM host, purchase cost $36,000, ammortised over 3 years at $1,000 / month

  • SQL Server is licensed via a Microsoft Enterprise Agreement at $300/month for Enterprise Edition PU Core / pair license pack and $150/month for Standard Edition

  • Virtualization software costs $1,000 / month

  • Data centre racking & power charges are $3,000 / month

  • Infrastructure staffing cost apportioned to this server is $2,000 / month

  • Total infrastructure and licensing costs start at $125,400 / year.

SQL Server VMs
Name CPU RAM Ver Edn Instance GB
PRD01 16 128 2016 Ent (local) 300
PRD02 16 128 2016 Ent (local) 300
FIN01 8 64 2014 Ent (local) 300
WEB01 8 16 2017 Std (local) 300
ITS01 4 8 2019 Std (local) 300
Total: 52 344        
SQL Licensing
Cores Lics Unit Month Year
8 4 $300 $1,200 $14,400
8 4 $300 $1,200 $14,400
4 2 $300 $600 $7,200
4 2 $150 $300 $3,600
2 1 $150 $150 $1,800
        $41,400
Infrastructure
On Prem Cost Month Year Total
Hardware $1,000 $12,000  
Virtualization $1,000 $12,000  
Rack & Power $3,000 $36,000  
Staff $2,000 $24,000  
       
    $84,000 $125,400

2. After "lift & shift" to cloud IaaS VMs

  • Existing VMs are migrated "as is" to cloud IaaS VMs, replacing the previous costs for physical servers, virtualisation software, data center rack & power and IT staff.

  • SQL Server licenses continue to be provisioned under the existing Enterprise Agreement, on a "bring your own license to the cloud" basis.

  • Total infrastructure and licensing costs reduced to $92,646 / year.

SQL Server VMs
Name CPU RAM Ver Edn Instance GB
PRD01 16 128 2016 Ent (local) 300
PRD02 16 128 2016 Ent (local) 300
FIN01 8 64 2014 Ent (local) 300
WEB01 8 16 2017 Std (local) 300
ITS01 4 8 2019 Std (local) 300
Total: 52 344        
SQL Licensing
Cores Lics Unit Month Year
8 4 $300 $1,200 $14,400
8 4 $300 $1,200 $14,400
4 2 $300 $600 $7,200
4 2 $150 $300 $3,600
2 1 $150 $150 $1,800
        $41,400
Infrastructure
Type Hour Day Month Year Total
16.128xl $1.9 $46 $1,387 $16,644 $31,044
16.128xl $1.9 $46 $1,387 $16,644 $31,044
8.64xl $1.0 $24 $730 $8,760 $15,960
8.16xl $0.7 $17 $511 $6,132 $9,732
4.8xl $0.4 $8 $256 $3,066 $4,866
        $51,246 $92,646

3. After consolidation, utilization adjustment and tuning.

  • SQL Server instances are consolidated from 5 dedicated IaaS VMs down to 2 shared IaaS VMs.

  • Under-utilized CPU and memory resources are identified and reduced from 52 to 36 vCPUs and 344GB to 288GB RAM, reducing IaaS VM costs from $52,246 to $30,660.

  • Reduction in CPU & memory resources also reduces reportable SQL Server licenses under Enterprise Agreement from $41,400 / year down to $30,600 / year.

  • Total infrastructure and licensing costs reduced to $61,260 / year.

SQL Server VMs
Name CPU RAM Ver Edn Instance GB
PRDEnt 32 256 2016 Ent .\PRD01 300
      2016 Ent .\PRD02 300
      2014 Ent .\FIN01 300
PRDStd 4 32 2017 Std .\WEB01 300
      2019 Std .\ITS01 300
Total: 36 288        
SQL Licensing
Cores Lics Unit Month Year
16 8 $300 $2,400 $28,800
       
       
2 1 $150 $150 1,800
         
        $30,600
Infrastructure
Type Hour Day Month Year Total
32.256xl $3.0 $72 $2,190 $26,280 $55,080
       
       
4.32xl $0.5 $12 $365 4,380 6,180
           
        $30,660 $61,260

4. After SQL Server editions downgraded

  • Review of feature usage identified that no Enterprise Edition features are in use.

  • All three Enterprise Edition instances are downgraded to Standard Edition

  • Both Standard Edition instances are downgraded to Web Edition, which is available in cloud IaaS VMs

  • SQL Server licenses are reduced from $30,600 / year down to $15,300 / year.

  • Total infrastructure and licensing costs reduced to $45,360 / year.

SQL Server VMs
Name CPU RAM Ver Edn Instance GB
PRDEnt 32 256 2016 Std .\PRD01 300
      2016 Std .\PRD02 300
      2014 Std .\FIN01 300
PRDStd 4 32 2017 Web .\WEB01 300
      2019 Web .\ITS01 300
Total: 36 288        
SQL Licensing
Cores Lics Unit Month Year
16 8 $150 $1,200 $14,400
         
       
2 1 $75 $75 $900
         
        $15,300
Infrastructure
Type Hour Day Month Year Total
32.256xl $3.0 $72 $2,190 $26,280 $40,680
           
           
4.32xl $0.5 $12 $365 $4,380 $5,280
           
        $30,660 $45,360