SQL Server 2014 Service Pack 2

Service Pack 2 for SQL Server 2014 will be released closed to date of release of SQL Server 2016. Reason why this is interesting for DBA’s is the fact that just right next to several  fixes to database engine, some of the new features introduced in SQL Server 2016 will be also available in this build.

  • Information displayed in SYS.DM_DB_INDEX_USAGE_STATS will be reset only when database would go offline or server is restarted.
  • Other administrator friendly feature would be possibility to see progress of database recovery process with new xEvents with new actions
  • New spills warnings during sort operations in tempdb
  • Memory grant Showplan warning which shows in one of the 3 conditions:
  1. Under used – when the max used size is to small compared to the grant size. It is causing blocking and less efficient usage
  2. Over used – when the used size exceed the grant size. May cause out of memory on the server
  3. Excessive growth – when the dynamic grant increases too much. this may cause server instability and unpredicted query performance




SQL Server 2016 release date anounced

New version of SQL Server will be available in few weeks – it will be released on June 1st 2016!

As of now there is available Release Candidate 3 to download it please go here (registration required).

For those who will wait with upgrade of their systems there is also good news – some improvements to database engine from SQL Server 2016 will be also available in SQL Server 2014 SP2. More about it soon