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":948,"date":"2015-04-21T10:00:06","date_gmt":"2015-04-21T17:00:06","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=948"},"modified":"2017-04-13T12:29:07","modified_gmt":"2017-04-13T19:29:07","slug":"performance-and-stability-related-fixes-in-post-sql-server-2014-rtm-builds","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-rtm-builds\/","title":{"rendered":"Performance and Stability Related Fixes in Post-SQL Server 2014 RTM Builds"},"content":{"rendered":"

As of April 18, 2016, there have been thirteen Cumulative Updates (CU) for the RTM branch of SQL Server 2014. There have been a fairly high number of hotfixes in every one of these Cumulative Updates, as more people are using SQL Server 2014. If you are running SQL Server 2014 RTM, I really think<\/u><\/strong> you should be running the latest SQL Server 2014 RTM Cumulative Update. Right now, that means RTM, CU13 (Build 12.0.2568), which was released on April 18, 2016.  <\/p>\n

Table 1 shows the SQL Server 2014 RTM 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
Build<\/td>\nDescription<\/td>\nRelease Date<\/td>\n<\/tr>\n
12.0.2342<\/td>\nRTM CU1<\/td>\nApril 21, 2014<\/td>\n<\/tr>\n
12.0.2370<\/td>\nRTM CU2<\/td>\nJune 27, 2014<\/td>\n<\/tr>\n
12.0.2402<\/td>\nRTM CU3<\/td>\nAugust 18, 2014<\/td>\n<\/tr>\n
12.0.2430<\/td>\nRTM CU4<\/td>\nOctober 21, 2014<\/td>\n<\/tr>\n
12.0.2456<\/td>\nRTM CU5<\/td>\nDecember 17, 2014<\/td>\n<\/tr>\n
12.0.2480<\/td>\nRTM CU6<\/td>\nFebruary 16, 2015<\/td>\n<\/tr>\n
12.0.2495<\/td>\nRTM CU7<\/td>\nApril 20, 2015<\/td>\n<\/tr>\n
12.0.2546<\/td>\nRTM CU8<\/td>\nJune 19, 2015<\/td>\n<\/tr>\n
12.0.2553<\/td>\nRTM CU9<\/td>\nAugust 17, 2015<\/td>\n<\/tr>\n
12.0.2556<\/td>\nRTM CU10<\/td>\nOctober 19, 2015<\/td>\n<\/tr>\n
12.0.2560<\/td>\nRTM CU11<\/td>\nDecember 21, 2015<\/td>\n<\/tr>\n
12.0.2564<\/td>\nRTM CU12<\/td>\nFebruary 22, 2016<\/td>\n<\/tr>\n
12.0.2568<\/td>\nRTM CU13<\/td>\nApril 18, 2016<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

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

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

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

SQL Server 2014 RTM Cumulative Update 1<\/a><\/strong> (Build 12.0.2342), 114 total public hot fixes<\/strong> <\/p>\n

\n

FIX: Nonclustered index corruption may occur when you run a complex UPDATE statement together with a NOLOCK hint against a table in SQL Server<\/a> <\/p>\n

FIX: Threads are not scheduled evenly in SQL Server 2012 or SQL Server 2014 Standard Edition<\/a> <\/p>\n

A memory leak occurs when a SQL Server Native Client OLE DB provider application calls the Prepare method in SQL Server 2012 or SQL Server 2014<\/a> <\/p>\n

FIX: Slow performance in SQL Server when you build an index on a spatial data type of a large table in a SQL Server 2012 or SQL Server 2014 instance<\/a> <\/p>\n

FIX: Slow performance in SQL Server 2012 or SQL Server 2014 when you build an index on a spatial data type of a large table<\/a> <\/p>\n

FIX: Suboptimal execution plan is generated when you run a query in SQL Server 2012 or SQL Server 2014<\/a> <\/p>\n

Slow SQL Server performance and a memory leak after you apply Cumulative Update 3 for SQL Server 2012 Service Pack 1 or in SQL Server 2014<\/a> <\/p>\n

FIX: Slow performance in SQL Server 2012 or SQL Server 2014 when you build an index on a spatial data type of a large table<\/a> <\/p>\n

Slow performance or error messages are logged when you have a transactional replication publisher server in SQL Server 2012 or SQL Server 2014<\/a> <\/p>\n

