September 7, 2012 at 6:55 am
I have 16 sessions in suspended in wait type PAGEIOLATCH_SH. What is the major cause of this. Is it I/O waits?
September 7, 2012 at 8:42 am
PageIOLatch waits are IO-related. It's a wait for the page to move from memory to disk or disk to memory.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 7, 2012 at 9:13 am
jdbrown239 (9/7/2012)
I have 16 sessions in suspended in wait type PAGEIOLATCH_SH. What is the major cause of this. Is it I/O waits?
I think Gail gave you already a great answer. In case you would like some more info, you may be interested in checking these links:
http://www.sqlserver-dba.com/2011/03/sql-server-pageiolatch_sh-and-how-to-reduce-it.html
http://www.sql-server-performance.com/forum/threads/pageiolatch_sh-mystery.31820/
http://stackoverflow.com/questions/620626/what-is-pageiolatch-sh-wait-type-in-sql-server
September 7, 2012 at 9:47 am
Thank you guys!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply