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":857,"date":"2013-12-03T13:35:47","date_gmt":"2013-12-03T21:35:47","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=857"},"modified":"2018-11-13T10:51:54","modified_gmt":"2018-11-13T18:51:54","slug":"performance-and-stability-related-fixes-in-post-sql-server-2012-sp1-builds","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-sp1-builds\/","title":{"rendered":"Performance and Stability Related Fixes in Post-SQL Server 2012 SP1 Builds"},"content":{"rendered":"

Updated to include SP1 CU9<\/u><\/strong>: There have already been nine Cumulative Updates (CU) for the Service Pack 1 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 over the past eighteen months. SQL Server 2012 SP1 has all of the fixes through SQL Server 2012 RTM CU2. If you are running SQL Server 2012, I really think<\/u><\/strong> you should be running the latest SQL Server 2012 Service Pack and Cumulative Update. Right now, that means Service Pack 1, CU9 (Build 11.0.3412).<\/p>\n

This table shows the SP1 CU builds that have been released so far.<\/p>\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.3000<\/td>\nSP1 RTM<\/td>\nNovember 7, 2012<\/td>\n<\/tr>\n
11.0.3321<\/td>\nSP1 CU1<\/td>\nNovember 20, 2012<\/td>\n<\/tr>\n
11.0.3339<\/td>\nSP1 CU2<\/td>\nJanuary 21, 2013<\/td>\n<\/tr>\n
11.0.3349<\/td>\nSP1 CU3<\/td>\nMarch 18, 2013<\/td>\n<\/tr>\n
11.0.3368<\/td>\nSP1 CU4<\/td>\nMay 30, 2013<\/td>\n<\/tr>\n
11.0.3373<\/td>\nSP1 CU5<\/td>\nJuly 15, 2013<\/td>\n<\/tr>\n
11.0.3381<\/td>\nSP1 CU6<\/td>\nSeptember 16, 2013<\/td>\n<\/tr>\n
11.0.3393<\/td>\nSP1 CU7<\/td>\nNovember 18, 2013<\/td>\n<\/tr>\n
11.0.3401<\/td>\nSP1 CU8<\/td>\nJanuary 20, 2014<\/td>\n<\/tr>\n
11.0.3412<\/td>\nSP1 CU9<\/td>\nMarch 17, 2014<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

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

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

The SQL Server 2012 builds that were released after SQL Server 2012 Service Pack 1 was released<\/a> <\/p>\n

Like I did in my previous post<\/a>, I decided to scan the hotfix list for all of the Cumulative Updates in the SP1 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 SQL Server 2012 features you are using. <\/p>\n

Here are the fixes in the RTM branch, before Service Pack 1 was released (you will get these when you install SP1): <\/p>\n

SQL Server 2012 RTM Cumulative Update 1<\/strong><\/a>  (Build 11.0.2316) , 65 total public hot fixes<\/strong> <\/p>\n

\n

FIX: Low CPU spikes at a set interval even without user activity in SQL Server 2008 R2 or in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: Slow performance when an AFTER trigger runs on a partitioned table in SQL Server 2008 R2 or in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: It takes a long time to restore a database in SQL Server 2008 R2 or in SQL Server 2008 or in SQL 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: Poor performance when you run a query that contains correlated AND predicates in SQL Server 2008 or in SQL Server 2008 R2 or in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: Slow performance occurs in SQL Server 2008 R2 or in SQL Server 2012 if high CPU usage is observed with contention over the QUERY_EXEC_STATS spinlock<\/a><\/p>\n<\/blockquote>\n

\n

FIX: Out-of-memory error when you run SQL Server 2012 on a computer that uses NUMA<\/a><\/p>\n<\/blockquote>\n

SQL Server 2012 RTM Cumulative Update 2<\/strong><\/a>  (Build 11.0.2325) , 37 total public hot fixes<\/strong> <\/p>\n

\n

FIX: An access violation occurs intermittently when you run a query against a table that has a columnstore index in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

  <\/p>\n

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

SQL Server 2012 SP1 Cumulative Update 1<\/strong><\/a> (Build 11.0.3321), 44 total public hot fixes<\/strong> <\/p>\n

\n

FIX: \u201cout of memory\u201d error when you use ODBC with SQL Server 2012, SQL Server 2008 R2 or SQL Server 2008<\/a><\/p>\n<\/blockquote>\n

