Microsoft Releases SQL Server 2014 Service Pack 3

Microsoft on Wednesday announced the release of SQL Server 2014 Service Pack 3 (SP3).

SP3 brings new capabilities to Microsoft's relational database management system. It adds "performance, scalability and diagnostics" improvements, according to Microsoft's announcement. The new service pack is arriving about two years after the release of SP2, per Microsoft's lifecycle page.

SP3 is a "cumulative update," which means that it'll upgrade "all editions and service levels of SQL Server 2014 to SQL Server 2014 SP3," Microsoft's support article explained. SP3 contains all past SQL Server 2014 hotfixes, as well.

Microsoft's announcement described a number of improvements brought by SP3. It's a long list, but here's the short version:

  • An improved distribution database cleanup procedure.
  • Improved performance for "change tracking cleanup."
  • Improved query handling based on CPU thresholds.
  • T-SQL syntax support for loading tables other than the "default filegroup."
  • Backup performance improvements for small to medium databases on large-memory machines.
  • Database restore improvements for compressed "4K-sector volumes."

There were other improvements, including Dynamic Management Views (DMV) additions. DMVs show server diagnostic information. For instance, there's a new view to help administrators plan "TempDB sizing" per database version storage requirements. Microsoft also added two new DMVs for monitoring transaction log information.

IT pros may be cheered by getting full dumps (instead of mini-dumps) when "replication agents encounter an unhandled exception." Microsoft is also promising that SP3 will enable the "proper handling of Service Broker" when there's an Availability Group failover as all open connections will now get closed with SP3.

Microsoft's announcement also gave notice that a new Feature Pack for SQL Server 2014 SP3 is expected to arrive sometime in "mid-November 2018." A Feature Pack is a "standalone package" that adds value to the server, according to Microsoft.  

If SP3 is installed, Microsoft advises against later uninstalling it, as there can be problems if the new features that were initially unlocked by SP3 get accessed. Here's how Microsoft's support article expressed the matter:

If you are running the Standard, Web, or Express edition of SQL Server, and you are using some new features that are unlocked only when you start SQL Server 2014 SP3, you might experience errors or see databases left in a suspect state after the uninstallation of SQL Server 2014 SP3. Even worse, if the system databases are using new features (for example, partitioned tables in master databases), this could prevent SQL Server instances from starting after you uninstall SQL Server 2014 SP3.

The support article included links for downloading the 32-bit and 64-bit versions of SQL Server 2014 SP3. The bits also are available from the Microsoft Download Center, the Microsoft Update Catalog, the MSDN download page, the Evaluation Center page, the Volume License Service Center and MBS/Partner Source, Microsoft's announcement indicated.

About the Author

Kurt Mackie is senior news producer for 1105 Media's Converge360 group.


  • Spaceflight Training in the Middle of a Pandemic

    Surprisingly, the worldwide COVID-19 lockdown has hardly slowed down the space training process for Brien. In fact, it has accelerated it.

  • Surface and ARM: Why Microsoft Shouldn't Follow Apple's Lead and Dump Intel

    Microsoft's current Surface flagship, the Surface Pro X, already runs on ARM. But as the ill-fated Surface RT showed, going all-in on ARM never did Microsoft many favors.

  • IT Security Isn't Supposed To Be Easy

    Joey explains why it's worth it to endure a little inconvenience for the long-term benefits of a password manager and multifactor authentication.

  • Microsoft Makes It Easier To Self-Provision PCs via Windows Autopilot When VPNs Are Used

    Microsoft announced this week that the Windows Autopilot service used with Microsoft Intune now supports enrolling devices, even in cases where virtual private networks (VPNs) might get in the way.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.