08-30-09, 20:59 #1Registered User
- Join Date
- Aug 2009
Unanswered: BP Analyzer and "Disk Sector  alignment of server"
I am running SQL 2005 on Server 2003 with performance Issues and turned to BPA for some insight.
When BPA gave lots of "Disk Sector  alignment of server" errors I set up a project to resolve them. This involved recreating the Array's on our DS400 to be 64k stripe sizes for Each the SQL-Data and SQL-LOG arrays.
I reformatted the data and logs partitions on my SQL Server and created them using 64k bytes per cluster and set the starting offset to 1024k.
This means my:
Stripe size = 65536
File Allocation Unit Size = 65536
Starting Offset = 1048576
Thus if i calculate my values correctly, 1048576 divided by 65536 gives me an integer value of 16 which means my Partition Offset and Stripe Unit size are aligned.
Furthermore if I divide my Stripe Unit Size (65536) by my File Allocation Unit Size (65536), the integer value of 1 means it too is aligned.
So I can not understand why SQL BPA still complaining that my alignment is out???
I did not reformat the O/S partitions so they will still be using the server 2003 default offset of 32256, but surely BPA is only looking at the drives which house the MDF's and LDF's?
Any assistance would be appreciated.
08-31-09, 21:07 #2Annie's Dog Walker
Provided Answers: 6
- Join Date
- Nov 2004
- on the wrong server
I do not know but I would reindex the dbs and reinstall BPA.If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry. Earnest Hemingway, A Farewell To Arms.