\n

FIX: Performance of a SELECT statement that contains a LIKE operator and an ESCAPE clause is low in SQL Server 2008 R2 or in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: SQL Server 2012, SQL Server 2008 R2 or SQL Server 2008 stops responding and a \u201cNon-yielding Scheduler\u201d error is logged<\/a><\/p>\n<\/blockquote>\n

\n

FIX: Slow performance or deadlock when you restore a database and execute statements at the same time in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: Worker threads do not wake up immediately when multiple I\/O-intensive tasks are running at the same in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: \u201cProcess appears to be non-yielding on Scheduler \u201d error message when you run a query in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

SQL Server 2012 SP1 Cumulative Update 2<\/strong><\/a> (Build 11.0.3339), 50 total public hot fixes<\/strong> <\/p>\n

\n

A database transaction log continues to grow after you upgrade to SQL Server 2012, SQL Server 2008 R2 SP1, SQL Server 2008 SP2 or SQL Server 2008 SP3<\/a><\/p>\n<\/blockquote>\n

\n

FIX: The size of a database file is not reduced when you use the DBCC SHRINKFILE command in SQL Server 2008 R2 or in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: High CPU usage when you query a binary large object column by using the NOLOCK hint in SQL Server 2008 R2 or in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: Large queries that modify data run slower than expected when many locks accumulate in a SQL Server 2008 R2 or in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: A transaction log restore operation takes longer than expected and a 3402 error occurs if a database file is removed in SQL Server 2008 R2 or in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

SQL Server 2012 experiences out-of-memory errors<\/a><\/p>\n<\/blockquote>\n

\n

FIX: Deadlocks occur when you execute a stored procedure to alter a temporary table if lock partitioning is enabled in SQL Server 2008 R2 or in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: Memory leak if you enable the AUTO_UPDATE_STATISTICS_ASYNC statistics option in SQL Server 2008, in SQL Server 2012 or in SQL Server 2008 R2<\/a><\/p>\n<\/blockquote>\n

\n

FIX: A \u201cnon-yielding\u201d error occurs on a server for Service Broker Message Forwarding in SQL Server 2008 R2 or in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: Error 17883 when you run a query on a server that has many CPUs and a large amount of memory in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

SQL Server 2012 SP1 Cumulative Update 3<\/strong><\/a> (Build 11.0.3349), 38 total public hot fixes<\/strong> <\/p>\n

\n

FIX: Access violation when you run a query that contains many constant values in an IN clause in SQL Server 2008 or in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: Memory leak when you run queries against a temporary table in a nested stored procedure in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: Poor performance in SQL Server 2012 when you run a SQL Server trace<\/a><\/p>\n<\/blockquote>\n

\n

FIX: You experience poor performance when you run a query against an RCSI-enabled table in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: CPU spike when there is no load on a server after you install SQL Server 2012 on the server<\/a><\/p>\n<\/blockquote>\n

\n

SQL Server 2012 experiences performance issues in NUMA environments<\/a><\/p>\n<\/blockquote>\n

SQL Server 2012 SP1 Cumulative Update 4<\/strong><\/a> (Build 11.0.3368), 38 total public hot fixes<\/strong> <\/p>\n

\n

FIX: Out-of-memory errors related to a memory clerk in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: Out of memory error when you build a columnstore index on partitioned tables in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

Update that improves the Service Broker when you send messages to remote servers in SQL Server 2012 is available<\/a><\/p>\n<\/blockquote>\n

\n

An update is available for SQL Server 2012 Memory Management<\/a><\/p>\n<\/blockquote>\n

\n

FIX: \u201cNon-yielding Scheduler\u201d error occurs when you insert a row in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

\n

FIX: You may experience performance issues in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

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

\n

FIX: Poor performance when you run a query that uses the LIKE operator in the WHERE clause in SQL Server 2008 R2<\/a><\/p>\n<\/blockquote>\n

\n

FIX: Non-yielding scheduler error when you run a stored procedure that uses a TVP in SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

SQL Server 2012 SP1 Cumulative Update 6<\/strong><\/a> (Build 11.0.3381), 24 total public hot fixes<\/strong> <\/p>\n

\n

