Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009

    Unanswered: BP Analyzer and "Disk Sector [0] 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 [0] 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.


  2. #2
    Join Date
    Nov 2004
    on the wrong server
    Provided Answers: 6
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts