Re: question regarding slow performance an PAGEIOLATCH_SH locks on sql 2005
Posted by ianwr on 12/07/07 14:12
ps. The perf mon stats we are seeing are as follows :-
Avg Disk Read/Sec are between 0.06 and 0.3 on the select partion when
the routine starts up. which i think must be a little slow.
Disk Read/Sec is around 170