{"id":946,"date":"2015-03-27T12:56:23","date_gmt":"2015-03-27T19:56:23","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=946"},"modified":"2018-11-13T10:52:28","modified_gmt":"2018-11-13T18:52:28","slug":"performance-and-stability-related-fixes-in-post-sql-server-2012-sp2-builds","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-sp2-builds\/","title":{"rendered":"Performance and Stability Related Fixes in Post-SQL Server 2012 SP2 Builds"},"content":{"rendered":"

As of May 16, 2016, there have been twelve Cumulative Updates (CU) for the Service Pack 2 branch of SQL Server 2012. There have been a fairly high number of hotfixes in every one of these Cumulative Updates, as more people are using SQL Server 2012. If you are running SQL Server 2012 Service Pack 2, I really think<\/u><\/strong> you should be running the latest SQL Server 2012 Cumulative Update. Right now, that means Service Pack 2, CU12 (Build 11.0.5649), which was released on May 16, 2016. Ideally, you should be moving to SQL Server 2012 Service Pack 3, which was released on November 22, 2015. <\/p>\n

If you are still on the SQL Server 2012 SP1 branch, then you want to be on SP1 CU16. But really, you should be on the SP2 branch as soon as possible, since the SP1 branch is no longer a supported branch. Actually, it you are still on the SP1 branch, you should jump to the SP3 branch, and skip SP2.<\/p>\n

Table 1 shows the SQL Server 2012 SP2 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
11.0.5058<\/td>\nSP2 RTM<\/td>\nJune 10, 2014<\/td>\n<\/tr>\n
11.0.5532<\/td>\nSP2 CU1<\/td>\nJuly 23, 2014<\/td>\n<\/tr>\n
11.0.5548<\/td>\nSP2 CU2<\/td>\nSeptember 15, 2014<\/td>\n<\/tr>\n
11.0.5556<\/td>\nSP2 CU3<\/td>\nNovember 17, 2014<\/td>\n<\/tr>\n
11.0.5569<\/td>\nSP2 CU4<\/td>\nJanuary 19, 2015<\/td>\n<\/tr>\n
11.0.5582<\/td>\nSP2 CU5<\/td>\nMarch 16, 2015<\/td>\n<\/tr>\n
11.0.5592<\/td>\nSP2 CU6<\/td>\nMay 18, 2015<\/td>\n<\/tr>\n
11.0.5623<\/td>\nSP2 CU7<\/td>\nJuly 20, 2015<\/td>\n<\/tr>\n
11.0.5634<\/td>\nSP2 CU8<\/td>\nSeptember 21, 2015<\/td>\n<\/tr>\n
11.0.5641<\/td>\nSP2 CU9<\/td>\nNovember 16, 2015<\/td>\n<\/tr>\n
11.0.5644<\/td>\nSP2 CU10<\/td>\nJanuary 18, 2016<\/td>\n<\/tr>\n
11.0.5646<\/td>\nSP2 CU11<\/td>\nMarch 21, 2016<\/td>\n<\/tr>\n
11.0.5649<\/td>\nSP2 CU12<\/td>\nMay 16, 2016<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

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

  <\/p>\n

You can follow the KB article link below to see all of the CU builds for the SQL Server 2012 Service Pack 2 branch. <\/p>\n

\n

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

Like I did for the SQL Server 2012 SP1 branch<\/a>, 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. You may come up with a completely different list, based on what specific SQL Server 2012 features you are using. <\/p>\n

Here are the fixes in the Service Pack 2 branch: <\/p>\n

SQL Server 2012 SP2 Cumulative Update 1<\/a><\/strong> (Build 11.0.5532), 43 total public hot fixes<\/strong> <\/p>\n

\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: 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: Poor performance on I\/O when you execute select into temporary table operation in SQL Server 2012<\/a> <\/p>\n

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

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

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

SQL Server 2012 SP2 Cumulative Update 2<\/a><\/strong> (Build 11.0.5548), 43 total public hot fixes<\/strong> <\/p>\n

\n

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

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

FIX: Memory leak occurs when you start and stop an XEvent session repeatedly in SQL Server 2012<\/a> <\/p>\n

FIX: Cannot reclaim unused space by using shrink operation in the table that contains a LOB column in SQL Server<\/a> <\/p>\n

FIX: Undetected deadlock occurs when you use a sequence object in SQL Server 2012<\/a> <\/p>\n

FIX: Performance improvement for SQL Server Spatial data access in SQL Server 2012<\/a> <\/p>\n

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

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

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

SQL Server 2012 SP2 Cumulative Update 3<\/a><\/strong> (Build 11.0.5556), 32 total public hot fixes<\/strong> <\/p>\n

\n

FIX: Poor performance for cdc.fn_cdc_get_net_changes_<capture_instance> in SQL Server 2012 SP2<\/a> <\/p>\n

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

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

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

FIX: Large chain of blocking occurs when you use merge replication in SQL Server 2012<\/a> <\/p>\n

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

SQL Server 2012 SP2 Cumulative Update 4<\/a><\/strong> (Build 11.0.5569), 36 total public hot fixes<\/strong> <\/p>\n

\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: Sequence object generates duplicate sequence values when SQL Server 2012 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

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

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

SQL Server 2012 SP2 Cumulative Update 5<\/a><\/strong> (Build 11.0.5582), 27 total public hot fixes<\/strong> <\/p>\n

\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: Memory leak in USERSTORE_SCHEMAMGR and CPU spikes occur when you use temp table in SQL Server 2012<\/a> <\/p>\n

FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING<\/a> <\/p>\n

FIX: Complex parallel query does not respond in SQL Server 2012<\/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: SQL Server 2012 shuts down unexpectedly when you run DBCC CHECKDB and the rollback recovery on the snapshot fails<\/a> <\/p>\n<\/blockquote>\n

 <\/p>\n

SQL Server 2012 SP2 Cumulative Update 6<\/a><\/strong> (Build 11.0.5592), 23 total public hot fixes<\/strong> <\/p>\n

\n

FIX: Corruption occurs on the page of secondary replica when you change the secondary replica to unreadable<\/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 when a missing task for a background clear operation tries to delete a missing index entry<\/a><\/p>\n<\/blockquote>\n

 <\/p>\n

SQL Server 2012 SP2 Cumulative Update 7<\/a><\/strong> (Build 11.0.5623), 32 total public hot fixes<\/strong> <\/p>\n

\n

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

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

FIX: “Unable to create restore plan due to break in the LSN chain” error when you restore differential backup in SSMS<\/a><\/p>\n

FIX: Indexed view returns incorrect result after insert or delete operation on the base table in SQL Server 2012<\/a><\/p>\n

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

FIX: Error messages are logged when you execute a non-cacheable auto-parameterized query in SQL Server 2012<\/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<\/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: Out of memory error when the virtual address space of the SQL Server process is very low on available memory<\/a><\/p>\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<\/a><\/p>\n

FIX: Contention occurs when you execute many ad-hoc queries in SQL Server 2012<\/a><\/p>\n

FIX: You receive incorrect results from the CHANGETABLE() function when snapshot isolation for a SQL Server 2012 database<\/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 SP2<\/a><\/p>\n<\/blockquote>\n

 <\/p>\n

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

\n

FIX: A stalled dispatcher system dump forces a failover and service outage in SQL Server 2014 or SQL Server 2012<\/a><\/p>\n

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

FIX: Data spill occurs when you sort large amount of data in SQL Server 2012<\/a><\/p>\n

FIX: FileStream Share Access fails when you use AlwaysOn Availability Groups feature in SQL Server 2012<\/a><\/p>\n

FIX: Rare incorrect result occurs when you run parallel query in SQL Server 2012<\/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

FIX: Access violation occurs in AlwaysOn availability groups scenarios in SQL Server 2012<\/a><\/p>\n

FIX: Access violations when you use the FileTable feature in SQL Server 2012<\/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: SQLDiag fails with function 87 error in SQL AlwaysOn scenario where the server name has 15 characters<\/a><\/p>\n

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

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

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

SQL Server 2012 SP2 Cumulative Update 9<\/a><\/strong> (Build 11.0.5641), 13 total public hot fixes<\/strong> <\/p>\n

\n

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

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

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

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

SQL Server 2012 SP2 Cumulative Update 10<\/a><\/strong> (Build 11.0.5644), 12 total public hot fixes<\/strong> <\/p>\n

\n

FIX: You cannot use the Transport Layer Security protocol version 1.2 to connect to a server that is running SQL Server 2014 or SQL Server 2012<\/a><\/p>\n

FIX: You receive errors when you execute a query that uses tempdb in SQL Server<\/a><\/p>\n

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

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

SQL Server 2012 SP2 Cumulative Update 11<\/a><\/strong> (Build 11.0.5646), 15 total public hot fixes<\/strong> <\/p>\n

\n

FIX: Numeric overflow when you run a query that spills more than 65,535 extents to tempdb in SQL Server 2014 or 2012<\/a><\/p>\n

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

FIX: An assertion failure occurs on the secondary replica when you use the AlwaysOn Availability Groups feature in SQL Server 2012<\/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: “Cannot resolve the collation conflict” error occurs when you apply a snapshot to the subscriber database in SQL Server<\/a><\/p>\n

FIX: Slow performance occurs when you query numeric data types from an Oracle database<\/a><\/p>\n

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

FIX: XA transactions are not cleaned when you exit a Java application in an instance of SQL Server<\/a><\/p>\n

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

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

\n

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

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

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

  <\/p>\n

Once again, the idea here is to give you a lot of concrete reasons<\/strong> to want to stay current with the latest SQL Server 2012 SP and CU, by pointing out some of the more valuable fixes in each CU in the Service Pack 2 branch.  If my opinion does not sway everyone, this relatively new Microsoft KB article might be more convincing: <\/p>\n

\n

Announcing updates to the SQL Server Incremental Servicing Model (ISM)<\/a><\/p>\n<\/blockquote>\n

Another very useful resource is this Microsoft KB article:<\/font> <\/p>\n

\n

Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 used with high-performance workloads<\/a><\/p>\n<\/blockquote>\n

Happily, Microsoft has been updating this KB article with new information, so you might want to read it again, if you have not done so already. <\/p>\n

<\/blockquote>\n","protected":false},"excerpt":{"rendered":"

As of May 16, 2016, there have been twelve Cumulative Updates (CU) for the Service Pack 2 branch of SQL Server 2012. There have been a fairly high number of hotfixes in every one of these Cumulative Updates, as more people are using SQL Server 2012. If you are running SQL Server 2012 Service Pack […]<\/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,26,31],"tags":[240],"class_list":["post-946","post","type-post","status-publish","format-standard","hentry","category-sql-server-cumulative-updates","category-microsoft","category-sql-server-service-packs","category-sql-server-2012","tag-sql-server-2012-service-pack-2"],"yoast_head":"\nPerformance and Stability Related Fixes in Post-SQL Server 2012 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-2012-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 2012 SP2 Builds - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"As of May 16, 2016, there have been twelve Cumulative Updates (CU) for the Service Pack 2 branch of SQL Server 2012. There have been a fairly high number of hotfixes in every one of these Cumulative Updates, as more people are using SQL Server 2012. If you are running SQL Server 2012 Service Pack […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-sp2-builds\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2015-03-27T19:56:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-13T18:52:28+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=\"10 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-2012-sp2-builds\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-sp2-builds\/\",\"name\":\"Performance and Stability Related Fixes in Post-SQL Server 2012 SP2 Builds - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2015-03-27T19:56:23+00:00\",\"dateModified\":\"2018-11-13T18:52:28+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-2012-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-2012-sp2-builds\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-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 2012 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 2012 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-2012-sp2-builds\/","og_locale":"en_US","og_type":"article","og_title":"Performance and Stability Related Fixes in Post-SQL Server 2012 SP2 Builds - Glenn Berry","og_description":"As of May 16, 2016, there have been twelve Cumulative Updates (CU) for the Service Pack 2 branch of SQL Server 2012. There have been a fairly high number of hotfixes in every one of these Cumulative Updates, as more people are using SQL Server 2012. If you are running SQL Server 2012 Service Pack […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-sp2-builds\/","og_site_name":"Glenn Berry","article_published_time":"2015-03-27T19:56:23+00:00","article_modified_time":"2018-11-13T18:52:28+00:00","author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"10 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-2012-sp2-builds\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-sp2-builds\/","name":"Performance and Stability Related Fixes in Post-SQL Server 2012 SP2 Builds - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2015-03-27T19:56:23+00:00","dateModified":"2018-11-13T18:52:28+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-2012-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-2012-sp2-builds\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-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 2012 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\/946","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=946"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/946\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}