FIX: Insufficient system memory error occurs when you try to create an index in a char, varchar, or nvarchar type column in SQL Server 2012 or SQL Server 2014<\/a> <\/p>\n

FIX: A small number of rows are sampled in SQL Server when table statistics are updated automatically or together with specified sampling rate<\/a> <\/p>\n

FIX: Performance problems occur when database lock activity increases in SQL Server 2012 or SQL Server 2014<\/a> <\/p>\n

FIX: Performance problems occur in NUMA environments during foreign page processing in SQL Server 2012 or SQL Server 2014<\/a> <\/p>\n

FIX: Access violation may occur when trigger query joins large dataset in deleted\/inserted table and runs in parallel in SQL server 2012 or SQL Server 2014<\/a> <\/p>\n

FIX: Access violation when you create an index on a no-partitioned table in SQL Server 2014<\/a> <\/p>\n

FIX: SQL Cache Memory decreases and CPU usage increases when you rebuild an index for a table in SQL Server 2014<\/a> <\/p>\n

FIX: Performance decreases after an ALTER INDEX\u2026ONLINE operation is aborted in SQL Server 2012 or SQL Server 2014<\/a> <\/p>\n

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

SQL Server 2014 RTM Cumulative Update 2<\/a><\/strong> (Build 12.0.2370), 47 total public hot fixes<\/strong> <\/p>\n

\n

FIX: Performance problems occur in NUMA environments during foreign page processing in SQL Server 2012 or SQL Server 2014<\/a> <\/p>\n

FIX: Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL Server<\/a> <\/p>\n

FIX: Loads or queries on CCI tables block one another in SQL Server 2014<\/a> <\/p>\n

FIX: Assertion failure when you execute a query specifying TOP N and ORDER BY in SQL Server<\/a> <\/p>\n

FIX: Poor cardinality estimation when the ascending key column is branded as stationary in SQL Server<\/a> <\/p>\n

FIX: Data loss in clustered index occurs when you run online build index in SQL Server 2012 or SQL Server 2014<\/a> <\/p>\n

FIX: Metadata corruption occurs when you update index statistics with INCREMENTAL=ON in SQL Server 2014<\/a> <\/p>\n

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

SQL Server 2014 RTM Cumulative Update 3<\/a><\/strong> (Build 12.0.2402), 31 total public hot fixes<\/strong> <\/p>\n

\n

FIX: Poor performance when you use table variables in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n<\/blockquote>\n

\n

FIX: “Non-yielding scheduler” error when you insert or update many rows in one transaction in SQL Server 2014<\/a> <\/p>\n

FIX: Log Reader Agent crashes during initialization when you use transactional replication in SQL Server<\/a> <\/p>\n

FIX: Cannot create indexed view on a clustered columnstore index and BCP on the table fails in SQL Server 2014<\/a> <\/p>\n

FIX: Auto-statistics creation increases the compilation time for natively compiled stored procedure in SQL Server 2014<\/a> <\/p>\n

FIX: LCK_M_SCH_M occurs when you access memory-optimized table variables outside natively compiled stored procedures<\/a> <\/p>\n

FIX: An access violation occurs when you use UPDATE STATISTICS on a computed column in SQL Server 2014<\/a> <\/p>\n

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

SQL Server 2014 RTM Cumulative Update 4<\/a><\/strong> (Build 12.0.2430), 54 total public hot fixes<\/strong> <\/p>\n

\n

FIX: “Cannot insert duplicate key” error occurs when you update a table by using a bitmap index that contains a partition key in SQL Server<\/a> <\/p>\n

FIX: Parallel deadlock or self-deadlock occurs when you run a query that results in parallelism in SQL Server<\/a> <\/p>\n

FIX: Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL Server 2012 or SQL Server 2014<\/a> <\/p>\n

FIX: A severe error occurs when you run a query that uses CTEs against the partitioned tables in SQL Server<\/a> <\/p>\n

FIX: UPDATE STATISTICS performs incorrect sampling and processing for a table with columnstore index in SQL Server<\/a> <\/p>\n

FIX: Error 7105 when you execute UPDATE on sparse column set while ONLINE INDEX REBUILD is running on the same table in SQL Server<\/a> <\/p>\n

FIX: Schema lock occurs on a table with large data when you delete lots of rows from it in SQL Server 2014<\/a> <\/p>\n

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

SQL Server 2014 RTM Cumulative Update 5<\/a><\/strong> (Build 12.0.2456), 48 total public hot fixes<\/strong> <\/p>\n

\n

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

FIX: INSERT performance decreases in merge replication that uses precomputed partitions in SQL Server 2012 or 2014<\/a> <\/p>\n

FIX: “System objects not be updated” when you use AlwaysOn Availability Groups in SQL Server 2012 or SQL Server 2014<\/a> <\/p>\n

FIX: Error occurs when you open FILESTREAM data that is hosted on dynamic disks in SQL Server 2012 or SQL Server 2014<\/a> <\/p>\n

FIX: SQL Server crashes when you retrieve an SQL statement hash for logging XEvent in SQL Server 2012 or SQL Server 2014<\/a> <\/p>\n

FIX: High CPU consumption when you use spatial data type and associated methods in SQL Server 2012 or SQL Server 2014<\/a> <\/p>\n

FIX: Error when you execute statistics update on a table that has sql_variant data type in SQL Server 2012 or 2014<\/a> <\/p>\n

FIX: “No exceptions should be raised by this code” error when you run parallel query in SQL Server 2014<\/a> <\/p>\n

FIX: Non-yielding error occurs when you execute DML statements in SQL Server 2014<\/a> <\/p>\n

FIX: Error 35377 occurs when you try to access clustered columnstore indexes in SQL Server 2014<\/a> <\/p>\n

FIX: “Non-yielding scheduler” error and AlwaysOn Availability Group transitions to RESOLVING state not Failover<\/a> <\/p>\n

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

SQL Server 2014 RTM Cumulative Update 6<\/a><\/strong> (Build 12.0.2480), 54 total public hot fixes<\/strong> <\/p>\n

\n

FIX: Sequence object generates duplicate sequence values when SQL Server 2012 or SQL Server 2014 is under memory pressure<\/a> <\/p>\n

FIX: SQL Server is in script upgrade mode for a long time after you apply a SQL Server hotfix or security update<\/a> <\/p>\n

Large query compilation waits on RESOURCE_SEMAPHORE_QUERY_COMPILE 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 system table rowset cache causes high CPU usage in SQL Server 2012 or 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: Access violation occurs when you delete rows from a table that has clustered columnstore index in SQL Server 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: OS error 665 when you execute DBCC CHECKDB command for database that contains columnstore index in SQL Server 2014<\/a> <\/p>\n

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

FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING<\/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

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

SQL Server 2014 RTM Cumulative Update 7<\/a><\/strong> (Build 12.0.2495), 41 total public hot fixes<\/strong>   <\/p>\n

\n

FIX: A query that requires nested loops join takes longer to complete 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: Complex parallel query does not respond in SQL Server 2012 or SQL Server 2014<\/a> <\/p>\n

An AlwaysOn secondary replica crashes or raises error 3961 when the AlwaysOn database has CLR UDT in SQL Server 2014<\/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: 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: SQL Server takes long time to open database after recovery to add or remove a data file in SQL Server 2014<\/a> <\/p>\n

FIX: A SELECT query run as a parallel batch-mode scan may cause a deadlock situation in 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

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

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

\n

An “Access Violation” occurs when you connect to an instance of SQL Server 2014<\/a><\/p>\n

FIX: Partial results in a query of a clustered columnstore index in SQL Server 2014<\/a><\/p>\n

FIX: SQL Server may shut down when you use Service Broker in SQL Server 2012 or 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

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: Error 33294 occurs when you alter column types on a table that has clustered columnstore indexes in 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

FIX: Poor performance when a query contains table joins in 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: Paging out in memory occurs when columnstore index query consumes large memory 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

SQL Server in-place upgrade fails if the there’s no JOBS folder<\/a><\/p>\n

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

 <\/p>\n

SQL Server 2014 RTM Cumulative Update 9<\/a><\/strong> (Build 12.0.2553), 30 total public hot fixes<\/strong>   <\/p>\n

\n

FIX: An AlwaysOn database on a secondary replica shows a “NOT SYNCHRONIZING” status 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: 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: 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: Access violation occurs when you execute a query that contains many joins and coalesce functions in SQL Server 2014<\/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: A stalled dispatcher system dump occurs resulting in failover and service outage on the availability groups in 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: Incorrect result when you execute a full-text query with parallel execution plan in SQL Server 2012 or SQL Server 2014<\/a><\/p>\n

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

SQL Server 2014 RTM Cumulative Update 10<\/a><\/strong> (Build 12.0.2556), 31 total public hot fixes<\/strong>   <\/p>\n

\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: 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: Access violations when you use the FileTable feature in SQL Server 2012 or 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: CPU usage is higher than expected when you reduce the value of CAP_CPU_PERCENT argument in creating resource pool<\/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: Error 602 when you run a stored procedure repeatedly in SQL Server 2012 or 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

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

SQL Server 2014 RTM Cumulative Update 11<\/a><\/strong> (Build 12.0.2560), 18 total public hot fixes<\/strong>   <\/p>\n

\n

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

FIX: Assertion failure occurs when you run a query in SQL Server 2014<\/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 use ODBC driver in SQL Server 2014<\/a><\/p>\n

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

FIX: Incorrect result occurs when you run parallel query that contains many-to-many merge join in SQL Server 2014<\/a><\/p>\n

FIX: “Non-yielding Scheduler” occurs when you query a partitioned table with column store index in SQL Server 2014<\/a><\/p>\n

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

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

\n

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

FIX: Numeric overflow occurs when you execute a query that spills more than 65,535 extents to tempdb 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

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

SQL Server 2014 RTM Cumulative Update 13<\/a><\/strong> (Build 12.0.2568), 31 total public hot fixes<\/strong> <\/p>\n

\n

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

FIX: “Non-yielding Scheduler” condition occurs when you run a query in 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

Query plan generation improvement for some columnstore queries in SQL Server 2014<\/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

FIX: The Log Reader Agent stops intermittently and an Access Violation occurs in SQL Server 2012 or 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

\n","protected":false},"excerpt":{"rendered":"

As of April 18, 2016, there have been thirteen Cumulative Updates (CU) for the RTM branch of SQL Server 2014. There have been a fairly high number of hotfixes in every one of these Cumulative Updates, as more people are using SQL Server 2014. If you are running SQL Server 2014 RTM, I really think […]<\/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":[243],"class_list":["post-948","post","type-post","status-publish","format-standard","hentry","category-sql-server-cumulative-updates","category-microsoft","category-sql-server-2014","tag-sql-server-2014-cumulative-updates"],"yoast_head":"\nPerformance and Stability Related Fixes in Post-SQL Server 2014 RTM 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-rtm-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 RTM Builds - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"As of April 18, 2016, there have been thirteen Cumulative Updates (CU) for the RTM branch of SQL Server 2014. There have been a fairly high number of hotfixes in every one of these Cumulative Updates, as more people are using SQL Server 2014. If you are running SQL Server 2014 RTM, I really think […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-rtm-builds\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2015-04-21T17:00:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T19:29:07+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=\"14 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-rtm-builds\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-rtm-builds\/\",\"name\":\"Performance and Stability Related Fixes in Post-SQL Server 2014 RTM Builds - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2015-04-21T17:00:06+00:00\",\"dateModified\":\"2017-04-13T19:29:07+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-rtm-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-rtm-builds\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-rtm-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 RTM 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 RTM 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-rtm-builds\/","og_locale":"en_US","og_type":"article","og_title":"Performance and Stability Related Fixes in Post-SQL Server 2014 RTM Builds - Glenn Berry","og_description":"As of April 18, 2016, there have been thirteen Cumulative Updates (CU) for the RTM branch of SQL Server 2014. There have been a fairly high number of hotfixes in every one of these Cumulative Updates, as more people are using SQL Server 2014. If you are running SQL Server 2014 RTM, I really think […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-rtm-builds\/","og_site_name":"Glenn Berry","article_published_time":"2015-04-21T17:00:06+00:00","article_modified_time":"2017-04-13T19:29:07+00:00","author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"14 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-rtm-builds\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-rtm-builds\/","name":"Performance and Stability Related Fixes in Post-SQL Server 2014 RTM Builds - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2015-04-21T17:00:06+00:00","dateModified":"2017-04-13T19:29:07+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-rtm-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-rtm-builds\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2014-rtm-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 RTM 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\/948","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=948"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/948\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=948"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=948"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=948"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}