title: What is PAGEIOLATCH_SH wait type in SQL Server?
body: <p>I have a query that is taking a long time in the middle of a transaction. When I get the <code>wait_type</code> of the process it is <code>PAGEIOLATCH_SH</code>. </p>
  
  <p>What does this wait type mean and how can this be resolved?</p>