Home Forums SQL Server 7,2000 Performance Tuning in sys processes "lastwaittype " showing PAGEIOLATCH_SH RE: in sys processes "lastwaittype " showing PAGEIOLATCH_SH
chung wong-438547
Grasshopper
Points: 11
More actions
July 2, 2014 at 12:39 pm
#1726612
Average IO stall in milliseconds. I have database have average 20 milliseconds on avg_io_stall. Does anyone know what is the time considered normal?