SQL Server Performance Forum – Threads Archive
Slow Disk I/OI have a Dell 2850 with 8 gigabytes of ram and duel 2.80 Ghz, running under Server 64 bit Enterprize, with SQL 2005 64 bit. My disk I/O seems slow, I have 6 15K 146 gigabytes disks in raid 10 connected to a PERC 4e/Di as C drive, and the data and logs split between to arrays of 6 15K 146 gigabyte disks in raid 10 connect to a PERC 4/DC. Here are my numbers:
In memory read test
60254145300009328471.5 10 84715
60352730000938117.56671000 117566.7 Random I/O
61735250480.198699981985.50401880.340014.72659.3380 spidCallsmsCPUmsdpages/sMBTable MB/secReadsPerSecDisk MB/secAvg-sec/IO
If you have tempdb on those drives which are observing slow I/O, thenrefer to this blog and see this too to check whether you have enabled the online indexing in thsi case.
The read performance for an array of 6 15K drives connect directly connected to a PERC 4/DC controller seems very low, it is almost like somewhere it is throttled
Have you collected the SYSMON counters for further assessment, why not get checkout the hardware with the vendor.