Network Management

PAGEIOLATCH_SH Sql Wait Type

This content will describe SQL Server wait type that can be encountered more or less commonly, which includes the description, steps that should be taken, and additional resources that could be used for troubleshooting.

First published date

10/20/2021 9:50 AM

Last published date

10/20/2021 9:50 AM

Overview

PAGEIOLATCH_SH Occurs when a task is waiting on a latch for a buffer that is in an I/O request. The latch request is in Shared mode. Long waits may indicate problems with the disk subsystem.

Product section

Network Performance Monitor

Cause

Description

This wait type accumulates while SQL Server is waiting for a page to be retrieved from disk and loaded into memory. The page collected will be used for a shared purpose (read operation). If this value is high it is likely disk or memory available are not keeping up with the workload

Resolution

Suggested solutions
  1. Add additional memory
  2. Investigate disk latency
  3. Increase the maximum memory allocation
  4. Indexing, look for high disk I/O queries
  5. Enable data page compression if CPU usage is not suffering

The content posted herein are provided as a suggestion or recommendation to you for your internal use. The information set forth herein may come from third party website or customers. SolarWinds is not liable for any downtime or any issue that may occur if you perform the following suggestions on the link provided. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.