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":1168,"date":"2017-03-19T15:17:02","date_gmt":"2017-03-19T22:17:02","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1168"},"modified":"2019-08-01T08:21:30","modified_gmt":"2019-08-01T15:21:30","slug":"performance-and-stability-related-fixes-in-post-sql-server-2014-sp2-builds","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp2-builds\/","title":{"rendered":"Performance and Stability Related Fixes in Post-SQL Server 2014 SP2 Builds"},"content":{"rendered":"

As of July 29, 2019, there have been eighteen Cumulative Updates (CU) for the Service Pack 2 branch of SQL Server 2014. There have been a large number of hotfixes in most of these cumulative updates. SP2 CU18 is the final CU for SQL Server 2014 SP2, since SQL Server 2014 fell out of Mainstream Support on July 9, 2019.<\/p>\n

If you are running on the SQL Server 2014 SP2 branch, I really think<\/u><\/strong> you should be running the latest SQL Server 2014 SP2 Cumulative Update.  In fact, if you are on SQL Server 2014, you should actually be on the SP3 branch, on the final CU, which is SP3 CU4.<\/p>\n

Table 1 shows the SQL Server 2014 SP2 CU builds that have been released.<\/p>\n\n\n\n\n\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.5511<\/td>\nSP2 CU1<\/td>\nAugust 25, 2016<\/td>\n<\/tr>\n
12.0.5522<\/td>\nSP2 CU2<\/td>\nOctober 17, 2016<\/td>\n<\/tr>\n
12.0.5538<\/td>\nSP2 CU3<\/td>\nDecember 19, 2016<\/td>\n<\/tr>\n
12.0.5540<\/td>\nSP2 CU4<\/td>\nFebruary 21, 2017<\/td>\n<\/tr>\n
12.0.5546<\/td>\nSP2 CU5<\/td>\nApril 17, 2017<\/td>\n<\/tr>\n
12.0.5553<\/td>\nSP2 CU6<\/td>\nJuly 17, 2017<\/td>\n<\/tr>\n
12.0.5556<\/td>\nSP2 CU7<\/td>\nAugust 28, 2017<\/td>\n<\/tr>\n
12.0.5557<\/td>\nSP2 CU8<\/td>\nOctober 16, 2017<\/td>\n<\/tr>\n
12.0.5563<\/td>\nSP2 CU9<\/td>\nDecember 18, 2017<\/td>\n<\/tr>\n
12.0.5571<\/td>\nSP2 CU10<\/td>\nJanuary 16, 2018<\/td>\n<\/tr>\n
12.0.5579<\/td>\nSP2 CU11<\/td>\nMarch 19, 2018<\/td>\n<\/tr>\n
12.0.5589<\/td>\nSP2 CU12<\/td>\nJune 18, 2018<\/td>\n<\/tr>\n
12.0.5590<\/td>\nSP2 CU13<\/td>\nAugust 27, 2018<\/td>\n<\/tr>\n
12.0.5600<\/td>\nSP2 CU14<\/td>\nOctober 15, 2018<\/td>\n<\/tr>\n
12.0.5605<\/td>\nSP2 CU15<\/td>\nDecember 12, 2018<\/td>\n<\/tr>\n
12.0.5626<\/td>\nSP2 CU16<\/td>\nFebruary 19, 2019<\/td>\n<\/tr>\n
12.0.5632<\/td>\nSP2 CU17<\/td>\nApril 16, 2019<\/td>\n<\/tr>\n
12.0.5687<\/td>\nSP2 CU18<\/td>\nJuly 29, 2019<\/td>\n<\/tr>\n
 <\/td>\n <\/td>\n <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

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

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

You can follow the KB article link below to see all of the CU builds for the SQL Server 2014 RTM, SQL Server 2014 SP1, SQL Server 2014 SP2, and SQL Server 2014 SP3 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 SP2 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 SP2 branch:<\/p>\n

SQL Server 2014 SP2 Cumulative Update 1<\/a><\/strong> (Build 12.0.5511), 39 total public hot fixes<\/strong><\/p>\n

\n

FIX: SQL Server crashes when you run a remote query in a stored procedure by using an invalid user name <\/a><\/p>\n

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

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

“The log backup chain is broken” error when the log backup process fails in SQL Server <\/a><\/p>\n

