LOGO__SQLServer2012SP1Second package with January SQL Server updates are for SQL Server 2012 Service Pack 1. In this Cumulative Update No 14 {build no 11.0.3486.0} SQL Server Product Team resolved just eight bugs and problems. Here is the list of bugs, and three of them are oriented for CPU usage.

VSTS bug: 3657479 | KB: 3016165
FIX: Arithmetic overflow error occurs when you add manually initialized subscriptions for publication in SQL Server 2012
SQL service

VSTS bug: 3540934 | KB: 3023629
FIX: High CPU usage after you use DTExec utility to process SSAS 2012 data mining models
Analysis Services

VSTS bug: 3857931 | KB: 2840657
FIX: Performance decreases when you stage many records in MDS for SQL Server 2012
Data Quality Services (DQS)

VSTS bug: 3833361 | KB: 3023634
FIX: “Error converting data type nvarchar to numeric” error when you use a business rule in SQL Server 2012 MDS
SQL service

VSTS bug: 3557769 | KB: 3026082
FIX: SOS_CACHESTORE spinlock contention on system table rowset cache causes high CPU usage in SQL Server 2012
SQL service

VSTS bug: 3557777 | KB: 3026083
FIX: SOS_CACHESTORE spinlock contention on ad hoc SQL Server plan cache causes high CPU usage in SQL Server 2012
SQL service

VSTS bug: 3916889 | KB: 3027860
FIX: Error 17066 or 17310 during SQL Server startup
SQL service

VSTS bug: 3972408 | KB: 3028322
FIX: It takes longer time than usual to render a report in SSRS 2012
Reporting Services

 

This update could be applied to applies to

  • Microsoft SQL Server 2012 Service Pack 1
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Business Intelligence
  • SQL Server 2012 Reporting Services

    Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 5

    You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP: step 1 Install the service pack on the passive node, step 2 Install the service pack on the active node (This step requests servicerestart).

    If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

    • 2012_SP1_PPExcel_CU14_3023636_11_0_3486_x86 {102 MB}
    • SQLServer2012_SP1_CU14_3023636_11_0_3486_x86 {509 MB}
    • 2012_SP1_RSShrPnt_CU14_3023636_11_0_3486_x64 {44 MB}
    • 2012_SP1_PPExcel_CU14_3023636_11_0_3486_x64 {135 MB}
    • SQLServer2012_SP1_CU14_3023636_11_0_3486_x64 {818 MB}

     

    Enjoy!