User report that a query takes a long time to execute. The query has the following wait statistics.



Which resource causes the issue?

A. processor

B. disk

C. blocking

D. network

Explanation:

PAGEIOLATCH Wait time and WaitCount are both high.

One of the most common wait type seen on SQL Server and definitely one that causes a lot of troubles to less experienced database administrators is the PAGEIOLATCH_SH wait type. This is one of those wait types that clearly indicates one thing, but which background and potential causes are much subtler and may lead to erroneous conclusions and worse, incorrect solutions

The Microsoft definition of this wait type is:

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.

References: https://www.sqlshack.com/handling-excessive-sql-server-pageiolatch_sh-wait-types/