SQL 2016 SP2 has been released!

Just to let you know SQL 2016 SP2 has been released!

You can download the SP from https://www.microsoft.com/en-us/download/details.aspx?id=56836&WT.mc_id=rss_alldownloads_all

Issues Resolved by SP
• KB4048942 – Memory dumps generated for “Stalled IOCP Listener” and “non-yielding IOCP listener” after SQL Server restart
• KB4051361 – Optimizer row goal information in query execution plan added in SQL Server 2017 CU3 and SQL Server 2016 SP2
• KB4051360 – Execution stats of scalar user-defined function is added to Showplan XML file in SQL Server 2016 SP2
• KB4051359 – SQL Server runs out of memory when table-valued parameters are captured in Extended Events sessions in SQL Server 2016
• KB4051358 – Update adds new columns to SYS.DM_EXEC_QUERY_STATS DMV in SQL Server 2016 SP2
• KB4052138 – Parallel queries are slower when they are run with high DOP in SQL Server 2016
• KB4052137 – Improve query performance on a partitioned table in SQL Server 2016 SP2
• KB4052136 – SQL Server Audit Events fail to write to the security log
• KB4038419 – Update adds CPU timeout setting to Resource Governor workgroup REQUEST_MAX_CPU_TIME_SEC in SQL Server 2016 and 2017
• KB4038418 – Update to add a new column to DMV sys.dm_sql_referenced_entities in SQL Server 2016 SP2
• KB3157575 – Copy Database Wizard fails when a table contains a sparse column set in SQL Server
• KB3162858 – “The log backup chain is broken” error when the log backup process fails in SQL Server
• KB3170116 – Memory grant that’s required to run optimized nested loop join isn’t reflected in Showplan XML in SQL Server
• KB4013128 – Decreased performance and long waits for CLR_AUTO_EVENT and CMEMTHREAD when SQLCLR UDT is used as a stored procedure parameter for a SQL RPC call
• KB4014756 – SQL Server Profiler fails to obfuscate sp_setapprole when it’s executed from a remote procedure call in SQL Server
• KB4016949 – Unified Showplan Schema for SQL Server starting in SQL Server 2012 SP4 and SQL Server 2016 SP2
• KB4046918 – Execution fails when a SQL CLR function invokes Transact-SQL statements through impersonation calls in SQL Server 2016 and 2017
• KB4045795 – Thread pool exhaustion and CMEMTHREAD contention in AAG with data seeding in SQL Server 2016 and 2017
• KB4056008 – “sp_special_columns” returns incorrect result in SQL Server 2016
• KB4052129 – Update for manual change tracking cleanup procedure in SQL Server 2016 and 2017
• KB3136496 – Access violation occurs when a query references an SQLCLR function through a synonym in SQL Server 2016
• KB4039846 – TRY…CATCH block rolls back too many transactions in some in-memory OLTP error handling scenarios in SQL Server 2016
• KB4041809 – Update adds support for MAXDOP option for CREATE STATISTICS and UPDATE STATISTICS statements in SQL Server 2016 and 2017
• KB4041811 – Automatic update of incremental statistics is delayed in SQL Server 2016 and 2017
• KB4041814 – Improve tempdb spill diagnostics in DMV and Extended Events in SQL Server 2017 and SQL Server 2016 SP2
• KB4041817 – Update enables XML Showplans to provide a list of statistics used during query optimization in SQL Server 2016 and 2017
• KB4040276 – Indirect checkpoints on tempdb database cause “Non-yielding scheduler” error in SQL Server 2016 or 2017
• KB4042415 – Deadlock occurs on single-user mode database when many connections access it simultaneously in SQL Server 2016
• KB4042788 – The tempdb system database (sys.databases) is still encrypted even though all other databases on the instance of SQL Server are not encrypted
• KB4046914 – Add CXPACKET wait type in showplan XML in SQL Server 2016 and 2017
• KB4046909 – LogPool cache MEMORYCLERK_SQLLOGPOOL consumes more memory when you do online transactions in SQL Server 2016 SP1 Express Edition
• KB4046902 – “TempDB file size exceeds 1024 MB” error when you try to set the initial size for a TempDB file to a value greater than 1024 MB
• KB4046885 – The SQL Server 2016 setup page contains nonsecure tool-download lnks
• KB4018930 – Update adds the “CLR strict security” feature to SQL Server 2016
• KB4075158 – Boolean values not localized correctly in the parameters pane of a report in SSRS 2016 (SharePoint mode)
• KB4057054 – CXPACKET and CXCONSUMER wait types show inconsistent results for some parallel query plans in SQL Server 2016 and 2017
• KB4043624 – Change tracking manual cleanup fails with table non-existence error in SQL Server
• KB4021243 – Access violation when you create or configure an Always On availability group for an availability database in SQL Server 2012 and 2016
• KB4089239 – QRY_PROFILE_LIST_MUTEX is blocked when TF 7412 is enabled in SQL Server 2016
• KB4089509 – Access Violation when you use QDS and specify a query plan to resolve a performance regression
• KB4090279 – It takes a long time to roll back a batch that updates a large amount of data in SQL Server 2016
• KB4092045 – LSN truncation occurs in AG when disabling the change data capture feature in SQL Server 2016
• KB4092046 – Cannot restart SQL Server 2016 after you use ALTER DATABASE ADD FILE or ADD LOG commands to add files with the same logical name
• KB4092066 – Replication isn’t enabled when database collation uses ‘_SC’ collation extension in SQL Server 2016 and 2017
• KB4092069 – Improves the Distribution Agent cleanup procedure to increase the transactional replication performance in SQL server 2016
• KB4092075 – Improvement: Adds Service Broker support for DBCC CLONEDATABASE in SQL Server 2016
• KB4089473 – Better intra-query parallelism deadlocks troubleshooting in SQL Server 2017 and 2016
• KB4089718 – Improvement: Performance issue when upgrading MDS from SQL Server 2012 to 2016
• KB4016361 – Service Broker endpoint connections aren’t closed after an availability group failover in SQL Server
• KB4054842 – Improvement: General improvements to the change tracking cleanup process in SQL Server 2016 and 2017

About the author