AKAWN® LIMITED

SQL Server specialists

SQL Server 2012

The below table reflects the builds released for SQL Server 2012 as well as key comments that relate to the build where appropriate.

 

The current recommended Build is 11.0.6598.0 (SP3 with SP3_CU9).

 

Patch Build Type* Released Comment
SP3_CU9 11.0.6598.0 CU 2017 May Contains 10 fixes.
 
Transaction log backup failure on the secondary replica in SQL Server 2012 Always-On Availability Groups fix.
 
Can’t grant permissions to another user to log in to an availability group after the owner is removed in SQL Server 2012 fix.
SP3_CU8 11.0.6594.0 CU 2017 Mar Contains 10+ fixes.
SP3_CU7 11.0.6579.0 CU 2017 Jan Contains 10+ fixes and MS15-058.

Always On secondary replica goes into a disconnecting state fix.

The Target Recovery Time of a database set to a nonzero value causes an assertion and a lease timeout fix.

Cannot save the SSRS report after you change a parameter in Report Builder or the SQL Server Data Tool fix.

On failover, the new secondary replica stops accepting transaction log records until the instance is restarted fix.

Assert memory dump on a mirror server fix.

Changing the data type and then updating the table with more than 4,000 records causes database corruption fix.
SP2_CU16 11.0.5678.0 CU 2017 Jan Last CU patch for SP2.

Contains 4 fixes.
SP3_CU6 11.0.6567.0 CU 2016 Nov Note: SP3 CU6 was also released as MS16-136 and hence has the same build number.
SP2_CU15 11.0.5676.0 CU 2016 Nov Note: SP2 CU15 was also released as MS16-136 and hence has the same build number.
MS16-136 11.0.6567.0 CU 2016 Nov For use with CU path builds 11.0.6020.0 to 11.0.6544.0
MS16-136 11.0.6248.0 GDR 2016 Nov For use with GDR path build 11.0.6020.0
MS16-136 11.0.5676.0 CU 2016 Nov For use with CU path builds 11.0.5058.0 to 11.0.5657.0
MS16-136 11.0.5388.0 GDR 2016 Nov For use with GDR path builds 11.0.5058.0 or 11.0.5343.0
SP3_CU5 11.0.6544.0 CU 2016 Sep Contains 18 fixes.

SQL Server crashes with an access violation when you use the TRY…CATCH construct for bulk copy fix.

Assertion failures occur when you query sys.dm_hadr_database_replica_states fix.

CPU usage increases significantly when you execute queries that contain CHANGETABLE functions in SP3 CU1 fix.

High CPU usage on SQL queries after you install SP3 fix.

Queries that run against secondary databases always get recompiled fix.

SQL Server crashes because of an access violation error that occurs while it reads data from an event file target fix.

Unexpected growth of tempdb data files when using SQL Server Service Broker fix.

“The log backup chain is broken” error when the log backup process fails fix.

Operating system error 32 when you restore a database in SQL Server 2014 or 2016 fix.
SP2_CU14 11.0.5657.0 CU 2016 Sep Contains 1 fix.
SP3_CU4 11.0.6540.0 CU 2016 Jul Contains 20 fixes.

SQL Server crashes when you run a remote query in a stored procedure fix.

Back up data or log files to a network share fix.

RDL report that’s generated programmatically fix.

Performance of Analysis Services in Multidimensional mode fix.

Shared data sources and stored credentials are removed by the SharePoint daily cleanup jobs in SSRS fix.

Memory leak on the AlwaysOn secondary replica when change tracking is enabled in SQL Server fix.

Transaction log backup failure on the secondary replica prevents subsequent backups on Availability Replicas fix.

SQL Server 2012 failover cluster diagnostic log doesn’t accurately reflect the failure_condition_level setting fix.

DBCC CHECKDB doesn’t report metadata inconsistency of invalid filegroups in its summary fix.

Sqlps utility fails to run when the “Turn on Script Execution” policy is set to “Allow all scripts” in SQL Server fix.
SP2_CU13 11.0.5655.0 CU 2016 Jul Contains 6 fixes.

Log backup process fix.
SP3_CU3 11.0.6537.0 CU 2016 May Contains 20+ fixes.

