Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014

Great KB article, with a lot of helpful guidance and information about configuration settings and valuable hotfixes for SQL Server 2012 and SQL Server 2014 used with high-performance workloads!

Really good stuff! A huge list of categorized advice for trace flags, cumulative updates, MAXDOP settings, auto update statistics threshold, database lock activity increases, ALTER INDEX…ONLINE operation, I/O heavy operations, tempdb, Out-of-memory Improvements for DBCC CHECKDB  and much MORE.

It's a must read, so check it out: KB 2964518 Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 used with high-performance workloads.

I wish you a nice day and happy reading :-),
tosc

 

Torsten Schuessler