FIX: Error 1478 when you add a database back to the AlwaysOn availability group 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: Service Broker UCS task leaks memory in SQL Server 2014 <\/a><\/p>\n

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

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

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

SQL Server 2014 SP2 Cumulative Update 2<\/a><\/strong> (Build 12.0.5522), 17 total public hot fixes<\/strong><\/p>\n

\n

Improved SQL Server stability and concurrent query execution for some columnstore queries in SQL Server 2014 and 2016 <\/a><\/p>\n

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

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

FIX: A deadlock occurs when you execute a query plan that has a nested loop join between two hash joins working in the batch mode in SQL Server 2014 <\/a><\/p>\n

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

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

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

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

SQL Server 2014 SP2 Cumulative Update 3<\/a><\/strong> (Build 12.0.5538), 37 total public hot fixes<\/strong><\/p>\n

\n

FIX: Deadlock causes deferred transaction on the secondary replica in an Always On environment <\/a><\/p>\n

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

Unexpected growth of tempdb data files when using SQL Server Service Broker <\/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: On failover, the new secondary replica stops accepting transaction log records until the instance is restarted in SQL Server <\/a><\/p>\n

FIX: An assertion occurs when you restore a clone database that has Query Store enabled 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

FIX: Availability databases in incorrect initializing\/synchronizing state after failover of SQL Server 2014 AlwaysOn availability group <\/a><\/p>\n

Statistics are removed after rebuilding a specific partition of an partitioned aligned index on a partitioned table in SQL Server <\/a><\/p>\n

Updates to DBCC CLONEDATABASE functionality in SQL Server 2014 <\/a><\/p>\n

FIX: You cannot select any replica when you fail over from an availability group that’s in the resolving state <\/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: Rebuilding a nonclustered index to add columns by using CREATE INDEX with DROP_EXISTING=ON and ONLINE=ON causes blocking <\/a><\/p>\n

FIX: Queries that run against secondary databases always get recompiled in SQL Server <\/a><\/p>\n

FIX: Distribution Agent fails for a SQL Server 2014 publisher and a SQL Server 2012 subscriber in Transactional Replication <\/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: No automatic failover after database mirroring stops unexpectedly in SQL Server 2012 or 2014 <\/a><\/p>\n

FIX: Intra-query deadlock when values are inserted into a partitioned clustered columnstore index in SQL Server 2014 <\/a><\/p>\n

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

SQL Server 2014 SP2 Cumulative Update 4<\/a><\/strong> (Build 12.0.5540), 25 total public hot fixes<\/strong><\/p>\n

\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

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

FIX: A system assert occurs when a Transact-SQL stored procedure with a TVP argument is called from a SQLCLR procedure<\/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: Error 5262 when you execute DBCC CHECKDB on the primary replica that contains repaired data pages in SQL Server 2012 or 2014<\/a><\/p>\n

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

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

FIX: Fails to execute the DBCC CLONEDATABASE command on an in-place upgrade instance of SQL Server <\/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

FIX: Incorrect query result when you use varchar(max) variable in the search condition in SQL Server 2014<\/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

FIX: Memory leak occurs when you run a query that you don’t have enough permissions in SQL Server 2014<\/a><\/p>\n

FIX: SQL Server is stopped when you install patches on an instance of SQL Server 2014 that contains many databases<\/a><\/p>\n<\/blockquote>\n

 <\/p>\n

SQL Server 2014 SP2 Cumulative Update 5<\/a><\/strong> (Build 12.0.5546), 24 total public hot fixes<\/strong><\/p>\n

\n

FIX: Access violation in SQL Server 2014 when large number of rows are inserted into a partitioned columnstore index<\/a><\/p>\n

FIX: Service Broker endpoint connections aren’t closed after an availability group failover in SQL Server<\/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

Update improves handling of documents too large for Full-Text Search indexing in SQL Server<\/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

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: Many HkHostLogCheckpointRecord() messages are logged in the SQL Server error log<\/a><\/p>\n

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

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

SQL Server 2014 SP2 Cumulative Update 6<\/a><\/strong> (Build 12.0.5553), 29 total public hot fixes<\/strong><\/p>\n

\n

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

Update adds the “CLR strict security” feature to SQL Server 2016<\/a><\/p>\n

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

FIX: An access violation occurs when you create an index with page compression in SQL Server<\/a><\/p>\n

FIX: Error when you execute DBCC CLONEDATABASE on an “Always Encrypted” enabled database in SQL Server 2014 or 2016<\/a><\/p>\n

FIX: Fails to resume a suspended availability database after a write error in SQL Server 2014<\/a><\/p>\n

FIX: Unable to drop stored procedure execution article from P2P publication in SQL Server 2014<\/a> <\/p>\n

FIX: Timeout error when you backup a large database to URL 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

FIX: Error 574 when you try to install Service Pack 2 for SQL Server 2014<\/a> <\/p>\n

FIX: Unable to rebuild the partition online for a table that contains a computed partitioning column in SQL Server 2014 or 2016<\/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: An assertion occurs when you run a query that performs join operations by using MERGE JOIN in SQL Server 2014<\/a> <\/p>\n

FIX: Access violation when a stored procedure is dropped before you execute END TRY section in SQL Server<\/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: “FILESTREAM feature is disabled” error when you use the FILESTREAM feature for SQL Server 2014 in Windows 10 Creators Update<\/a><\/p>\n

FIX: Query with UNION ALL and a row goal may run slower in SQL Server 2014 or later versions when it’s compared to SQL Server 2008 R2<\/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

FIX: “Non-yielding Scheduler” condition occurs on spinlock contention in Microsoft SQL Server 2014<\/a> <\/p>\n

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

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

\n

FIX: Access violation with query to retrieve data from a clustered columnstore index in SQL Server 2014 or 2016<\/a><\/p>\n

FIX: “Non-yielding Scheduler” condition occurs for query with many expressions in SQL Server 2014<\/a><\/p>\n

FIX: Access violation for spatial datatypes query via linked server in SQL Server 2014<\/a><\/p>\n

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

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

\n

FIX: Warning and incorrect computed column results after applying hotfix 3213683 and trace flag 176<\/a><\/p>\n

FIX: “Message 611” error when you use BULK INSERT or INSERT SELECT to insert data into a clustered columnstore index<\/a><\/p>\n

FIX: Access violation may occur when you cancel a pending query if the missing indexes feature is enabled in SQL Server 2014<\/a> <\/p>\n

FIX: Change tracking manual cleanup fails with table non-existence error in SQL Server 2014 and 2017<\/a><\/p>\n

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

SQL Server 2014 SP2 Cumulative Update 9<\/a><\/strong> (Build 12.0.5563), 8 total public hot fixes<\/strong><\/p>\n

\n

FIX: SELECT query that uses batch mode hash aggregate operator that counts multiple nullable columns returns incorrect results in SQL Server<\/a><\/p>\n

FIX: “Invalid comparison due to NO COLLATION” retail assert occurs in SQL Server 2014<\/a><\/p>\n

FIX: Error when you rebuild a single partition of an index online in SQL Server 2014<\/a><\/p>\n

FIX: Alert Engine reads complete Application event log and sends alerts on old events after Windows is restarted<\/a><\/p>\n

FIX: UPDATE statement fails silently when you reference a nonexistent partition function in the WHERE clause in SQL Server 2014<\/a><\/p>\n

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

FIX: Can’t enable or disable change data capture for a database after you attach it in SQL Server 2014<\/a> <\/p>\n

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

SQL Server 2014 SP2 Cumulative Update 10<\/a> <\/strong>(Build 12.0.5571), 5 total public hot fixes<\/strong><\/p>\n

\n

FIX: An access violation error occurs when you execute a stored procedure that references a large object in SQL Server 2014<\/a><\/p>\n

FIX: Intermittent 9004 error when a backup is restored with Standby Mode in SQL Server 2014<\/a><\/p>\n

FIX: A REDO thread is not available in the secondary replica after an availability database is dropped in SQL Server 2012 and 2014<\/a><\/p>\n

FIX: Out of memory error when virtual address space of SQL Server process is very low in SQL Server 2014<\/a><\/p>\n<\/blockquote>\n

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

SQL Server 2014 SP2 Cumulative Update 11<\/a><\/strong> (Build 12.0.5579), 10 total public hot fixes<\/strong><\/p>\n

\n

FIX: EXCEPTION_ACCESS_VIOLATION for query using sys.dm_os_memory_objects statement in SQL Server 2016 or 2017<\/a> <\/p>\n

FIX: It takes a long time to restore a TDE encrypted database backup in SQL Server<\/a> <\/p>\n

FIX: AG failover occurs after a latch time-out when you use SQL Server 2014<\/a> <\/p>\n

FIX: Error 9002 when there is no sufficient disk space for critical log growth in SQL Server 2014 and 2016<\/a> <\/p>\n

FIX: Significantly increased PAGELATCH_EX contentions in sys.sysobjvalues in SQL Server 2014<\/a> <\/p>\n

FIX: SQL Server does not detect a deadlock condition when you run a merge statement<\/a> <\/p>\n

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

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

\n

FIX: Database can’t be dropped after its storage is disconnected and reconnected in SQL Server<\/a><\/p>\n

Transaction Log “full” even when there is sufficient space available and Autogrowth is enabled in SQL Server<\/a><\/p>\n

FIX: A memory leak occurs in sqlwepxxx.dll causes the WmiPrvSe.exe process to crash<\/a><\/p>\n

FIX: Worker thread hangs after another thread is aborted when running a parallel query in SQL Server<\/a><\/p>\n

FIX: Access violation occurs when you query a table with an integer column in SQL Server 2017 and SQL Server 2016<\/a><\/p>\n

SECURITY_CRYPTO_CONTEXT_MUTEX waits cause SQL Server 2016 to stop responding to client requests in SQL Server 2014 and 2016<\/a><\/p>\n

FIX: Access violation when you try to access a table when page compression is enabled on the table in SQL Server<\/a><\/p>\n

FIX: Change tracking record is inconsistent during an update on a table that has a clustered or unique index in SQL Server<\/a><\/p>\n

FIX: A dead latch condition occurs when you run an online index rebuild or a merge command in SQL Server<\/a><\/p>\n

FIX: “Corrupted index” message and server disconnection when an update statistics query uses hash aggregate on SQL Server<\/a><\/p>\n

FIX: TDE database goes offline during log flush if you lose connection to the EKM provider in SQL Server<\/a> <\/p>\n

FIX: TDE-enabled backup and restore are slow if the encryption key is stored in an EKM provider in SQL Server<\/a> <\/p>\n

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

SQL Server 2014 SP2 Cumulative Update 13<\/a><\/strong> (Build 12.0.5590), 4 total public hot fixes<\/strong><\/p>\n

\n

FIX: Access violation when you query the sysmembers system table in SQL Server<\/a><\/p>\n

FIX: Error occurs when you run sp_send_dbmail stored procedure that contains comma in sender email address and name in SQL Server 2014<\/a><\/p>\n

FIX: Error 3906 when a hotfix is applied on a server that has a SQL Server database snapshot on a pull subscription database<\/a><\/p>\n<\/blockquote>\n

 <\/p>\n

SQL Server 2014 SP2 Cumulative Update 14<\/a><\/strong> (Build 12.0.5600), 6 total public hot fixes<\/strong><\/p>\n

\n

FIX: Access violation error occurs when you run a query that uses the XML data type in SQL Server 2014<\/a><\/p>\n

FIX: Overestimations when you use the default Cardinality Estimator to run a query on a table that contains many null values<\/a><\/p>\n

FIX: Access violation when you run a query that uses a INSERT INTO \u2026 SELECT statement to insert data into a clustered columnstore index<\/a><\/p>\n

FIX: Incorrect results occur when you convert ‘pollinginterval’ parameter from seconds to hours in sys.sp_cdc_scan in SQL Server 2014 and 2016<\/a><\/p>\n

FIX: Out of memory error when executing a query on a table that has a large full-text index in SQL Server 2014<\/a> <\/p>\n<\/blockquote>\n

 <\/p>\n

SQL Server 2014 SP2 Cumulative Update 15<\/a><\/strong> (Build 12.0.5605), 7 total public hot fixes<\/strong><\/p>\n

\n

FIX: Intermittent failures when you back up to Azure storage from SQL Server<\/a><\/p>\n

FIX: I\/O errors on a BPE file causes buffer time out in SQL Server<\/a> <\/p>\n

FIX: Internal error messages when you update a FILESTREAM tombstone system table in SQL Server<\/a> <\/p>\n

FIX: Out of memory error occurs when Database Node Memory (KB) drops below 2% in SQL Server 2014<\/a> <\/p>\n

