Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

File Allocation Unit Size and Partition Alignment Expand / Collapse
Author
Message
Posted Wednesday, May 2, 2012 1:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 2, 2014 4:26 AM
Points: 22, Visits: 37
There is of course another dimension to consider after you have created your LUNs and exposed them to your
SQL Box, which is the Partition alignment and File Allocation Unit (Cluster) size to be used in formatting the drive.
Have a look at the following documentation on SQL Server 2008, and SQL for some insight: http://msdn.microsoft.com/en-us/library/dd758814.
A Cluster size of 64KB is normally fine for use with SQL Server.
Post #1293653
Posted Thursday, May 3, 2012 7:27 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 30, 2014 6:49 AM
Points: 383, Visits: 1,478
Remember Windows 2008 does partition alignment for you
Post #1294590
Posted Thursday, May 3, 2012 12:38 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 1:33 PM
Points: 3,156, Visits: 2,234
Since we are talking about the 'right' things to do for your SAN disks on SQL Server let us not forget to check with you specific SAN manufacturer's best practices/whitepapers as well. Their unique information combined with Microsoft's can create one screaming SAN. LUN sizes, number of disks, SAN stripe or block sizes all contribute to this and usually are specific to the SAN manufacturer. Oh, let us not forget the technical specs on your HBAs as well ... maximum queue depth, read/write buffering and percentage of read/write activity all by drive letter (system DBs, application DB data, application DB log and tempdb) !





Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #1294887
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse