PAGELATCH_EX Wait Type

With the PAGELATCH_EX wait type the EX implies that it is an exclusive lock, while the page is waiting to access a data page in memory, as opposed to one that is being read from disk.

Can be associated with the rate of inserts into a table. Common when working with a clustered index on an increasing value like IDENTITY or a datetime.

See also


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!