I had asked this question earlier and the question went missing so here it is again.
Bought a DELL Poweredge 2950 to use as in-house QA Server. Disk performance is beyond terrible, 1000-4000 ms response time on the drive with our SQL Server database .mdf. Sql Server disk queue upwards of 300 at times.
I'm a software guy, can anyone help me with steps to determine the issue?
I don't know what RAID controller it has, how can I determine that?
I'm speculating it could be BIOS issue. Perhaps the server used to have another kind of drive in it and when I added SATA the ??? buffer size is wrong???
Perhaps I chose wrong options (chose defaults) when setting up the RAID 1 arrays? I thought RAID 1 was a performance array?
OBSERVATION: Any disk activity on the SERVER causes the response time on another drive to drop, for instance, I was copying the DELL open manage ISO to the C: drive and I noticed the response time on the F: drive (RAID 1) different LUN, spiked up during the copy ??