SQL Server Performance

what disk type to use

Discussion in 'SQL Server 2005 General DBA Questions' started by avipenina, Jul 20, 2008.

  1. avipenina New Member

    Hi,
    if i use Mirror for Log Files and RAID5 for Data Files,what disk type should i use in computer management - Basic,Dynamic,GPT ?
    THX
    avipenina, Jul 20, 2008
    #2

  2. Luis Martin Moderator

    Faster as you can or your budget can.
    You have to consult to your hardware provider in order to fit server capabilities.
    Luis Martin, Jul 21, 2008
    #3

  3. avipenina New Member

    i use HP SmartArray with 512MB cache.i use 2 disk in mirror for system,2 disk in mirror for Log Files,4 disk in Raid5 for Data.
    this is not concern my hardware provider i think,i'm talking about the server and sql side.
    what type of disk should i use?(Basic,Dynamic,GPT)
    THX
    avipenina, Jul 21, 2008
    #4

  4. moh_hassan20 New Member

    Dynamic : for RAID disks

    Basic for non RAID

    GPT for windows 64-bit
    moh_hassan20, Jul 23, 2008
    #5

  5. satya Moderator

    I believe this overlaps other question you have asked on format of disks, anyway having another information about database activity and transactions with future growth it may be useful to suggest which could be the best one to go.
    satya, Jul 23, 2008
    #6

Share This Page