Home Forums SQL Server 7,2000 Performance Tuning High Read Disk Queue Length RE: High Read Disk Queue Length
Allen Cui-55137
SSC Guru
Points: 51650
More actions
February 19, 2004 at 12:11 pm
#494769
How much memory are being used by SQL Server instances? Can you post the result of "select * from sysprocesses where waittime > 0 order by waittime desc"? If there are any queries running, verify whether they are running in parallel.