FIX: Slow performance on SQL Server 2012 linked server when you update the data together with different collation on the remote server<\/a><\/p>\n<\/blockquote>\n

\n

FIX: A memory leak occurs when you enable AlwaysOn Availability Groups or SQL Server failover cluster in Microsoft SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

SQL Server 2012 SP1 Cumulative Update 7<\/strong><\/a> (Build 11.0.3393), 47 total public hotfixes<\/strong><\/font> <\/p>\n

\n

FIX: Access violation when you trace an RPC event class by using SQL profiler or XEvents in SQL Server 2012<\/a> <\/p>\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 2008, SQL Server 2008 R2 or SQL Server 2012<\/a> <\/p>\n

FIX: The threads are not scheduled evenly in SQL Server 2012 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<\/a> <\/p>\n

FIX: \u201cNon-yielding Resource Monitor\u201d when you run a workload that executes concurrent queries in SQL Server 2012<\/a> <\/p>\n

FIX: Function sys.fn_hadr_backup_is_preferred_replica costs almost all the CPU usage in Log Shipping in SQL Server 2012<\/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 instance<\/a> <\/p>\n

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

An access violation occurs when \u201csys.dm_db_index_physical_stats\u201d is used in an IF EXISTS statement in an SQL query in SQL Server 2012<\/a> <\/p>\n

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

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

FIX: Slow performance in SQL Server 2012 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<\/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<\/a><\/p>\n<\/blockquote>\n

SQL Server 2012 SP1 Cumulative Update 8<\/a><\/strong> (Build 11.0.3401), 32 total public hotfixes<\/strong><\/font> <\/p>\n

\n

FIX: Data purity corruption in sys.sysbinobjs table in master database when you log on to SQL Server 2008 R2 or SQL Server 2012 by using the SA account and then run DBCC CHECKDB<\/a><\/p>\n

FIX: Interrupted distributed query may return partial result set without any error in SQL Server 2008 R2 or in SQL Server 2012<\/a><\/p>\n

FIX: Replication Log Reader Agent fails when you enable CDC and transactional replication for some columns in SQL Server 2008 R2 or SQL Server 2012<\/a><\/p>\n

FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012<\/a> <\/p>\n

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

FIX: Access violation may occur when you query sys.dm_server_memory_dumps in SQL Server 2008 R2 or SQL Server 2012<\/a> <\/p>\n

FIX: Replication Queue Reader Agent crashes when you run transactional replication in SQL Server 2008 R2 or SQL Server 2012<\/a> <\/p>\n

FIX: Validation of service accounts takes a long time when you set up SQL Server 2012<\/a> <\/p>\n

FIX: The system function sys.fn_hadr_backup_is_preferred_replica does not work correctly after you have CU7 for SQL Server 2012 SP1 installed<\/a> <\/p>\n

FIX: The query deadlocks when the ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT are enabled in SQL Server 2012<\/a> <\/p>\n

FIX: The clustered index table may take longer than you expect to be rebuilt when you use the ALTER INDEX REBUILD statement in SQL Server 2008 or SQL Server 2012<\/a><\/p>\n<\/blockquote>\n

SQL Server 2012 SP1 Cumulative Update 9<\/a><\/strong> (Build 11.0.3412), 30 total public hotfixes<\/strong><\/font> <\/p>\n

\n

FIX: Access violation in SQL Server internal deadlock monitor when you run multiple applications together with Multiple Active Result Sets enabled in SQL Server 2008 R2 or in SQL Server 2012<\/a> <\/p>\n

FIX: Access violation in replication Distribution Agent in SQL Server 2008 R2 or SQL Server 2012 Transactional Replication<\/a> <\/p>\n

FIX: Poor performance when many table-valued parameters are used in SQL Server 2008 R2 or SQL Server 2012<\/a> <\/p>\n

FIX: Merge Agent fails or you experience non-convergence when you use a custom stored procedure conflict resolver in SQL Server 2008 or SQL Server 2008 R2 or SQL Server 2012<\/a> <\/p>\n

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

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

FIX: Operating system version information that is returned from SQL Server 2008 or SQL Server 2008 R2 or SQL Server 2012 is incorrect in Windows 8.1<\/a> <\/p>\n

FIX: Performance decreases after an ALTER INDEX\u2026ONLINE operation is aborted in SQL Server 2012<\/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<\/a> <\/p>\n