SecurityAdmin server-level role or the View Server State permission allows execution of the sp_readerrorlog and sp_enumerrorlogs stored procedures fix.

Filestream directory is not visible after an AlwaysOn replica is restarted fix.

Versioning cleanup task on the AlwaysOn secondary replica fix.

FileTables in an AlwaysOn availability group become unavailable after failover fix.

sys.dm_db_index_usage_stats missing information after index rebuild fix.

Incorrect page numbers are displayed when you export an SSRS report to PDF or TIFF format fix.

Memory corruption causes an access violation fix.

Shared data sources and stored credentials are removed by the SharePoint daily cleanup jobs in SSRS fix.
SP2_CU12 11.0.5649.0 CU 2016 May Contains 7 fixes.

Memory leak on the AlwaysOn secondary replica when change tracking is enabled fix.

Versioning cleanup task on the AlwaysOn secondary replica fix.

Replication Log Reader Agent fix.
SP3_CU2 11.0.6523.0 CU 2016 Mar Contains 10+ fixes.

Cursor on a table variable fix.

AlwaysOn Availability Groups fix.

tempdb fix.

Column data is deleted when you update another column in a table fix.

Service master key (SMK) fix.

xp_logininfo fix.

Certificate backup fix.

XA transactions fix. Also requires trace flag TF3924.

Partition schemes, functions, full-text fix.

Transactional replication fix.

Replication fix.

Reporting Services print fix.

INSTEAD OF trigger with contained database fix.

Change Data Capture for Oracle by Attunity fix.

Extended events fix.
SP2_CU11 11.0.5646.0 CU 2016 Mar Contains 10+ fixes.

tempdb fix.

AlwaysOn Availability Groups fix.

Certificate backup fix.

Cursor on a table variable fix.

XA transactions fix. Also requires trace flag TF3924.
SP3_CU1 11.0.6518.0 QFE 2016 Jan Contains 6 fixes.

SQL Server crash fix.

tempdb fix.

Trace flag 6533 fix.

Allow use of the -k startup parameter to control the rate at which work files can spill to tempdb.


Change tracking fix.
SP2_CU10 11.0.5644.2 QFE 2016 Jan Contains 10 fixes.

xp_logininfo fix.

tempdb fix.

Delete fix.

Transactional Replication fix.

Service Master Key fix.
SP3 11.0.6020.0 GDR 2015 Nov Includes all CUs up to and including SP2 CU9.

New showplan XML attribute Actual Rows Read.

New query memory grant options min_grant_percent and max_grant_percent.

Improvements for Microsoft SQL Server AlwaysOn Lease Timeout supportability.

Improved tempdb spill diagnostics in Showplan XML schema and Extended Events.

Improved memory grant diagnostics using Extended Events and dm_exec_query_stats.

DBCC CHECKDB/CHECKTABLE fix.

AlwaysOn availability groups fix.

Import and Export Wizard fix.

XEvent Linq reader fix.
SP2_CU9 11.0.5641.0 QFE 2015 Nov Contains 10+ fixes.

TDE fix1 and fix2.

Database mirroring mirror instance I/O fix.

SQLTables function and sp_tables stored procedure don’t require SELECT permission fix.

Change tracking backup fix.

Connection pooling performance fix.

Service Broker fix and enhancement.
SP2_CU8 11.0.5634.1 QFE 2015 Sep Contains 20+ fixes.

AlwaysOn Availability Groups stalled dispatcher fix.

sqlcmd fix. Trace flag 7833 is introduced in this CU and can revert the sqlcmd behaviour.

Analysis Services in Tabular mode performance fix.

PowerPivot for SharePoint fix.

Sort operator leading to slow query execution fix. After applying CU, trace flag 7470 makes SQL Server consider internal data management memory overhead when calculating the required memory for a sort; however this flag may impact memory availability for concurrent queries.

Analysis Services security fix.

Reporting Services Word page orientation fix.

FileStream with AlwaysOn Availability Groups fix.

Transparent Data Encryption certificate creation fix.

Parallel query with columnstore index fix.

DBCC CHECKDB performance fix.

AlwaysOn Availability Groups Access violation fix.

FileTable Access violation fix.

Peer-to-peer replication fix.

Virtual address space (VAS) fix.

SQLDiag fix.

AlwaysOn Availability Groups Scheduler deadlock during replica removal fix.

Service master key creation failure fix.

AlwaysOn Availability Groups transaction log file fix.
SP2_CU7 11.0.5623.0 QFE 2015 Jul Contains 30+ fixes including MS15-058.

SELECT @@VERSION now shows the build name i.e. for this release you will see (SP2-CU7). This information is also now shown in the SQL Server errorlog file.

Multiple change data capture fixes.

SQL Server Management Studio (SSMS) and SQL Server Management Objects (SMO) fix when restoring a differential backup.

Indexed views fix.

Schema lock fix.

Single-user mode fix.

sp_estimate_data_compression_savings fix.

Virtual address space (VAS) fix. Also requires trace flag 8075.

Resource database fix.

Full text fix.

CMEMTHREAD waits fix.

SQL Server Analysis Services (SSAS) crash fix.

Merge replication fix.

Reporting Services MS13-088 fix.

sys.dm_xe_objects fix.

max_worker_threads fix.
MS15-058 11.0.5613.0 QFE 2015 Jul Use with SP2 QFE builds between and including 11.0.3437.0 to 11.0.5592.0.
MS15-058 11.0.5343.0 GDR 2015 Jul Use if SP2 GDR build is 11.0.5058.0.
MS15-058 11.0.3513.0 QFE 2015 Jul Use with SP1 QFE builds between and including 11.0.3321.0 to 11.0.3492.0.
MS15-058 11.0.3156.0 GDR 2015 Jul Use with SP1 GDR builds between and including 11.0.3000.00 to 11.0.3153.0.
SP2_CU6 11.0.5592.0 QFE 2015 May Contains 20+ fixes.

Introduces trace flag 6534 for a spatial LineString issue.

Change Data Capture (CDC) Service for Oracle by Attunity fix.

BCP crash fix.

AlwaysOn Availability Groups corruption fix.

Service broker causing SQL Server to shut down fix.

Introduces trace flag 7311 for changing Oracle NUMBER type precision/scale.

SSAS crash fix.

Transport Layer Security protocol version 1.2 fix.
SP1_CU16 11.0.3492.0 QFE 2015 May This is the final CU for SQL Server 2012 Service Pack 1. SQL Server 2012 SP1 exits mainstream support on 14 July 2015.

Contains 4 fixes.
SP2_CU5 11.0.5582.0 QFE 2015 Mar Contains 20+ fixes.

SOS_CACHESTORE spinlock fix.

USERSTORE_SCHEMAMGR memory leak fix.

AlwaysOn availability groups may be reported as NOT SYNCHRONIZING after you apply SQL Server 2012 SP2 CU3 or CU4 fix.

Complex parallel query deadlock fix.

AlwaysOn Availability Groups secondary replica backup restore fix.

SQL Server 2012 SP2 CU3 Report Designer and Report Builder tablix fix.

sqlncli11.dll ODBC driver fix.

sys.dm_exec_procedure_stats access violation fix.

DBCC CHECKDB fix.
SP1_CU15 11.0.3487.0 QFE 2015 Mar Contains 1 fix.
SP2_CU4 11.0.5569.0 QFE 2015 Jan Contains 36 fixes.

Contains AlwaysOn Availability Group bug.

Contains Reporting Services bug.

Keep index online while reindexing checkbox in the Maintenance Plan Wizard fix.

Introduces the trace flag 6531 to indicate to the SQLOS hosting layer that the spatial data type should avoid preemptive protections.

Discusses using trace flag 669 to prevent user queries from queuing requests to the ghost cleanup process.
SP1_CU14 11.0.3486.0 QFE 2015 Jan Contains 8 fixes.

Discusses using trace flag 174 to increase the available buckets for the SQL Server plan cache from 40,009 to 160,001 on 64-bit systems.

Discusses using trace flag 669 to prevent user queries from queuing requests to the ghost cleanup process.
SP2_CU3 11.0.5556.0 QFE 2014 Nov Contains 34 fixes.

Contains AlwaysOn Availability Group bug.

Contains Reporting Services bug.

Online index rebuild of clustered index with a sparse column fix.

cdc.fn_cdc_get_net_changes_ query fix.

IncludeLinkInfo registry key mention.

Non-yielding Scheduler fix.

AlwaysOn Availability Groups fix.

SQL statement hash for logging XEvent fix.

SSIS OLE DB source fix.

Database backup and restore fix.

Statistics update on sql_variant data type fix.

sys.dm_hadr_database_replica_states fix.
SP1_CU13 11.0.3482.0 QFE 2014 Nov Contains 10 fixes.

Set management data warehouse to exclude system databases from a Query Statistics collection set fix.

Error: 608 Severity: 16 Sate: 1 fix.

Introduces trace flag 6531 which indicates to the SQLOS hosting layer that the spatial data type should avoid preemptive protections.

Microsoft Office 15.0 Access Database Engine OLE DB Provider fix.
SP2_CU2 11.0.5548.0 QFE 2014 Sep This release cannot install the SQL Writer update when the SQL Server is a non-English version.

Contains 50 fixes.

AlwaysOn availability groups rebuild index cache memory and high cpu fix.

WITH RECOMPILE returning incorrect information fix.

XEvent memory leak fix.

ALTER INDEX REORGANIZE WITH (LOB_COMPACTION = ON) and DBCC SHRINKDATABASE / DBCC SHRINKFILE fix.

Killing sequence object blocked session stops SQL Server process fix.

Introduces trace flag 3448 which assists with a database mirroring manual failover issue.

UPDATE STATISTICS with columnstore index fix.

AlwaysOn Availability Groups synchronous-commit mode performance fix.

AlwaysOn case-sensitive secondary database Volume Shadow Copy Service (VSS) backup fix.

PowerShell Invoke-Sqlcmd commandlet fix.

Missing rows with merge join from Oracle linked server fix.
SP1_CU12 11.0.3470.0 QFE 2014 Sep Contains 14 fixes.

Introduces trace flag 647 which forces pre SQL Server 2012 backward compatibility behavior for handling when a column containing rows close to 8,060 bytes is added to a table and prevents failures due to data integrity full table scans.
MS14-044 11.0.3460.0 QFE 2014 Aug Use with SP1 QFE path. SP2 onwards is not affected.
Note: there is an issue with this QFE.
MS14-044 11.0.3153.0 GDR 2014 Aug Use with SP1 GDR path. SP2 onwards is not affected.
SP2_CU1 11.0.5532.0 QFE 2014 Jul Contains 40+ fixes.

Fix for Enterprise edition – Addresses potential data loss in a clustered index when you run online build index in parallel mode. The work around for this issue is to run the online index build in serial mode (DOP = 1).

Select into temporary table operation, poor performance fix.

Parallelism fix.
SP1_CU11 11.0.3449.0 QFE 2014 Jul Contains 30+ fixes.

Fix for Enterprise edition – addresses potential data loss in a clustered index when you run online build index in parallel mode. The work around for this issue is to run the online index build in serial mode (DOP = 1).

Introduces trace flag 3448 which forces new connections to keep checking for the database state every two seconds instead of waiting for a lock for infinite time.

SP2+Fix 11.0.5532.0 QFE 2014 Jun Fix for Enterprise edition. Addresses potential data loss in a clustered index when you run online build index in parallel mode.
The work around for this issue is to run the online index build in serial mode (DOP = 1).
SP1+Fix 11.0.3437.0 QFE 2014 Jun Fix for Enterprise edition. Addresses potential data loss in a clustered index when you run online build index in parallel mode.
The work around for this issue is to run the online index build in serial mode (DOP = 1).
SP2 11.0.5058.0 SP 2014 Jun Contains up to and including SQL Server 2012 Service Pack1 Cumulative Update 9 (CU9).
Introduces trace flag 2453 ‘allows the query optimizer to use information about the number of rows inserted into a table variable in order to select more efficient query plan’.
Backup of tail log of model with norecovery option is no longer allowed.
Backup and Restore completion messages in the errorlog includes duration and throughput.
SP1_CU10 11.0.3431.0 QFE 2014 May Contains 30+ fixes. This release introduces a statistics trace flag T4139. There is also a parallelism fix.
SP1_CU9 11.0.3412.0 QFE 2014 Mar Contains 29 fixes. This release introduces DATABASE lock partitioning trace flag T1236.
SP1_CU8 11.0.3401.0 QFE 2014 Jan Contains 30+ fixes. This release introduces a Reporting Services subscription issue.
RTM_CU11 11.0.2424.0 QFE 2013 Dec Contains 15 fixes.
SP1_CU7 11.0.3393.0 QFE 2013 Nov Contains 30+ fixes. This release introduces a Reporting Services subscription issue.
RTM_CU10 11.0.2420.0 QFE 2013 Oct
SP1_CU6 11.0.3381.0 QFE 2013 Sep Contains 23 fixes.
RTM_CU9 11.0.2419.0 QFE 2013 Aug
SP1_CU5 11.0.3373.0 QFE 2013 Jul Contains 30 fixes.
RTM_CU8 11.0.2410.0 QFE 2013 Jun
SP1_CU4 11.0.3368.0 QFE 2013 Jun Contains 39 fixes.
New features for this QFE can be found here
RTM_CU7 11.0.2405.0 QFE 2013 Apr Contains 17 fixes.
SP1_CU3 11.0.3349.0 QFE 2013 Mar Contains 38 fixes.
New trace flag 9024 added.
RTM_CU6 11.0.2401.0 QFE 2013 Feb Contains 22 fixes.
SP1_CU2 11.0.3339.0 QFE 2013 Jan Two new features added:1.Native capability to perform backups to & restores from Windows Azure Blob storage.
2. SQL Server Sysprep support for Analysis Services, Integration Services & most shared features.
further details here 

Contains 50 fixes which include all RTM CU5 fixes.

SP1_Fix 11.0.3128.0 GDR 2013 Jan Resolves the Windows Installer (msiexec.exe) process repeatedly starting to repair certain assemblies.
RTM_CU5 11.0.2395.0 QFE 2012 Dec Contains 28 fixes.Adds support for the varchar(max), nvarchar(max), and varbinary(max) data types in most OLE DB providers. 

Resolves a memory leak if the Auto Update Statistics Asynchronously option is enabled.

SP1_CU1 11.0.3321.0 QFE 2012 Nov Contains 44 fixes.
SP1 11.0.3000.00 SP 2012 Nov Includes RTM_CU1 and RTM_CU2.Introduces a new type of XML index known as a Selective XML Index.DBCC SHOW_STATISTICS works with SELECT permission when the user has permissions on all columns in the statistics object and filter condition (if one exists). Use trace flag 9485 if you want pre SP1 behaviour.

 

New function sys.dm_db_stats_properties

 

Other enhancements here

RTM_CU4 11.0.2383.0 QFE 2012 Oct Contains 25 fixes.
MS12-070 11.0.2376.0 QFE 2012 Aug Use if you are on the QFE path of patching.
MS12-070 11.0.2218.0 GDR 2012 Aug Use if you are on the GDR path of patching.
RTM_CU3 11.0.2332.00 QFE 2012 Aug Contains 36 fixes.
RTM_CU2 11.0.2325.00 QFE 2012 Jun Contains 37 fixes.DBCC SHOW_STATISTICS is no longer restricted to sysadmin, db_owner and db_ddladmin. 

Fix for SQL Server Performance Condition alerts so they now contain data.

RTM_CU1 11.0.2316.00 QFE 2012 Apr Contains 54 fixes.

RTM

11.0.2100.60

2012 Mar

Evaluation Edition download EOL** (MS 2017 Jul, ES 2022 Jul, SP 2014 Jan)

* Build Types can be either:

SP – Service Pack (This patch is recommended to be applied if it is supported by your application and testing in a non-Production environment is successful.)

GDR – General Distribution Release (Same recommendation as a Service Pack.)

QFE / CU – Quick Fix Engineering (This type of patch should only be applied if it contains a fix to an issue being experienced.) UPDATE 2016 Mar

** EOL – End of Life for Product

SP (Service Pack Support End Date)

MS (Mainstream Support End Date)

ES (Extended Support End Date)