To improve your SQL Server performance or relive TempDB page (wirte) blocking consider splitting the TempDB Data file into the amount of logical processors in the server. As a general rule, if the number of logical processors
Continue ReadingTag: SQL
SQL Server Disk Configuration
I have been researching the ideal disk formatting for SQL Server in summary: All DATA, LOGS and TEMPDB should be formatted using a cluster size (allocation unit) of 64k All Programs and Backups formatted using
Continue ReadingClusting, Stretch, Networking, Subnets, VLAN’s and all that stuff! for Windows, SQL Server and SharePoint
Firstly it’s worth noting that from Windows 2008 clustering is supported using separate subnets and VLAN’s although separate subnets has considerations regarding DNS and recovery speeds. SQL Server 2008 and below does NOT support subnets
Continue Reading