Track alignment in Symantec Storage Foundation for Windows 2000 and 2003 - Hosting SQL Server 2000 and 2005 Databases
It's recommended to align disk after a Windows installation to drastically improve I/O performance within SQL Server 2000 or 2005. There are several articles throughout the web on the benefits to making this adjustment, so I won't get into it here. Bottom line - proper alignment can give 40% improved performance for SQL Server - on Windows 2000 and 2003.
Symantec automatically aligns the disk within Storage Foundation - however - it sets the offset to be 96 sectors(49152 bytes) for Hitachi Disk - even though Hitachi specifically suggests 64 sectors (34k or 32768 bytes). For EMC disk SFW sets it to 128 sectors (64k or 65536 bytes) - which is the standard for most other disk - including non-Dynamic disk.
Are we the only ones seeing this? Has any one done any performance tests when set to 96 sectors versus 128 or 64? Unfortuately this would be a hack since it isn't a configurable option within SFW. General thoughts?
StorageMicrosoft Legacy OS
8/22/2022 - Mon
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.