Warning: Constant WP_TEMP_DIR already defined in /var/www/html/blogs/glenn/wp-config.php on line 94

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902
{"id":966,"date":"2015-07-23T10:19:41","date_gmt":"2015-07-23T17:19:41","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=966"},"modified":"2017-08-08T14:36:30","modified_gmt":"2017-08-08T21:36:30","slug":"performance-and-stability-related-fixes-in-post-sql-server-2014-sp1-builds","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp1-builds\/","title":{"rendered":"Performance and Stability Related Fixes in Post-SQL Server 2014 SP1 Builds"},"content":{"rendered":"

As of August 8, 2017, there have been thirteen Cumulative Updates (CU) for the Service Pack 1 branch of SQL Server 2014. There have been a large number of hotfixes in each of these cumulative updates. If you are still running on the SQL Server 2014 SP1 branch, I really think<\/u><\/strong> you should be running the latest SQL Server 2014 SP1 Cumulative Update. Right now, that means SP1, CU13 (Build 12.0.4522), which was released on July 17, 2017. <\/p>\n

Table 1 shows the SQL Server 2014 SP1 CU builds that have been released so far.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Build<\/td>\nDescription<\/td>\nRelease Date<\/td>\n<\/tr>\n
12.0.4416<\/td>\nSP1 CU1<\/td>\nJune 19, 2015<\/td>\n<\/tr>\n
12.0.4422<\/td>\nSP1 CU2<\/td>\nAugust 17, 2015<\/td>\n<\/tr>\n
12.0.4425<\/td>\nSP1 CU3<\/td>\nOctober 19, 2015<\/td>\n<\/tr>\n
12.0.4436<\/td>\nSP1 CU4<\/td>\nDecember 21, 2015<\/td>\n<\/tr>\n
12.0.4439<\/td>\nSP1 CU5<\/td>\nFebruary 22, 2016<\/td>\n<\/tr>\n
12.0.4457<\/td>\nSP1 CU6<\/td>\nMay 30, 2016<\/td>\n<\/tr>\n
12.0.4459<\/td>\nSP1 CU7<\/td>\nJune 20, 2016<\/td>\n<\/tr>\n
12.0.4468<\/td>\nSP1 CU8<\/td>\nAugust 15, 2016<\/td>\n<\/tr>\n
12.0.4474<\/td>\nSP1 CU9<\/td>\nOctober 17, 2016<\/td>\n<\/tr>\n
12.0.4491<\/td>\nSP1 CU10<\/td>\nDecember 19, 2016<\/td>\n<\/tr>\n
12.0.4502<\/td>\nSP1 CU11<\/td>\nFebruary 21, 2017<\/td>\n<\/tr>\n
12.0.4511<\/td>\nSP1 CU12<\/td>\nApril 17, 2017<\/td>\n<\/tr>\n
12.0.4522<\/td>\nSP1 CU13<\/td>\nJuly 17, 2017<\/td>\n<\/tr>\n
 <\/td>\n <\/td>\n <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Table 1: SQL Server 2014 SP1 CU Builds<\/strong><\/p>\n

<\/strong><\/p>\n

You can follow the KB article link below to see all of the CU builds for all of SQL Server 2014 branches.<\/p>\n

\n

SQL Server 2014 Build Versions<\/a><\/p>\n<\/blockquote>\n

Like I have done for other versions and branches of SQL Server, I decided to scan the hotfix list for all of the Cumulative Updates in the RTM branch, looking for performance and general reliability-related fixes for the SQL Server Database Engine. I came up with the list below, but this listing is completely arbitrary on my part<\/strong><\/em>. You may come up with a completely different list, based on what specific SQL Server 2014 features you are using.<\/p>\n

Here are the fixes in the SP1 branch:<\/p>\n

SQL Server 2014 SP1 Cumulative Update 1<\/a><\/strong> (Build 12.0.4416), 112 total public hot fixes<\/strong><\/p>\n

\n

FIX: Performance issue occurs when you use sqlncli11.dll ODBC driver to access SQL Server in an application<\/a><\/p>\n

FIX: Improved memory management for columnstore indexes to deliver better query performance in SQL Server 2014<\/a><\/p>\n

FIX: A SELECT query that’s run as a parallel batch-mode scan triggers a deadlock in SQL Server 2014<\/a><\/p>\n

FIX: Data loss might occur when you use Windows Azure Storage in SQL Server 2014 on high latency networks<\/a><\/p>\n

Incorrect values are included in the description column when you query the sys.dm_xe_objects dynamic management object in SQL Server 2014<\/a><\/p>\n

FIX: Cannot create statistics when you execute statement to create it directly or in the background in SQL Server 2014<\/a><\/p>\n

FIX: Complex parallel query does not respond in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

FIX: An I\/O error that occurs on BPE files causes SQL Server 2014 to disable BPE<\/a><\/p>\n

FIX: Access violation occurs when you connect to an instance of SQL Server 2014<\/a><\/p>\n

“Non-yielding Scheduler” error occurs and SQL Server stops responding when a database has columnstore indexes on a Microsoft SQL Server 2014 instance<\/a><\/p>\n

Incorrect results are returned in an indexed view after an Insert or Delete operation on the base table occurs in SQL Server 2014 <\/a><\/p>\n

FIX: Memory leak in USERSTORE_SCHEMAMGR and CPU spikes occur when you use temp table in SQL Server 2012 or 2014<\/a><\/p>\n

FIX: DBCC CHECKDB and DBCC CHECKTABLE take longer to run when SQL CLR UDTs are involved in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

FIX: Access violation occurs when you delete rows from a table that has clustered columnstore index in SQL Server 2014<\/a><\/p>\n

FIX: Paging out in memory occurs when columnstore index query consumes large memory in SQL Server 2014<\/a><\/p>\n

FIX: A severe error occurs in SQL Server 2014 during compilation of a query on a table with clustered columnstore index<\/a><\/p>\n

Large query compilation waits on RESOURCE_SEMAPHORE_QUERY_COMPILE in SQL Server 2014<\/a><\/p>\n

FIX: Error 1205 when you execute parallel query that contains outer join operators in SQL Server 2014<\/a><\/p>\n

FIX: The transaction isolation level is reset incorrectly when the SQL Server connection is released in SQL Server 2014<\/a><\/p>\n

FIX: SOS_CACHESTORE spinlock contention on ad hoc SQL Server plan cache causes high CPU usage in SQL Server 2012 or 2014<\/a><\/p>\n

FIX: Memory leak occurs when you run DBCC CHECKDB against a database in SQL Server 2014<\/a><\/p>\n

FIX: Error 8646 when you run DML statements on a table with clustered columnstore index in SQL Server 2014<\/a><\/p>\n

FIX: SQL Server takes long time to open database after recovery to add or remove a data file in SQL Server 2014 or SQL Server 2012<\/a><\/p>\n

FIX: Access violation and “No exceptions should be raised by this code” error occur when you use SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

FIX: Error 3624 occurs when you execute a query that contains multiple bulk insert statements in SQL Server 2014<\/a><\/p>\n

FIX: Access violation occurs when you query against a table that contains column store indexes in SQL Server 2014<\/a><\/p>\n

FIX: Incorrect choice of a nested loops join strategy causes poor query performance in SQL Server 2014<\/a><\/p>\n

FIX: Error 33294 occurs when you alter column types on a table that has clustered columnstore indexes in SQL Server 2014<\/a><\/p>\n

FIX: Access violation when a missing task for a background clear operation tries to delete a missing index entry<\/a><\/p>\n

FIX: Error 33415 occurs when you restart the SQL Server service or alter database in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

FIX: Error 35377 when you run a parallel query that contains MERGE statements in SQL Server 2014<\/a><\/p>\n

 <\/p>\n<\/blockquote>\n

SQL Server 2014 SP1 Cumulative Update 2<\/a><\/strong> (Build 12.0.4422), 44 total public hot fixes<\/strong><\/p>\n

\n

FIX: The Resource database is missing after you install updates or service packs for instances of SQL Server 2012 one after another and then restart the server<\/a><\/p>\n

FIX: Incorrect result when you execute a full-text query with parallel execution plan in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

FIX: CMEMTHREAD waits occur when you execute many ad hoc queries in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

FIX: You cannot set a SQL Server 2012 or 2014 database to single-user mode if the database is read-only<\/a><\/p>\n

FIX: Cannot enable “change data capture” on a table that uses a unique index with more than one included column in SQL Server 2012 or 2014<\/a><\/p>\n

FIX: Error messages are logged when you execute a non-cacheable auto-parameterized query in SQL Server 2012 or 2014<\/a><\/p>\n

FIX: Error 1635 occurs when you use Product Update to install SQL Server 2014 SP1 and SQL Server 2014 SP1 CU1<\/a><\/p>\n

Restore Log with Standby Mode on an Advanced Format disk may cause a 9004 error in SQL Server 2008 R2 or SQL Server 2012<\/a><\/p>\n

FIX: Increased HADR_SYNC_COMMIT wait types when AlwaysOn Availability Groups contain memory-optimized tables in SQL Server 2014 Service Pack 1<\/a><\/p>\n

FIX: A stalled dispatcher system dump occurs forcing a failover and service outage on the availability groups in SQL Server 2014 Service Pack 1<\/a><\/p>\n

FIX: Incorrect results occur in a rare scenario when you run a query that contains a nested loop join and performance spool in its inner side in SQL Server 2012 or 2014<\/a><\/p>\n

FIX: An AlwaysOn database on a secondary replica shows a “NOT SYNCHRONIZING” status in SQL Server 2014<\/a><\/p>\n

FIX: “Possible schema corruption. Run DBCC CHECKCATALOG” error occurs when you delete column in SQL Server 2014<\/a><\/p>\n

FIX: Access violation and unexpected SQL Server shutdown occur when common criteria compliance is enabled<\/a><\/p>\n

FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server 2012 or 2014 database<\/a><\/p>\n

FIX: A deadlock occurs when you execute the sp_estimate_data_compression_savings stored procedure in SQL Server 2012<\/a><\/p>\n

FIX: Hash or merge join hints may be ignored when you execute a query in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

FIX: An online rebuild of indexes is unsuccessful when a table partition is read-only in SQL Server 2014 Service Pack 1<\/a><\/p>\n

FIX: Maintenance Plan performs offline index rebuild for large object table in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

 <\/p>\n<\/blockquote>\n

SQL Server 2014 SP1 Cumulative Update 3<\/a><\/strong> (Build 12.0.4425), 36 total public hot fixes<\/strong><\/p>\n

\n

FIX: Can\u2019t backup in-memory OLTP database that is restored by using full and differential restore in SQL Server 2014<\/a><\/p>\n

FIX: CPU usage is higher than expected when you reduce the value of CAP_CPU_PERCENT argument in creating resource pool<\/a><\/p>\n

FIX: Scheduler deadlock on primary replica when you remove a replica from an AlwaysOn availability group in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

FIX: Rare incorrect result occurs when you run parallel query in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

FIX: Error 602 when you run a stored procedure repeatedly in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

FIX: Access violations when you use the FileTable feature in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

FIX: Queries take longer time to compile in SQL Server 2014 than in earlier versions<\/a><\/p>\n

FIX: 100% CPU usage occurs when in-memory OLTP database is in recovery state in SQL Server 2014<\/a><\/p>\n

FIX: Metadata inconsistency error occurs after you switch table partitions and drop corresponding files and filegroups<\/a><\/p>\n

FIX: DBCC CHECKFILEGROUP reports false inconsistency errors on database that has partitioned table in SQL Server 2014<\/a><\/p>\n

FIX: It takes longer to run the ALTER DATABASE SET HADR OFF command on a secondary replica in SQL Server 2014<\/a><\/p>\n

FIX: Error 9002 and error 3052 when you try to add or back up log file in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

FIX: Sort operator spills to tempdb in SQL Server 2012 or SQL Server 2014 when estimated number of rows and row size are correct<\/a><\/p>\n

FIX: Backup operation fails in a SQL Server database after you enable change tracking<\/a><\/p>\n

FIX: Rare index corruption when you build a columnstore index with parallelism on a partitioned table in SQL Server 2014<\/a><\/p>\n

FIX: Access violation occurs when you execute a query that contains many joins and coalesce functions in SQL Server 2014<\/a><\/p>\n

FIX: DBCC CHECKDB doesn’t report metadata inconsistency of invalid filegroups in its summary in SQL Server 2014<\/a><\/p>\n

FIX: It takes a longer time than earlier versions of SQL Server when you run DBCC CHECKDB in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

 <\/p>\n

SQL Server 2014 SP1 Cumulative Update 4<\/a><\/strong> (Build 12.0.4436), 36 total public hot fixes<\/strong><\/p>\n

\n

FIX: Can\u2019t create database snapshot when you use DBCC CHECKDB in SQL Server 2014<\/a><\/p>\n

FIX: Memory leak occurs on MEMOBJ_SOSNODE type object when you run query in sys.database_permissions in SQL Server 2014<\/a><\/p>\n

FIX: Access violation occurs when you update compressed data in SQL Server 2014<\/a><\/p>\n

FIX: Out of memory error when the virtual address space of the SQL Server process is very low on available memory<\/a><\/p>\n

FIX: Performance decrease when application with connection pooling frequently connects or disconnects in SQL Server<\/a><\/p>\n

FIX: SQL Server service performs more I\/O operations on the mirror server than on the principal server<\/a><\/p>\n

FIX: Access violation occurs when you run INSERT, UPDATE or MERGE statement on view with check option in SQL Server 2014<\/a><\/p>\n

FIX: Log shipping restore job takes a long time on the secondary server in SQL Server 2014<\/a><\/p>\n

FIX: Query stops responding in SQL Server 2014 that starts with trace flag 2430 as startup parameter<\/a><\/p>\n

FIX: An access violation occurs when you use the TDE and BPE features in SQL Server 2014<\/a><\/p>\n

FIX: DBCC CHECKDB\/CHECKTABLE command may take longer in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

FIX: SQL Server stops responding when you back up the certificate that is used to encrypt the database encryption key in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

FIX: The execution of stored procedure is replicated to subscriber incorrectly from Publisher in SQL Server 2014<\/a><\/p>\n

FIX: The query stops responding when you run a parallel query on the table with a columnstore index in SQL Server 2014<\/a><\/p>\n

FIX: Temporary files that are created by DBCC aren’t deleted when SQL Server is restarted<\/a><\/p>\n

 <\/p>\n<\/blockquote>\n

SQL Server 2014 SP1 Cumulative Update 5<\/a><\/strong> (Build 12.0.4439), 21 total public hot fixes<\/strong><\/p>\n

\n

FIX: Access violation occurs when you use the ODBC Driver11 in SQL Server 2014<\/a><\/p>\n

An update to enable the “-k” startup parameter to control the rate that work files can spill to tempdb is available for SQL Server 2012 Service Pack 3<\/a><\/p>\n

FIX: It takes a long time to install service packs or cumulative updates in SQL Server 2014<\/a><\/p>\n

FIX: Error when you use the replication feature in SQL Server 2014<\/a><\/p>\n

FIX: Columnstore index corruptions occur when you use AlwaysOn Availability Groups feature in SQL Server 2014<\/a><\/p>\n

FIX: Assertion failure occurs when you run a query in SQL Server 2014<\/a><\/p>\n

FIX: An assertion failure occurs on secondary replica when you use AlwaysOn Availability Groups in SQL Server 2014<\/a><\/p>\n

FIX: “Non-yielding Scheduler” condition when you query a partitioned table that has a columnstore index in SQL Server 2014<\/a><\/p>\n

FIX: “Non-yielding Scheduler” condition occurs when you run a query that contains a UNION operation in SQL Server 2014<\/a><\/p>\n<\/blockquote>\n

 <\/p>\n

SQL Server 2014 SP1 Cumulative Update 6<\/a><\/strong> (Build 12.0.4457), 46 total public hot fixes<\/strong><\/p>\n

\n

FIX: Estimated number of rows is calculated incorrectly for a predicate involving a unique GUID column in SQL Server 2014<\/a><\/p>\n

FIX: “Non-yielding Scheduler” error when versioning cleanup task runs on a SQL Server 2014 AlwaysOn secondary replica<\/a><\/p>\n

FIX: Column data may be deleted when you update another column in a table in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

FIX: The Log Reader Agent stops intermittently and an Access Violation occurs in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

FIX: Assertion failure on secondary replica when you use AlwaysOn Availability Groups in SQL Server 2014<\/a><\/p>\n

FIX: SELECT INTO statement together with the TABLOCKX hint or the TABLOCK and UPDLOCK hints fail on SQL Server 2014<\/a><\/p>\n

FIX: Number of rows is underestimated for a query predicate that involves a scalar user-defined function in SQL Server 2014<\/a><\/p>\n

FIX: Access violation when you execute a stored procedure that uses a cursor on a table variable in SQL Server<\/a><\/p>\n

FIX: Canceling a backup task crashes SQL Server 2014<\/a><\/p>\n

FIX: Large disk checkpoint usage occurs for an In-Memory optimized filegroup during heavy non-In-Memory workloads<\/a><\/p>\n

Running multiple UPDATE STATISTICS for different statistics on a single table concurrently is available<\/a><\/p>\n

FIX: Columnstore index corruption occurs when you use AlwaysOn Availability Groups in SQL Server 2014<\/a><\/p>\n

FIX: A “Non-yielding Scheduler” condition occurs when you perform a BULK INSERT and the data file exists in a FileTable in SQL Server 2014<\/a><\/p>\n

FIX: Memory corruption causes an access violation in an instance of SQL Server 2014<\/a><\/p>\n

FIX: SELECT\u2026INTO statement retrieves incorrect result from a clustered columnstore index in SQL Server 2014<\/a><\/p>\n

FIX: “A severe error occurred on the current command” when a Table-Valued User-Defined function is referred to by a synonym<\/a><\/p>\n<\/blockquote>\n

<\/strong> <\/p>\n

SQL Server 2014 SP1 Cumulative Update 7<\/a><\/strong> (Build 12.0.4459), 32 total public hot fixes<\/strong><\/p>\n

\n

FIX: An access violation occurs when you use the TDE and BPE features in SQL Server 2014 <\/a><\/p>\n

FIX: SQLDiag fails with function 87 error in a SQL AlwaysOn availability group <\/a><\/p>\n

FIX: Incorrect results when you use a LIKE operator and an “ss” wildcard in SQL Server 2014 <\/a><\/p>\n

FIX: High CPU usage on SQL queries after install SQL Server 2014 Service Pack 1 <\/a><\/p>\n

FIX: Change tracking cleanup task fails if another database is offline in SQL Server 2014 <\/a><\/p>\n

SQL Server 2014 doesn’t start after you configure the tempdb database to use a very small log file <\/a><\/p>\n

FIX: DBCC CHECKTABLE returns incorrect result after the clustered columnstore index is rebuilt in SQL Server 2014 <\/a><\/p>\n

FIX: Assertion failures after you install deprecated Cumulative Update 6 for SQL Server 2014 SP1 <\/a><\/p>\n

FIX: SQL Server 2014 crashes when you execute a query that contains a NONEXISTENT query hint on an In-Memory OLTP database <\/a><\/p>\n

Query plan generation improvement for some columnstore queries in SQL Server 2014 <\/a><\/p>\n

FIX: “Non-yielding Scheduler” condition occurs when you run a query in SQL Server 2014 <\/a><\/p>\n

FIX: SQL Server database creation on a system with a large volume of memory takes longer than expected <\/a><\/p>\n

 <\/p>\n<\/blockquote>\n

SQL Server 2014 SP1 Cumulative Update 8<\/a><\/strong> (Build 12.0.4468), 39 total public hot fixes<\/strong><\/p>\n

\n

FIX: sys.dm_db_index_usage_stats missing information after index rebuild on SQL Server 2012 or 2014 <\/a><\/p>\n

A memory leak occurs when you use Azure Storage in SQL Server 2014 <\/a><\/p>\n

SQL Server 2014 crashes because of an access violation error that occurs while it reads data from an event file target <\/a><\/p>\n

FIX: Error 1478 when you add a database back to the AlwaysOn availability group in SQL Server <\/a><\/p>\n

Operating system error 32 when you restore a database in SQL Server 2014 <\/a><\/p>\n

FIX: Deadlock occurs when you acquire a SCH-M lock and ALTER PARTITION in SQL Server 2014 <\/a><\/p>\n

FIX: Queries always get recompiled on the secondary databases in SQL Server 2014 <\/a><\/p>\n

FIX: Garbage collection in In-Memory OLTP may cause “non-yielding scheduler” in SQL Server 2014 <\/a><\/p>\n

FIX: Query runs slowly when SQL Server uses hash aggregate in the query plan <\/a><\/p>\n

Decrease in performance and “non-yielding scheduler” errors caused by unnecessary spinlocks in SQL Server <\/a><\/p>\n

FIX: Memory leak on the AlwaysOn secondary replica when change tracking is enabled in SQL Server <\/a><\/p>\n

Transaction log backup failure on the secondary replica prevents subsequent backups on Availability Replicas in SQL Server <\/a><\/p>\n

FIX: Error 3456 “Could not redo log record” occurs, causing replicas to be suspended or repeated behavior in SQL Server <\/a><\/p>\n<\/blockquote>\n

 <\/p>\n

SQL Server 2014 SP1 Cumulative Update 9<\/a><\/strong> (Build 12.0.4474), 13 total public hot fixes<\/strong><\/p>\n

\n

FIX: Access violation when you run a query that uses clustered columnstore index with trace flag 2389, 2390, or 4139 <\/a><\/p>\n

Statistics removed after rebuilding the index on a partitioned table in SQL Server <\/a><\/p>\n

FIX: Queries that use CHANGETABLE use much more CPU after you install SQL Server 2014 SP1 CU6 <\/a><\/p>\n

FIX: Cannot uninstall service packs for SQL Server 2014 after a cumulative update is installed <\/a><\/p>\n

 <\/p>\n<\/blockquote>\n

SQL Server 2014 SP1 Cumulative Update 10<\/a><\/strong> (Build 12.0.4491), 27 total public hot fixes<\/strong><\/p>\n

\n

SQL Server crashes with an access violation when you use the TRY\u2026CATCH construct for bulk copy <\/a><\/p>\n

FIX: Incremental statistics runs with higher sample rate than regular statistics when statistics are created or updated in SQL Server 2014 <\/a><\/p>\n

\u201cA digitally signed driver is required\u201d warning when you install SQL Server packages in Windows Server 2016 and Windows 10 <\/a><\/p>\n

FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server 2012 or 2014 database <\/a><\/p>\n

FIX: The Target Recovery Time of a database set to a nonzero value causes an assertion and a lease timeout in SQL Server 2014 <\/a><\/p>\n

FIX: Memory is paged out when columnstore index query consumes lots of memory in SQL Server 2014 <\/a><\/p>\n

FIX: Error 2809 when you execute a stored procedure that takes a table-valued parameter from RPC calls in SQL Server 2014 <\/a><\/p>\n

Unexpected growth of tempdb data files when using SQL Server Service Broker <\/a><\/p>\n

FIX: Access Violation when you execute queries on a readable secondary replica of a SQL Server 2014 AlwaysOn Availability Group <\/a><\/p>\n

FIX: TDE encrypted Databases go in suspect state during the recovery phase when you restart SQL Server 2012 or 2014 <\/a><\/p>\n

FIX: Rebuilding a nonclustered index to add columns by using CREATE INDEX with DROP_EXISTING=ON and ONLINE=ON causes blocking <\/a><\/p>\n

FIX: No automatic failover after database mirroring stops unexpectedly in SQL Server 2012 or 2014 <\/a><\/p>\n

FIX: Out-of-memory errors when you execute DBCC CHECKDB on database that contains columnstore indexes in SQL Server 2014 <\/a><\/p>\n

FIX: Incorrect query result when you use varchar(max) variable in the search condition in SQL Server 2014 <\/a><\/p>\n

FIX: DBCC CHECKFILEGROUP reports false inconsistency error 5283 on a database that contains a partitioned table in SQL Server <\/a><\/p>\n

 <\/p>\n<\/blockquote>\n

SQL Server 2014 SP1 Cumulative Update 11<\/a><\/strong> (Build 12.0.4502), 14 total public hot fixes<\/strong><\/p>\n

\n

FIX: An Always On secondary replica goes into a disconnecting state<\/a><\/p>\n

Update improves handling of documents too large for Full-Text Search indexing in SQL Server 2014<\/a><\/p>\n

\u201cA digitally signed driver is required\u201d warning when you install SQL Server packages in Windows Server 2016 and Windows 10<\/a><\/p>\n

FIX: Cannot connect to a named instance after failover on a mirror server in SQL Server 2016<\/a><\/p>\n

FIX: Error 5262 when you execute DBCC CHECKDB on the primary replica that contains repaired data pages in SQL Server 2012<\/a><\/p>\n

FIX: AFTER DELETE triggers occur in the wrong order in the ON DELETE CASCADE action chain in SQL Server 2014<\/a><\/p>\n

FIX: Assert memory dump on a mirror server in SQL Server 2012<\/a><\/p>\n

FIX: On failover, the new secondary replica stops accepting transaction log records until the instance is restarted in SQL Server<\/a><\/p>\n

FIX: Changing the data type and then updating the table with more than 4,000 records causes database corruption<\/a><\/p>\n

 <\/p>\n<\/blockquote>\n

SQL Server 2014 SP1 Cumulative Update 12<\/a><\/strong> (Build 12.0.4511), 12 total public hot fixes<\/strong><\/p>\n

\n

FIX: A memory leak in SQLWEP causes the host process Wmiprvse.exe to crash in SQL Server 2012 or 2014<\/a><\/p>\n

FIX: Failed assertion and many access violation dump files after the sp_replcmds stored procedure is canceled in SQL Server 2012 or 2014<\/a><\/p>\n

FIX: Bad query plan created on secondary replicas after statistics updated via FULLSCAN option on primary replica in SQL Server 2012 or 2014<\/a><\/p>\n

FIX: DMV sys.dm_hadr_availability_group_states displays “NOT_HEALTHY” in synchronization_health_desc column on secondary replicas in SQL Server 2012 or 2014<\/a><\/p>\n

Update reduces the execution frequency of the sp_MSsubscription_cleanup stored procedure in SQL Server 2012 or 2014<\/a><\/p>\n

FIX: Service Broker endpoint connections aren’t closed after an availability group failover in SQL Server<\/a><\/p>\n

 <\/p>\n<\/blockquote>\n

SQL Server 2014 SP1 Cumulative Update 13<\/a><\/strong> (Build 12.0.4522), 11 total public hot fixes<\/strong><\/p>\n

\n

FIX: Access violation when a stored procedure is dropped before you execute END TRY section in SQL Server<\/a><\/p>\n

FIX: Change Data Capture stops working after a recent cumulative update for SQL Server is installed<\/a><\/p>\n

FIX: A stored procedure may fail after an automatic failover occurs on a mirrored database in SQL Server 2012 or 2014<\/a><\/p>\n

FIX: Transaction log backup failure on the secondary replica in SQL Server Always-On Availability Groups<\/a><\/p>\n

Fix: System generated stored procedures are created incorrectly in P2P publication if the schema name of published table contains a period (.) in SQL Server 2014<\/a><\/p>\n

FIX: Access violation occurs when you execute a query to retrieve data from a clustered columnstore index in SQL Server 2014<\/a><\/p>\n

 <\/p>\n<\/blockquote>\n

The reason that I put these lists together is that I want to convince more people to try to keep their SQL Server instances up to date with Cumulative Updates. If you do the proper testing, planning and preparation, I think the risks from installing a SQL Server Cumulative Update are quite low (despite the occasional issues that people run into).<\/p>\n

If you install a Cumulative Update or Service Pack on a Production system the day it is released, after doing no testing whatsoever, and then run into problems (and don\u2019t have a plan on how to recover), then I don\u2019t have that much sympathy for you. <\/p>\n

On the other hand, if you go through a thoughtful and thorough testing process, and you have a plan for how you will install the CU, and how you would recover if there were any problems, then you are much less likely to have any problems. You are also much more likely to avoid the issues that are fixed by all of the included fixes in the new build of SQL Server. You have done your job as a good DBA.<\/p>\n

Finally, Microsoft has changed their official guidance<\/a> about whether you should install SQL Server Cumulative Updates. As they say, \u201cwe now recommend ongoing, proactive installation of CU\u2019s as they become available\u201d.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

As of August 8, 2017, there have been thirteen Cumulative Updates (CU) for the Service Pack 1 branch of SQL Server 2014. There have been a large number of hotfixes in each of these cumulative updates. If you are still running on the SQL Server 2014 SP1 branch, I really think you should be running […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,21,156],"tags":[315],"class_list":["post-966","post","type-post","status-publish","format-standard","hentry","category-sql-server-cumulative-updates","category-microsoft","category-sql-server-2014","tag-sql-server-cumulative-updates"],"yoast_head":"\nPerformance and Stability Related Fixes in Post-SQL Server 2014 SP1 Builds - Glenn Berry<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp1-builds\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Performance and Stability Related Fixes in Post-SQL Server 2014 SP1 Builds - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"As of August 8, 2017, there have been thirteen Cumulative Updates (CU) for the Service Pack 1 branch of SQL Server 2014. There have been a large number of hotfixes in each of these cumulative updates. If you are still running on the SQL Server 2014 SP1 branch, I really think you should be running […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp1-builds\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-23T17:19:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-08-08T21:36:30+00:00\" \/>\n<meta name=\"author\" content=\"Glenn Berry\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Glenn Berry\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"18 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp1-builds\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp1-builds\/\",\"name\":\"Performance and Stability Related Fixes in Post-SQL Server 2014 SP1 Builds - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2015-07-23T17:19:41+00:00\",\"dateModified\":\"2017-08-08T21:36:30+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp1-builds\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp1-builds\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp1-builds\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performance and Stability Related Fixes in Post-SQL Server 2014 SP1 Builds\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\",\"name\":\"Glenn Berry\",\"description\":\"Semi-random musings about SQL Server performance\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\",\"name\":\"Glenn Berry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"caption\":\"Glenn Berry\"},\"sameAs\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Performance and Stability Related Fixes in Post-SQL Server 2014 SP1 Builds - Glenn Berry","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp1-builds\/","og_locale":"en_US","og_type":"article","og_title":"Performance and Stability Related Fixes in Post-SQL Server 2014 SP1 Builds - Glenn Berry","og_description":"As of August 8, 2017, there have been thirteen Cumulative Updates (CU) for the Service Pack 1 branch of SQL Server 2014. There have been a large number of hotfixes in each of these cumulative updates. If you are still running on the SQL Server 2014 SP1 branch, I really think you should be running […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp1-builds\/","og_site_name":"Glenn Berry","article_published_time":"2015-07-23T17:19:41+00:00","article_modified_time":"2017-08-08T21:36:30+00:00","author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"18 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp1-builds\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp1-builds\/","name":"Performance and Stability Related Fixes in Post-SQL Server 2014 SP1 Builds - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2015-07-23T17:19:41+00:00","dateModified":"2017-08-08T21:36:30+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp1-builds\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp1-builds\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp1-builds\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Performance and Stability Related Fixes in Post-SQL Server 2014 SP1 Builds"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/","name":"Glenn Berry","description":"Semi-random musings about SQL Server performance","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/glenn\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7","name":"Glenn Berry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","caption":"Glenn Berry"},"sameAs":["https:\/\/www.sqlskills.com\/blogs\/glenn\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/966","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/comments?post=966"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/966\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}