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.
1 Comment. Leave new
Also added support for new “Number of Rows Read” property