Monthly Archives: May 2017

Configuring SQL Server for Performance

SQL Server 2012 provides system settings that may be enhanced for your particular atmosphere and workload patterns. Probably the most important performance settings are Memory, Network Packet Size, Instant File Initialization and tempdb. Memory: Two significant server property configuration settings include maximum and minimum server memory. Automatically, the program is configured having a minimum memory of 0MB along with a ...

Read More »