Improved AlwaysOn 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.

Ms sql server 2014 download msdn