Network Management
PAGEIOLATCH_EX SQL WAIT Stats
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/8/2021 12:50 PM
Last published date
10/8/2021 12:50 PM
Overview
Buffer latches including the PAGEIOLATCH_EX wait type are used to synchronize access to BUF structures and associated pages in the SQL Server database. This can be a sign of resource issues on the SQL server or a poorly written query. When seen in conjunction with the CXPACKET wait Index Fragmentation is often the cause.
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 an exclusive purpose (read or write operations). If this value is high it is likely that disk or available memory is not keeping up with the workload
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 an exclusive purpose (read or write operations). If this value is high it is likely that disk or available memory is not keeping up with the workload
Resolution
Suggested solutions
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.
- Add additional memory
- Investigate disk latency
- Increase the maximum memory allocation
- Indexing, look for high disk I/O queries
- 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.