June 4, 2009 at 2:04 pm
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?
June 4, 2009 at 5:07 pm
Talk with your SAN administrator. He/she should have some monitoring tools for the SAN.
June 4, 2009 at 11:11 pm
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
June 5, 2009 at 5:22 am
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