Note This article serves as a single source of information to locate all documentation that is related to this service pack. It includes all the information that you previously found in the release notes and Readme.txt files.
How to obtain SQL Server 2012 SP4SQL Server 2012 SP4, Microsoft SQL Server 2012 SP4 Express, and Microsoft SQL Server 2012 SP4 Feature Pack are available for manual download and installation at the following Microsoft Download Center websites.
|SQL Server 2012 SP4||Download the package now.|
|SQL Server 2012 SP4 Express||Download the package now.|
|Microsoft SQL Server 2012 SP4 Feature Pack||Download the package now.|
Note After you install the service pack, the SQL Server service version should be 11.0.7001.0. Microsoft SQL Server 2012 service packs are cumulative updates. SQL Server 2012 SP4 upgrades all editions and service levels of SQL Server 2012 to SQL Server 2012 SP4.
For more information about the cumulative updates that are available in SQL Server 2012, see SQL Server 2012 build versions.
List of enhancements and fixes included in SQL Server 2012 SP4Note Besides the listed updates, additional changes may also be included in this service pack. You may receive documentation in the future.
Enhancements and new capabilitiesSQL Server 2012 Service Pack 4 provides additional updates to improve performance, scalability, and monitoring. Key updates include:
- Scalability and performance improvements for the storage engine
- Improvements in consistency check performance
- Query hints to provide granular control while using Resource Governor
- Additional monitoring capabilities through enhancements in DMV, Extended Events, and Query Plans
- Improved performance while opening and reading XEL files by using the XEvent Linq reader
- Improved performance for spatial queries
Additional resolutionsResolutions to the following issues are also included in SQL Server 2012 SP4.
|VSTS bug number||Description|
|9842082||Include the table name and the primary key for error 20598 in the MSdistribution_history table.|
|9654797||Provide a method to discover the TLS/SSL protocol used by the client connection|
Select the correct file to download and installThe SQL Server 2012 SP4 download page contains the system requirements for installing SQL Server 2012 SP4 and basic installation instructions. For additional documentation about how to upgrade installed 2012 SP4 components with a SQL Server 2012 servicing update, see "Install SQL Server 2012 servicing updates."
For more information about how to upgrade your SQL Server installation to SQL Server 2012 SP4, see Supported Version and Edition Upgrades.
Article ID: 4018073 - Last Review: Oct 5, 2017 - Revision: 28