Tag: "configuration"

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… more »

PerfMon - Sizing an existing database environment

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 »