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

  • One more observation is that below error is logged only after restarting the web logic application. Before restarting the application service, UPDATE was stuck on I/O, getting processed very slowly but no error is logged in SQL Server error log.

    SQL Server has encountered 42443 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [H:\data\***.mdf] in database [****(5). The OS file handle is 0x00000000000007D4. The offset of the latest long I/O is: 0x000009cd260000

    After restarting the application, same query ran fine without any I/O latency issue.

    Did anyone observe similar problem any time?

    Thanks.