optimize your sql server 2008/r2 migrationdh2i.com/wp-content/uploads/18-08-01-sql-server... ·...

Optimize Your SQL Server 2008/R2 Migrationfor Cost and [email protected]

Microsoft Support for SQL Server

• Years 0-5: Mainstream Support» “Security and functional issue resolution”

• Years 6-10: Extended Support» “Security or critical functional issues”

• Years 11-16: Premium Assurance (new in 2017)» “Optional paid extension to Extended Support”

» Requires SA

» Costs from 5% to 12% of the current licensing cost for each year of coverage

DH2i.com | [email protected] | 970.295.4505

DH2i All Rights Reserved ©20182

SQL Server 2008 & 2008 R2End of Extended Support is 7/9/2019

• End-of-Support Options» Purchase Premium Assurance» Do nothing and risk security, regulatory, and

compliance issues» Upgrade before the deadline



Considerations If You’re Upgrading…

• Target version/edition of SQL Server & OS

• Hardware refresh

• Budget

• Cloud

• Software Assurance

• HA/DR options / requirements

• Number of cores to buy / renew

• Scheduling – testing & migration downtime



Considerations Help Set Upgrade Objectives

• Minimize cost» Fewest cores possible» Least expensive Edition

• Meets feature & performance requirements• Highest availability / DR capabilities• Least disruptive upgrades



DH2i’s DxEnterprise Low-Downtime Upgrade Tool & Optimized Landing Zone



• SQL Server management tool• Built-in HA/DR• Minimize cores subject to

upgrade/renewal• Avoid Enterprise Edition• Facilitate migration to newer

OS/SQL version with least downtime

DxEnterprise is Workload Mobility



Move any SQL Server instance,Docker container, service, or file share…

…from any host to anyhost, anywhere, anytime…

…all with data persistence

DxEnterprise® HA and DR Protection



• Automated HA w/ Smart Availability™ » Automated protection from: infrastructure, OS,

application binaries, and configuration faults; and most pilot errors

» SLA assurance with application-based QoS

• Disaster recovery and resilience » Simple orchestrated low RTO multi-subnet DR

» Data replication mechanism is your choice

Any Infrastructure, Any Mix



• HA & portability for any SQL Server instance, Docker container, windows service, or file share » 2008R2-2016 Windows Server OS, any

edition» RHEL/CentOS 7+, Ubuntu 16+» 2005-2017 SQL Server, any edition» Any Docker container» Physical, virtual & cloud» Shared and/or replicated storage

• Infrastructure independence & easy modernization » Simple OS, application and infrastructure

modernization» No vendor or infrastructure lock-in

Unparallelled Cost and Complexity Reduction



• Most efficient consolidation» Lightest weight mobility

» Stack instances and containers

• Average 5-15 per server

• Customers save on average 25-60%» Fewer servers to license

» Avoid premium software editions/SA

» Reclaim licenses for future use



DxEnterprise Demo

• Install DxEnterprise on existing servers

• Add a 2008 R2 instance under management

• Fail instance over into new SQL and OS version

• Show stacked instances for consolidation & cost savings

12

Minimal Pre-requisites



• Meet minimum system requirements

• Nodes must be able to ping each

other

» IP addresses must be bind-able to

an adapter

» Interfaces can not auto update DNS

• .NET 4.x installed on host

• Firewall exception 7979-7983

• All nodes for any workload must have

access to shared &/or replicated disk

14

Q&A



Free trial: http://dh2i.com/trial/

Demo: http://dh2i.com/demo/

http://dh2i.com/trial/

http://dh2i.com/demo/

DxAG for SQL Server Availability Groups



• Easier clustering than WSFC or Pacemaker» Simpler to set up, simpler to manage» Makes provisioning of your AGs easier

• CLUSTER_TYPE = EXTERNAL• Physical, virtual, and cloud servers• Supports:

» WS 2012+» RHEL/CentOS 7+» Ubuntu 16+» SQL Server 2017+

• Mix infrastructure, platforms, and distros• Manage HA instances alongside AGs

optimize your sql server 2008/r2 migrationdh2i.com/wp-content/uploads/18-08-01-sql-server... ·...

Documents