This article describes cumulative update package 9 (Build number: 11.0.3412.0) for Microsoft SQL Server 2012 Service Pack 1 (SP1). This update contains hotfixes for issues that were fixed after the release of SQL Server 2012 SP1.
Click "Hotfix Download Available" at the top of this Knowledge Base article. If the "Hotfix Request" page does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.
|VSTS bug number||KB article number||Description||Fix area|
|2027275||2723979||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||SQL service|
|2041570||2861456||FIX: Access violation in replication Distribution Agent in SQL Server 2008 R2 or SQL Server 2012 Transactional Replication||SQL service|
|1852108||2913206||FIX: Cannot pass report parameters to reports in a SharePoint Document Library in SSRS 2008 R2 or SSRS 2012 by using HTML forms||Reporting Services|
|2076868||2920987||FIX: Poor performance when many table-valued parameters are used in SQL Server 2008 R2 or SQL Server 2012||SQL service|
|1993314||2921630||FIX: Incorrect result is returned when you run an MDX query that contains a DRILLTHROUGH statement in SSAS 2008 or SSAS 2008 R2 or SSAS 2012||Analysis Services|
|2076864||2922799||FIX: Unexpected exception is thrown when you convert writeback partition in SSAS 2008 R2 or SSAS 2012||Analysis Services|
|1920886||2922935||FIX: Excel rendering extension produces corrupted files when you use nonprintable codes in SSRS 2012||Reporting Services|
|1993311||2923837||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||SQL service|
|1941216||2924827||FIX: dtexec.exe cannot execute a package when one of the configuration files does not exist in SQL Server 2012||Integration Services|
|1966828||2926089||FIX: Error when you create new report subscriptions after you apply CU7 or CU8 for SQL Server 2012 SP1||SQL security|
|2021036||2926217||FIX: Performance problems occur when database lock activity increases in SQL Server 2012||SQL service|
|2021037||2926223||FIX: Performance problems occur in NUMA environments during foreign page processing in SQL Server 2012||SQL service|
|1972245||2926699||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||SQL service|
|2021038||2926712||FIX: Performance decreases after an ALTER INDEX…ONLINE operation is aborted in SQL Server 2012||SQL service|
|1994633||2927511||FIX: Access violation may occur when trigger query joins large dataset in deleted/inserted table and runs in parallel in SQL server 2012||SQL performance|
|1994687||2927524||FIX: MDX query does not reuse cache after clear cache command on different Measure Group with Non-Admin login in SSAS 2012||Analysis Services|
|2021039||2927748||FIX: PowerPivot workbook cannot do data refresh in SharePoint 2013 after you apply SQL Server 2012 CU7||Analysis Services|
|1999508||2927779||FIX: Database shows "recovery pending" state when you use TDE with EKM provider in SQL Server 2012||SQL security|
|1999683||2927844||FIX: Large DistinctCount become slower in tabular mode in SQL Server 2012||Analysis Services|
|1968031||2929193||FIX: SQL Server 2012 instance shuts down when you join database as secondary replica during AlwaysOn Availability Groups configuration||High Availability|
|1929567||2929832||FIX: Decimal precision is incorrect when you calculate based on size of scale in SQL Server 2012 MDS||Data Quality Services (DQS)|
|1924585||2929903||FIX: Merge agent fails when you apply snapshot in SQL Server 2012 instance if cross database dependencies are present||SQL service|
|2024625||2931001||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||SQL service|
|2032571||2931241||FIX: Access violation occurs when you update a table that has an XML calculated column in SQL Server 2012||SQL service|
|2047687||2932120||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||SQL service|
|2035100||2932340||FIX: Errors when you add member in SQL Server 2012 MDS||DQS|
|2043007||2932341||FIX: Content of member details window is locked when you add a new member to MDS Explorer in SQL Server 2012 MDS||DQS|
|1909862||2933780||FIX: Message is not removed from transmission queue even though the ACK is received successfully in an AlwaysOn availability group in SQL Server 2012||SQL service|
|2022961||2934934||FIX: Non-yielding scheduler tries to close the listener for availability group in SQL Server 2012||High Availability|
|2082516||2935681||FIX: Bing Map functionality does not work in Power View or SSRS 2012||Reporting Services|
Installation and deployment
- We recommend that you test hotfixes before you deploy them in a production environment.
- We recommend that you apply the most recent update release .
- This cumulative package is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems.
- The most recent update release contains all the hotfixes and all the updates that were included with the previous SQL Server 2012 update release.
- We recommend that you upgrade your SQL Server to the latest SQL Server 2012 service pack .
Hybrid environments deployment
When you deploy the hotfixes to a hybrid environment (Such as AlwaysOn, replication, cluster, mirroring, and cluster), we recommend that you go and refer to the following articles before you deploy them:
- SQL Server failover cluster rolling update and service pack process.
Note If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP:
- Install the service pack on the passive node.
- Install the service pack on the active node (This step requests servicerestart).
- Upgrade and update of availability group servers that use minimal downtime and data loss.
Note If you enabled AlwaysOn with SSISDB catalog for additional considerations about how to apply a CU or SP in these environments, go and see the article from the following MSDN blog:
- How to apply a hotfix for SQL Server in a transactional replication and database mirroring topology
- How to apply a hotfix for SQL Server in a replication topology
- How to install service packs and hotfixes on an instance of SQL Server that is configured to use database mirroring
- Overview of SQL Server Servicing Installation