Home Forums SQL Server 2008 SQL Server 2008 - General Heavy waits on PAGEIOLATCH_SH got cleared after restarting web application RE: Heavy waits on PAGEIOLATCH_SH got cleared after restarting web application
praveen_vejandla
SSCrazy
Points: 2069
More actions
January 11, 2013 at 2:13 am
#1576128
One thing that I don't understand is error got logged only after restarting the web application and then when same UPDATE query was run, it ran fine without waiting on I/O.
Could outdated statistics be the reason behind I/O latency?
Thanks.