Microsoft SQL Server 2016 SP2 Cumulative Update 5!

Microsoft have just released the 5th Cumulative Update for Microsoft SQL Server SP2, included in this CU is the following fixes:

  • 4055674 – FIX: Missing logs for Analysis Services Processing tasks in SQL Server 2016 and 2017 Integration Services
  • 4090032 – FIX: Memory gets exhausted when you run Power BI report that executes DAX query on SSAS 2014, 2016 and 2017 Multidimensional mode
  • 4099335 – False error reporting when you execute the Test-SqlAvailabilityGroup cmdlet in SQL Server
  • 4316948 – FIX: Access violation when you compile a query and histogram amendment is enabled with default Cardinality Estimation in SQL Server 2016 and 2017
  • 4346803 – FIX: Error occurs when you run sp_send_dbmail stored procedure that contains comma in sender email address and name in SQL Server
  • 4457953 – FIX: Access violations and unhandled exceptions occur when you set automatic seeding for secondary replica or DAG replica in SQL Server 2016 and 2017
  • 4459535 – FIX: Masked data is exposed when a query that uses sp_cursorfetch is run in SQL Server if Dynamic Data Masking is enabled
  • 4460112 – FIX: Access violation when you run a query that uses the XML data type in SQL Server 2014, 2016 and 2017
  • 4461562 – FIX: Transactions and log truncation may be blocked when you use Query Store in SQL Server 2016 and 2017
  • 4463125 – FIX: Error occurs when the Database Encryption Key is longer than 3,456 bits in SQL Server 2016 and 2017
  • 4463328 – FIX: “An unexpected exception occurred” when you run an MDX query after an XMLA query to process a dimension in SSAS
  • 4465247 – FIX: Deadlock occurs in SSAS 2016 and 2017 when you run a DAX query with time intelligence calculation in parallel
  • 4467006 – FIX: The schedule changes to “Report-specific schedule” when you enable “Create cache snapshots on a schedule” for the report in SSRS 2016
  • 4469268 – FIX: I/O error on a BPE file causes buffer time-out in SQL Server
  • 4470528 – FIX: Nested tablix shows small font or partial text in SSRS 2016 and later versions
  • 4470916 – FIX: Out of memory error occurs when Database Node Memory (KB) drops below 2 percent in SQL Server 2014 and 2016
  • 4475322 – FIX: “Non-yielding” error occurs when there is a heavy use of prepared statements in SQL Server 2014 and 2016
  • 4479280 – FIX: Restore of TDE-compressed backup is unsuccessful when backing up database to a 512-byte Emulation disk in SQL Server
  • 4479283 – FIX: SQL Server installation fails if one of the remote nodes is unreachable in a cluster
  • 4480635 – FIX: High CPU usage when there are many batch requests in SQL Server 2016
  • 4480639 – FIX: SQL Server service crashes when DBCC CHECKDB runs against a database that has a corrupted partition
  • 4480640 – FIX: Server crashes when you cancel DBCC CHECKDB against a large database in SQL Server 2016

For the complete list click here.

To download this CU click here

About the author