FIX: Database shows “recovery pending” state when you use TDE with EKM provider in SQL Server 2012<\/a> <\/p>\n

FIX: Incorrect usage of built-in FORMAT function brings down SQL Server 2012 Instance <\/p>\n

FIX: SQL Server 2012 instance shuts down when you join database as secondary replica during AlwaysOn Availability Groups configuration<\/a> <\/p>\n

FIX: Merge agent fails when you apply snapshot in SQL Server 2012 instance if cross database dependencies are present<\/a> <\/p>\n

FIX: Distribution Agent skips applying sp_MSins_, sp_MSupd_, sp_MSdel_ stored procedures on a Subscriber that is initialized with Backup in SQL Server 2012<\/a> <\/p>\n

FIX: Access violation occurs when you update a table that has an XML calculated column in SQL Server 2012<\/a> <\/p>\n

FIX: SQL Server takes long time to open the databases after the recovery phase when the number of databases or database files or both is large in SQL Server 2012<\/a> <\/p>\n

FIX: Message is not removed from transmission queue even though the ACK is received successfully in an AlwaysOn availability group in SQL Server 2012<\/a> <\/p>\n

FIX: Non-yielding scheduler tries to close the listener for availability group in SQL Server 2012<\/a> <\/p>\n

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

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 1 branch.<\/p>\n","protected":false},"excerpt":{"rendered":"

Updated to include SP1 CU9: There have already been nine Cumulative Updates (CU) for the Service Pack 1 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 over the past eighteen months. SQL Server 2012 […]<\/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,31],"tags":[199],"class_list":["post-857","post","type-post","status-publish","format-standard","hentry","category-sql-server-cumulative-updates","category-microsoft","category-sql-server-2012","tag-sql-server-2012-sp1-cu8"],"yoast_head":"\nPerformance and Stability Related Fixes in Post-SQL Server 2012 SP1 Builds - Glenn Berry<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-sp1-builds\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Performance and Stability Related Fixes in Post-SQL Server 2012 SP1 Builds - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Updated to include SP1 CU9: There have already been nine Cumulative Updates (CU) for the Service Pack 1 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 over the past eighteen months. SQL Server 2012 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-sp1-builds\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2013-12-03T21:35:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-13T18:51:54+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-sp1-builds\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-sp1-builds\/\",\"name\":\"Performance and Stability Related Fixes in Post-SQL Server 2012 SP1 Builds - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2013-12-03T21:35:47+00:00\",\"dateModified\":\"2018-11-13T18:51:54+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-sp1-builds\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-sp1-builds\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-sp1-builds\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performance and Stability Related Fixes in Post-SQL Server 2012 SP1 Builds\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\",\"name\":\"Glenn Berry\",\"description\":\"Semi-random musings about SQL Server performance\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\",\"name\":\"Glenn Berry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"caption\":\"Glenn Berry\"},\"sameAs\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Performance and Stability Related Fixes in Post-SQL Server 2012 SP1 Builds - Glenn Berry","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-sp1-builds\/","og_locale":"en_US","og_type":"article","og_title":"Performance and Stability Related Fixes in Post-SQL Server 2012 SP1 Builds - Glenn Berry","og_description":"Updated to include SP1 CU9: There have already been nine Cumulative Updates (CU) for the Service Pack 1 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 over the past eighteen months. SQL Server 2012 […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-sp1-builds\/","og_site_name":"Glenn Berry","article_published_time":"2013-12-03T21:35:47+00:00","article_modified_time":"2018-11-13T18:51:54+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-sp1-builds\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-sp1-builds\/","name":"Performance and Stability Related Fixes in Post-SQL Server 2012 SP1 Builds - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2013-12-03T21:35:47+00:00","dateModified":"2018-11-13T18:51:54+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-sp1-builds\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-sp1-builds\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-and-stability-related-fixes-in-post-sql-server-2012-sp1-builds\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Performance and Stability Related Fixes in Post-SQL Server 2012 SP1 Builds"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/","name":"Glenn Berry","description":"Semi-random musings about SQL Server performance","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/glenn\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7","name":"Glenn Berry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","caption":"Glenn Berry"},"sameAs":["https:\/\/www.sqlskills.com\/blogs\/glenn\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/857","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=857"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/857\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}