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 (1/11/2013)


    Could outdated statistics be the reason behind I/O latency?

    it might be . there could be another reason too like memory , IO , table/index scan happening. Please post the exec plan so that we can dig out further

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)