Cloned databases are not meant to be used in production environments. Use the new DBCC command to troubleshoot existing production databases by cloning the schema, metadata, and statistics but without the data. New AlwaysON XEvents and performance counters to improve diagnostics when troubleshooting latency issues with AlwaysON.Ī new stored procedure sp_flush_CT_internal_table_on_demand cleans up change tracking internal tables on demand. Improved Always On Availability Group Lease Timeout DiagnosticsĪlwaysON XEvents and performance counters

Supportability and diagnostics improvements in SP2 FeatureĪdded new logging capability for Lease Timeout messages so that the current time and the expected renewal times are logged. Spatial performance improvements in SQL Server 20 Significant improvement in spatial query performance. Removes the need for spinlock for SOS_RWLock and instead uses lock-free techniques similar to in-memory OLTP. This improvement is useful to run DBCC CHECKDB with a MAXDOP setting other than the sp_configure value. This enhancement eliminates the need of Trace Flag 8048 post SQL 2014 SP2. You can automatically configure Soft NUMA on systems reporting 8 or more CPUs per NUMA node.Įnables SQL Server Buffer Pool to scale beyond 8 TB.ĭynamically partition memory object based on number of nodes and cores. Performance and scalability improvements in SP2 Feature It contains improvements centered around performance, scalability, and diagnostics based on the feedback from customers and the SQL community.

SQL Server 2014 SP2 contains rollups of released hotfixes for SQL Server 2014 SP1 CU7. This article describes known issues with SQL Server 2014 (12.x) releases, including related service packs.

Sql server 2012 express sp2