The SQL Server 2016 Service Pack 2 (SP2) contains a rollup of released hotfixes as well as multiple improvements centered around performance, scalability, and supportability based on feedback from customers and the SQL community. These improvements enable SQL Server 2016 to perform faster and with expanded supportability and diagnostics.
SQL Server 2016 Service Pack 2 includes:
- Performance and scale improvements for SQL Server, such as improved database backup performance on large memory machines and added backup compression support, which helps performance of almost all databases.
- Supportability and diagnostics enhancements, such as improved troubleshooting and additional information about statistics used during query plan optimization.
