SQL Server 2014 SP2 Released

It was a dark and stormy night. The next morning, SQL Server 2014 SP2 arrived, chock full of fixes like:

  • New DBCC CLONEDATABASE command to generate a statistics-only copy of the database for CE troubleshooting
  • Faster performance for large databases with a large number of partitions
  • More AlwaysOn (note the lack of space and AG in the headline) extended events and Perfmon counters
  • Memory grant warnings in XML query plans
  • Plans include trace flags
  • Per-operator query execution statistics in query plans
  • New min_grant_percent and max_grant_percent query hints
  • Faster spatial queries
  • Memory grant fields in sys.dm_exec_query_stats

And much more! Lots of good stuff for performance tuners in here. Go get ’em, tiger.

Leave a comment

Your email address will not be published. Required fields are marked *

One thought on “SQL Server 2014 SP2 Released”