Cumulative Update 2 for SQL Server 2014 SP2
You can find all information in complete list of SQL Server Version
Original news: https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-2-for-sql-server-2014-sp2/
The 2nd cumulative update release for SQL Server 2014 SP2 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.
To learn more about the release or servicing model, please visit:
- CU#2 KB Article: https://support.microsoft.com/en-us/kb/3188778
- Understanding
Incremental Servicing Model
for SQL Server
- Microsoft® SQL Server® 2014 SP2 Latest Cumulative Update: https://www.microsoft.com/en-us/download/details.aspx?id=53592
- Update Center for Microsoft SQL Server:
http://technet.microsoft.com/en-US/sqlserver/ff803383.aspx
From https://blogs.sentryone.com/team-posts/latest-builds-sql-server-2014/ some interesting features:
- Showplan XML will now include any trace flags in effect, actual rows read, per-operator performance metrics, and more details on spills.
- New query hints to control memory grants (without Resource Governor).
- Buffer pool can now exceed 8 TB (I'm sure a lot of us were hampered by this limitation).
- Better read workload throughput via reduced spinlocks.
- Automatic soft-NUMA partitioning.
- Database lock partitioning (without using trace flags 1236 / 9024 – also in SP1).
- Performance improvements in spatial (trace flag 6533).
MAXDOP support for several DBCC CHECK* operations.- Dynamic memory object scaling.
- Import and export UTF-8 data with BCP /
BULK INSERT.
- New DMF,
sys.dm_db_incremental_stats_properties (see Connect #797156).
- New DMF,
sys.dm_exec_input_buffer
, for retrieving correlated INPUTBUFFER information.
- Index usage stats no longer get cleared after a rebuild (see Connect #739566).
- New error log diagnostics for tempdb, instant file initialization, and Availability Group lease timeouts.
-
DBCC CLONEDATABASE()
– create a stats-only copy of a database with minimal effort (Melissa blogged about this feature for T-SQL Tuesday #80).
You can find all information in complete list of SQL Server Version
Original news: https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-2-for-sql-server-2014-sp2/
The 2nd cumulative update release for SQL Server 2014 SP2 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.
To learn more about the release or servicing model, please visit:
- CU#2 KB Article: https://support.microsoft.com/en-us/kb/3188778
- Understanding Incremental Servicing Model for SQL Server
- Microsoft® SQL Server® 2014 SP2 Latest Cumulative Update: https://www.microsoft.com/en-us/download/details.aspx?id=53592
- Update Center for Microsoft SQL Server: http://technet.microsoft.com/en-US/sqlserver/ff803383.aspx
From https://blogs.sentryone.com/team-posts/latest-builds-sql-server-2014/ some interesting features:
- Showplan XML will now include any trace flags in effect, actual rows read, per-operator performance metrics, and more details on spills.
- New query hints to control memory grants (without Resource Governor).
- Buffer pool can now exceed 8 TB (I'm sure a lot of us were hampered by this limitation).
- Better read workload throughput via reduced spinlocks.
- Automatic soft-NUMA partitioning.
- Database lock partitioning (without using trace flags 1236 / 9024 – also in SP1).
- Performance improvements in spatial (trace flag 6533).
MAXDOPsupport for severalDBCC CHECK*operations.- Dynamic memory object scaling.
- Import and export UTF-8 data with BCP /
BULK INSERT. - New DMF,
sys.dm_db_incremental_stats_properties(see Connect #797156). - New DMF,
sys.dm_exec_input_buffer, for retrieving correlatedINPUTBUFFERinformation. - Index usage stats no longer get cleared after a rebuild (see Connect #739566).
- New error log diagnostics for tempdb, instant file initialization, and Availability Group lease timeouts.
-
DBCC CLONEDATABASE()– create a stats-only copy of a database with minimal effort (Melissa blogged about this feature for T-SQL Tuesday #80).