SQL Server Performance

create partition with 64K offset

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by avipenina, Sep 22, 2008.

  1. avipenina New Member

    Hi,

    if i use Mirror drive for LogFile and Raid5/10 drive for DataFile - should i make both partition to use the 64K offset or just the Raid5/10 partition?
    THX
    avipenina, Sep 22, 2008
    #2

  2. satya Moderator

    64k partition will be good if your database is doing heavy inserts & updates that will help the performance to write the data.
    satya, Sep 22, 2008
    #3

  3. avipenina New Member

    OK.
    what about the Mirror partition where i stored the LDF should it be 64K offset as well?
    THX
    avipenina, Sep 22, 2008
    #4

  4. satya Moderator

    It doesn't hurt anyway, we have such setting on current 4 node 2005 clusters. See my comments: http://sqlserver-qa.net/blogs/tools/archive/2008/04/28/sql-server-2005-and-disk-drive-allocation-unit-size-to-64k-any-benefit-or-performance.aspx
    satya, Sep 23, 2008
    #5

  5. avipenina New Member

    THX.
    avipenina, Sep 23, 2008
    #6

Share This Page