Post reply

no.of disks in RAID 10 configuration

  • March 3, 2010 at 9:18 pm

    #141864

    Hi,

    We have sql server 2005 enterprise edition with SP3 and all the storage is from SAN and all drives are RAID 10. We are getting high disk queue length alarms from Spot light (mostly when backups are running and when coping .bak files to TAPE). The avg.Disk Queue length is 3.0, most of the times.

    So if a disk, eg: D is of RAID 10 configuration, how to know no.of disks that drive D consists of?

    If I know that no.of disks, then we need to divide the Avg.Disk queue length by that no.of disks right? (3.0/no.of disks in drive D right?)

    I'm assuming the spot light is NOT taking considering the no.of disks that drive D has?

    please advice

  • March 4, 2010 at 2:38 am

    #1128353

    gmamata7 (3/3/2010)

    Hi,

    We have sql server 2005 enterprise edition with SP3 and all the storage is from SAN and all drives are RAID 10. We are getting high disk queue length alarms from Spot light (mostly when backups are running and when coping .bak files to TAPE). The avg.Disk Queue length is 3.0, most of the times.

    So if a disk, eg: D is of RAID 10 configuration, how to know no.of disks that drive D consists of?

    If I know that no.of disks, then we need to divide the Avg.Disk queue length by that no.of disks right? (3.0/no.of disks in drive D right?)

    I'm assuming the spot light is NOT taking considering the no.of disks that drive D has?

    please advice

    A storage\SAN expert would be best to answer this, but acc to me, only storage admin of your organization can help you with all this config settings.

    and calculation of disk queue lenght is diff in case of SAN. try google .;-)

    Regards,
    Sarabpreet Singh 😎
    Sarabpreet.com
    SQLChamp.com
    Twitter: @Sarab_SQLGeek

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply