Joey on SQL Server
End of Support: SQL server 2008 and Windows hệ thống 2008 tăng cấp Options
It's not 2008 anymore. Joey details the ins và outs of upgrading these aging Microsoft servers, including licensing changes, support options và potential pitfalls.
It was a simpler time. A decade ago, Windows 7 had just been released và Microsoft introduced new versions of its database và server operating system software.
Both SQL server 2008 and Windows server 2008 had ground-breaking new features like transparent data encryption và data compression, and massive improvements khổng lồ existing features like Windows server Failover Cluster. These products represented big leaps forward và have withstood the thử nghiệm of time for many application stacks.
However, all good things must end. Earlier this summer, SQL vps 2008 và SQL hệ thống 2008 R2 fell out of extended tư vấn from Microsoft. Next January, Windows vps 2008 & Windows server 2008 R2 will go off extended support, as well.
Microsoft, always interested in helping customers move khổng lồ its Azure cloud platform, has offered three additional years of tư vấn -- ending on July 2022 for SQL Server & January 2023 for Windows hệ thống -- khổng lồ give customers time lớn move workloads to Azure. Under this Extended Security Updates (ESU) option, Microsoft will continue to provide security updates for the servers without requiring users to lớn have a migration plan in place, the way it did with Windows hệ thống 2003 support in Azure. The other benefit lớn moving older workloads lớn the cloud is that subsequent migrations can go a lot easier, since the public cloud provides nearly limitless storage & network bandwidth.
If you don"t have the option lớn move lớn Azure và you can"t nâng cấp quickly, be prepared khổng lồ get out your checkbook or run the risk of not having support. What does it mean to not have support? If you hotline Microsoft customer service and tư vấn with a problem, they are going khổng lồ tell you that you have two choices: nâng cấp or pound sand. This is a daunting prospect for many organizations.
This also poses a risk in the event of another major security attack lượt thích Spectre & Meltdown, or any of the various major remote desktop vulnerabilities, or the remote code execution bug in SQL Server. If a bug lượt thích that happens, it is unlikely that Microsoft will issue a patch for versions that are out of support. While you can purchase an ESU subscription, this requires you lớn have Software Assurance on those licenses. In many cases, the reason why a customer is still on an older version is because without Software Assurance, they have no upgrade rights.
For those of you who bởi not have Software Assurance, there is still hope. You can repurchase your existing licenses at current danh mục prices (which, in the case of SQL hệ thống Enterprise Edition, is approximately $7,000 per CPU core), then purchase the software assurance khổng lồ get ESU. Extended tư vấn is an expensive operation.
There are some other options, and Microsoft"s policies in the SQL Server support space have become more user-friendly in recent years. Given the rapid sản phẩm development cycles that the SQL vps teams have pushed since 2014, Microsoft is recommending that software vendors writing applications for SQL hệ thống certify on a compatibility level, rather than a specific version of the software. Support has also been aligned khổng lồ this model, which alleviates the biggest concern around upgrading: performance degradation. Additionally, the Query Store feature that was introduced in SQL Server năm nhâm thìn will allow administrators khổng lồ easily track any queries that have regressed in performance. This mitigates much of the technical risk associated with upgrading.
While the nâng cấp process is better technically (Windows server even supports in-place upgrading of cluster nodes from Windows Server năm 2016 to Windows hệ thống 2019), there are some financial- and vendor-related concerns around upgrading. The financial component is that both SQL Server & Windows hệ thống have changed their licensing models since 2008 to core-based licensing.
On the Windows vps side, this has minimal impact -- until you get over 16 cores, at which point you can incur higher costs. If you have a 2-socket, 24-core server, for example, your Windows server licenses would cost roughly 50 percent more. However, Windows hệ thống licenses are relatively cheap, & are but a rounding error compared lớn SQL vps licensing. SQL vps costs roughly $7,000 per core, plus the cost of Software Assurance, which you typically want to lớn purchase. This means you will really need lớn justify running higher core-count servers.
The vendor-related concerns around upgrading are the biggest limiter I see in the field. Small independent software vendors (ISVs) frequently don"t have the resources to thử nghiệm their applications around new versions of SQL hệ thống or Windows Server, or they wait until well after the latest version is released lớn initiate testing. You have few options in this scenario and none of them are good.
You can pressure the ISV, assuming it is still in business, lớn certify on the version you would lượt thích to use. Your organization should have leverage, since most ISVs charge an annual support fee khổng lồ their customers. You can also "go rogue" and perform the tăng cấp without vendor support. Microsoft offers a tool called the Database Experimentation Assistant (DEA) that will identify any incompatibilities. Of course, you can"t see all the SQL code or Windows libraries that may be in the compiled vendor code, so this option still carries some risks and probably isn"t a good strategy for mission-critical applications.
The final approach is just to stay in place. However, this option is fraught with security và audit risks. With the rapid pace of technical development, having 10-year-old software running critical parts of your enterprise is dangerous & concerning.
It is a challenge to explain to business leaders why they need to lớn spend a decent chunk of money just khổng lồ get on supported versions of software that may not provide significant business value. But in order protect your customers" & your company"s data, you must spend money. This is a good time to lớn recommend moving to Platform as a Service (PaaS) offerings that remove the tăng cấp management from your responsibilities.
Incidentally, Microsoft"s SQL vps team just issued the following heads up regarding SQL hệ thống 2014:
Today we released the final CUs for #SQLServer 2014. No more CUs for that major version of SQL Server.From now on, I don't want lớn see any of you deploying that version. Focus on 2016, 2017 or 2019. Yes, we support 2019 in production. But you need to reach out khổng lồ us 1st.