Best method to analyze the performance of the disks on SAN

  • Hi,

    We Active/Active/Passive cluster setup and 1 instance on node1 and 4instances on node2 and node 3 is passive.

    We have all the drives(including System Drive C on SAN):

    On Node1:

    C: OS

    D:Datafiles

    E:Secondary Datafiles

    F:Log files

    T:Tempdb

    Z:Backup

    We have Quest Spot light for monitoring and getting frequent alarms about High Disk queue length. If the drives are SAN, perfmon will not give the exact results (As I got this answer from this forum members) and perfmon is not a good source if the drives are on SAN.

    So what is the best method to get the exact figures/readings of sec/reads, sec/writes, high disk queue length of the drives sitting on SAN drives?

  • Talk with your SAN administrator. He/she should have some monitoring tools for the SAN.

  • Hi,

    Yes your are right PERFMON will not be able to give your right information so you have to go to the SAN Vendor as they have the tools to analyze DISK performance.

    Regards

    GURSETHI

  • Before your cluster goes live, it is worth running the SQL Stress IO Sim from MS to get some bench mark figures. It provides most of those stats to check if you are getting the most out of your disks.

    http://support.microsoft.com/kb/231619

    Diskpart is another utlility worth reading about to align storage track boundaries.

    cheers

Viewing 4 posts - 1 through 3 (of 3 total)

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