(Brian Moran) I’m seeing pageiolatch_sh values in the master..sysprocesses table’s lastwaittype column. Many sysprocesses rows that have a pageiolatch lastwaittype also have nonzero values for waittime, so I know that the server process IDs (SPIDs) are waiting. What do the pageiolatch values mean?
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help