title: What would be reason behid WaitType PAGEIOLATCH_SH?
body: <p>I am executing a stord proc that basically truncates &amp; reload the table x.During reload of data , It joins table a , table b that contains 100 millions &amp; 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.</p>
  
  <p>Thanks in Advance.</p>