Wednesday, September 29, 2010

Partition offset and allocation unit size of a disk for SQL Server

SQL Server performance is dependent on the server resources available and disk performance is probably the most important resource.  To maximize disk performance for SQL Server, I've always been told that the drive's partition offset must be set to 32K and the allocation unit size set to 64K for partitions that hold data and 8K for partitions that hold logs.  How do I find out the allocation unit size and partition offset for my drives?.


http://www.mssqltips.com/tip.asp?tip=2119

No comments:

Post a Comment