Tag: "configuration"

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

Posted on Sep 19, 2014 by in SQL Server
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… more »

PerfMon - Sizing an existing database environment

Posted on Apr 10, 2012 by in SQL Server
Estimating the number of I/Os required for a system is crucial when sizing one or multiple existing databases on a new I/O subsystem to the SQL Server. Often in mixed environments (OLTP/RDW) we must take the blended approach for managing the I/O for our… more »