If your organization is reliant on a rapidly aging version of SQL Server, you may be considering an upgrade. SQL Server experts Michael McCracken from HOSTING and Rodney Landrum, a Microsoft SQL Server MVP, from Ntirety presented the why, what and how of upgrading from Microsoft SQL Server 200X to SQL Server 2014 in a recent webinar Taking the Pain Out of SQL Server Upgrades.

Why upgrade?

  • Microsoft Support End of Life – Every version has an end date for mainstream support and extended Support
  • Feature Additions/Enhancements – New versions often have a large array of new enhancements
  • Performance Enhancements – Microsoft has touted that upgrading to a newer version of SQL Server will improve performance by X amount with no other changes since the earliest versions, mainly due to better use of memory
  • Consolidation/Migration – If you’re not careful you may experience SQL sprawl by having various versions of SQL that you are supporting and maintaining
  • Application Vendor Requirements – Database compatibility levels allow you to migrate your application/database to a newer version of SQL and set your compatibility level back, giving some leeway to vendors who only want to support earlier versions
  • High Availability/Disaster Recovery Features (AlwaysOn) – including Availability Groups and Failover Cluster Instances

 

What to Consider

  • Cost/Licensing – Microsoft changed the game with SQL Server 2012 (per core for Enterprise)
  • Edition Upgrade/Downgrade – Companies may choose to downgrade editions or make more use of virtualization. Or upgrade to take advantage of new features.
  • In-Place or Side-by-Side – Consider the benefits of each while considering downtime, application testing, new feature implementation and risk.
  • Right Sizing Your Infrastructure – Making sure you are right-sized for your workload and not overpaying for cores you don’t need
  • Upgrade Path from SQL Server 2000 – Requires intermediary steps to upgrade to a more recent version

How Hosting/Ntirety will ease the pain

  • Ensure a clean, fast and successful upgrade
  • Help find potential issues before the upgrade using custom tools and upgrade advisor
  • Get you the right edition based on feature usage
  • Ensure application compatibility
  • Make best practices recommendations before and after upgrade

 

To view the full webinar, please click here.