What would be reason behid WaitType PAGEIOLATCH_SH?

Question

I am executing a stord proc that basically truncates & reload the table x.During reload of data , It joins table a , table b that contains 100 millions & 2 millions records resp.During the execution of stored proc i found in activity monitor that WaitType PAGEIOLATCH_SH is slowing down my sp. what would be the reason behind this waittype "PAGEIOLATCH_SH". And how to avoid this waittype.

Thanks in Advance.

I am using activity monitor.I couldnt see RAID value in that. — David, Jan 27 '11 at 14:46
Does this answer your question? [What is PAGEIOLATCH\_SH wait type in SQL Server?](https://stackoverflow.com/questions/620626/what-is-pageiolatch-sh-wait-type-in-sql-server) — Jim G., Jun 29 '21 at 15:03

score 2 · Accepted Answer · edited May 23 '17 at 11:47

2

This might be helpful What is PAGEIOLATCH_SH wait type in SQL Server?

edited May 23 '17 at 11:47

Community

1
1

answered Jan 27 '11 at 14:42

Mikael Eriksson

136,425
22
210
281

What would be reason behid WaitType PAGEIOLATCH_SH?

1 Answers1