CU1 for SQL Server 2016 SP2 released

Microsoft have released Cumulative Update 1 for SQL Server 2016 SP2!

This Cumulative Update provides the following fixes (https://support.microsoft.com/en-us/help/4135048/cumulative-update-1-for-sql-server-2016-sp2):

  • Performance issues occur in the form of PAGELATCH_EX and PAGELATCH_SH waits in TempDB when you use SQL Server 2016
  • FIX: Error when a SQL Server Agent job executes a PowerShell command to enumerate permissions of the database
  • FIX: Error 9002 when there is no sufficient disk space for critical log growth in SQL Server 2014, 2016, and 2017
  • FIX: “Cannot use SAVE TRANSACTION within a distributed transaction” error when you execute a stored procedure in SQL Server
  • FIX: Access violation occurs when executing a DAX query on a tabular model in SQL Server Analysis Services
  • PFS page round robin algorithm improvement in SQL Server 2016
  • FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS
  • FIX: A memory assertion failure occurs and the server is unable to make any new connections in SQL Server
  • FIX: Wrong user name appears when two users log on to MDS at different times in SQL Server
  • Improvement: Performance issue when upgrading MDS from SQL Server 2012 to 2016
  • FIX: Error in the MDS Add-in for Excel when you use the German version of Excel in SQL Server
  • FIX: “An unexpected error occurred” when you use DAX measures in Power BI table visualizations in SQL Server
  • FIX: One worker thread seems to hang after another worker thread is aborted when you run a parallel query in SQL Server
  • FIX: TDE enabled database backup with compression causes database corruption in SQL Server 2016
  • FIX: Restore of a TDE compressed backup is unsuccessful when using the VDI client
  • FIX: Performance is slow for an Always On AG when you process a read query in SQL Server
  • FIX: An internal exception access violation occurs and the SSAS server stops responding
  • FIX: Floating point overflow error occurs when you execute a nested natively compiled module that uses EXP functions in SQL Server
  • FIX: Database cannot be dropped after its storage is disconnected and reconnected in SQL Server
  • FIX: TDE enabled database backup and restore operations are slow when the encryption key is stored in an EKM provider in SQL Server
  • FIX: Processing a cube with many partitions generates lots of concurrent data source connections in SSAS
  • FIX: Access violation occurs when you query a table with an integer column in SQL Server 2017 and SQL Server 2016
  • FIX: Parallel redo in a secondary replica of an availability group that contains heap tables generates a runtime assert dump or the SQL Server crashes with an access violation error
  • FIX: An assertion failure occurs when you execute a nested select query against a columnstore index in SQL Server
  • FIX: Deploying a SSAS project in SSDT is frequently unsuccessful in SQL Server Analysis Services in Tabular mode
  • FIX: RESTORE HEADERONLY statement for a TDE compressed backup takes a long time to complete in SQL Server
  • FIX: Hidden parameters are included in reports when the Browser role is used in SSRS 2016
  • FIX: An access violation occurs when incremental statistics are automatically updated on a table in SQL Server

This cumulative update can be downloaded from https://www.microsoft.com/en-us/download/details.aspx?id=56975

About the author