Cumulative Update 6 for SQL Server 2014 SP1
Note You can install the new build on top of the deprecated build.
More information about deprecation of the older build
With Cumulative Update 6 (build number 12.0.4449.0), if you are running workload patterns that include parallel SELECT(…)WITH NOLOCK, under the default SQL Server lock-based isolation level or a higher level, you may encounter queries that experience blocking issues or deadlocks.
The patterns that are exposed to this blocking issue include the following:
- Executing a parallelized SELECT (…) INTO Table FROM SourceTable statement, and specifically using the NOLOCK hint, under the default SQL Server lock-based isolation level or higher. In this scenario, other queries that try to access SourceTable will be blocked.
- While one transaction is holding an exclusive lock on an object (for example, an ongoing table update), another transaction is executing parallelized SELECT (…) FROM SourceTable by using the NOLOCK hint. In this scenario, the SELECT query that is trying to access SourceTable will be blocked.
To find the current version of SQL Server that you have installed, see How to determine the version, edition and update level of SQL Server and its components.
Note After future Cumulative Updates are released for SQL Server 2014 Service Pack 1, this CU can be located and downloaded from the Microsoft Windows Update Catalog. However, Microsoft recommends that you install the latest cumulative update available.
Hybrid environments deployment
- SQL Server failover cluster rolling update and service pack process.
Note If you do not want to use the rolling update process, follow these steps to apply a CU or SP:
- Install the service pack on the passive node.
- Install the service pack on the active node (requires a service restart).
- Upgrade and update of availability group servers that use minimal downtime and data loss.
Note If you enabled AlwaysOn with SSISDB catalog, see the information about SSIS with AlwaysOn for more information about how to apply a CU or SP in these environments.
- How to apply a hotfix for SQL Server in a transactional replication and database mirroring topology
- How to apply a hotfix for SQL Server in a replication topology
- How to install service packs and hotfixes on an instance of SQL Server that is configured to use database mirroring
- Overview of SQL Server Servicing Installation
PrerequisitesTo apply this cumulative update package, you must be running SQL Server 2014 SP1.
Restart informationYou may have to restart the computer after you apply this cumulative update package.
Registry informationTo use one of the hotfixes in this package, you do not have to make any changes to the registry.
- Announcing updates to the SQL Server Incremental Servicing Model (ISM)
- How to obtain the latest service pack for SQL Server 2014
- The Incremental Servicing Model for SQL Server to deliver hotfixes for reported problems
- Naming schema for Microsoft SQL Server software update packages
- Description of the standard terminology that is used to describe Microsoft software updates
Article ID: 3144524 - Last Review: Nov 29, 2016 - Revision: 1