We have an IBM server xSeries 460 with a QLogic FC HBA card 4gb on the server with a PCI-X 266MHz bus speed (16 CPU 667MHz FSB, 32GB RAM). The HBA card connects to a Brocade 5000 switch then to the SAN Controller then to a Cisco 9124 Switch then to SAN Drives all through FC. On the IBM server we have SQL Server 2005 installed on windows 2003 32-bit.
IOPS = 750 MB/sec = 13 Latency = 10ms Disk Queue Length = 7 Block Size = 20KB
Users complain that the application is slow all the time, I noticed the application is slow on reads only that is where our high latency comes from. I did see that on our Brocade 5000 Switch all other servers on the network are connected to that switch (mail server, report servers, other application servers) but connect to another SAN. There is only one application connected to the XIOTECH 7000 SAN and that is the application that is slow.
sql server 2005, XIOTECH 7000 SAN, windows 2003 32-bit
January 11, 2011 6:30 PM
January 18, 2011 7:46 PM