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.
- 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.