FIX: Stored procedure output parameter(s) may return incorrectly when called through RPC with PREPARE option in SQL Server 2014<\/a> <\/p>\n

FIX: “Non-yielding” error occurs when there is a heavy use of prepared statements in SQL Server 2014<\/a><\/p>\n<\/blockquote>\n

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

SQL Server 2014 SP2 Cumulative Update 16<\/a><\/strong> (Build 12.0.5626), 3 total public hot fixes<\/strong><\/p>\n

\n

FIX: Assertion occurs when a parallel query deletes from a Filestream table<\/a><\/p>\n

FIX: Filtered index may be corrupted when you rebuild index in parallel in SQL Server 2014<\/a><\/p>\n<\/blockquote>\n

<\/font> <\/p>\n

SQL Server 2014 SP2 Cumulative Update 17<\/a><\/strong> (Build 12.0.5632), 3 total public hot fixes<\/strong><\/p>\n

\n

FIX: Fail to join the secondary replica if the database has a defunct filegroup in SQL Server 2014<\/a><\/p>\n

FIX: Columnstore filter pushdown may return wrong results when there is an overflow in filter expressions in SQL Server 2014<\/a><\/p>\n<\/blockquote>\n

<\/font> <\/p>\n

SQL Server 2014 SP2 Cumulative Update 18<\/a><\/strong> (Build 12.0.5687), 4 total public hot fixes<\/strong><\/p>\n

\n

FIX: Prolonged non-transactional usage of FileTable without instance restart may cause non-yielding scheduler error or server crash in SQL Server 2014<\/a><\/p>\n

FIX: Fix prefast warnings (62100) in Sql\\Sqlrepl\\xpreplclr.net\\ReplCmdDataReader.cs to prevent against SQL injection attacks<\/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 July 29, 2019, there have been eighteen Cumulative Updates (CU) for the Service Pack 2 branch of SQL Server 2014. There have been a large number of hotfixes in most of these cumulative updates. SP2 CU18 is the final CU for SQL Server 2014 SP2, since SQL Server 2014 fell out of Mainstream […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,156],"tags":[315,243],"class_list":["post-1168","post","type-post","status-publish","format-standard","hentry","category-sql-server-cumulative-updates","category-sql-server-2014","tag-sql-server-cumulative-updates","tag-sql-server-2014-cumulative-updates"],"yoast_head":"\nPerformance and Stability Related Fixes in Post-SQL Server 2014 SP2 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-sp2-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 SP2 Builds - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"As of July 29, 2019, there have been eighteen Cumulative Updates (CU) for the Service Pack 2 branch of SQL Server 2014. There have been a large number of hotfixes in most of these cumulative updates. SP2 CU18 is the final CU for SQL Server 2014 SP2, since SQL Server 2014 fell out of Mainstream […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp2-builds\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-19T22:17:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-08-01T15:21: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=\"15 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-sp2-builds\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp2-builds\/\",\"name\":\"Performance and Stability Related Fixes in Post-SQL Server 2014 SP2 Builds - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2017-03-19T22:17:02+00:00\",\"dateModified\":\"2019-08-01T15:21: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-sp2-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-sp2-builds\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp2-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 SP2 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 SP2 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-sp2-builds\/","og_locale":"en_US","og_type":"article","og_title":"Performance and Stability Related Fixes in Post-SQL Server 2014 SP2 Builds - Glenn Berry","og_description":"As of July 29, 2019, there have been eighteen Cumulative Updates (CU) for the Service Pack 2 branch of SQL Server 2014. There have been a large number of hotfixes in most of these cumulative updates. SP2 CU18 is the final CU for SQL Server 2014 SP2, since SQL Server 2014 fell out of Mainstream […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp2-builds\/","og_site_name":"Glenn Berry","article_published_time":"2017-03-19T22:17:02+00:00","article_modified_time":"2019-08-01T15:21:30+00:00","author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"15 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-sp2-builds\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp2-builds\/","name":"Performance and Stability Related Fixes in Post-SQL Server 2014 SP2 Builds - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2017-03-19T22:17:02+00:00","dateModified":"2019-08-01T15:21: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-sp2-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-sp2-builds\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-sp2-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 SP2 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\/1168","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=1168"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1168\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}