#SP2 VERSION UPDATE#
Update to add a new column to DMV sys.dm_sql_referenced_entities in SQL Server 2016 SP2įIX: Copy Database Wizard fails when a table contains a sparse column set in SQL Server Update adds CPU timeout setting to Resource Governor workgroup REQUEST_MAX_CPU_TIME_SEC in SQL Server 20 Improve query performance on a partitioned table in SQL Server 2016 SP2įIX: SQL Server Audit Events fail to write to the security log Update adds new columns to SYS.DM_EXEC_QUERY_STATS DMV in SQL Server 2016 SP2įIX: Parallel queries are slower when they are run with high DOP in SQL Server 2016 Optimizer row goal information in query execution plan added in SQL Server 2017 CU3 and SQL Server 2016 SP2įIX: Execution stats of scalar user-defined function is added to Showplan XML file in SQL Server 2016 SP2įIX: SQL Server runs out of memory when table-valued parameters are captured in Extended Events sessions in SQL Server 2016 even if collecting statement or data stream isn't enabled This list will be updated when more articles are released.įor more information about the bugs that are fixed in SQL Server 2016 SP2, go to the following Microsoft Knowledge Base articles.įIX: Memory dumps generated for "Stalled IOCP Listener" and "non-yielding IOCP listener" after SQL Server restart
In addition to the fixes that are listed in this article, SQL Server 2016 SP2 includes hotfixes that were included in SQL Server 2016 Cumulative Update 1 (CU1)to SQL Server 2016 SP1 CU8.įor more information about the cumulative updates that are available in SQL Server 2016, see SQL Server 2016 build versions.Īdditional fixes that aren't documented here may also be included in the service pack. SQL Server 2016 SP2 upgrades all editions and service levels of SQL Server 2016 to SQL Server 2016 SP2. Microsoft SQL Server 2016 service packs are cumulative updates. List of fixes included in SQL Server 2016 SP2 0 Microsoft SQL Server 2016 service packs are cumulative updates.
#SP2 VERSION INSTALL#
Note After you install the service pack, the SQL Server service version should be. Microsoft SQL Server 2016 SP2 Feature Pack
#SP2 VERSION MANUAL#
SQL Server 2016 SP2, Microsoft SQL Server 2016 SP2 Express, and Microsoft SQL Server 2016 SP2 Feature Pack are available for manual download and installation at the following Microsoft Download Center websites.
#SP2 VERSION HOW TO#
More Information How to get SQL Server 2016 SP2 It includes all the information that you previously found in the release notes and Readme.txt files. Note This article serves as a single source of information to locate all documentation that's related to this service pack. It describes how to get the service pack, the list of fixes that are included in the service pack, known issues, and a list of copyright attributions for the product. This article contains important information to read before you install Microsoft SQL Server 2016 Service Pack 2 (SP2). SQL Server 2016 Developer SQL Server 2016 Enterprise SQL Server 2016 Enterprise Core SQL Server 2016 Standard More.