multiple PAGELATCH_UP waits on data file
-
Hi Experts,
What is meant by PAGELATCH_UP waittype ? what does it trying to tell me? what is PFS ? why INSERTS are blocking each other? As per knowledge, insert shouldn’t block each other?
Since they are getting blocked , waiting for LCK and so went to suspended state. Does this indicate a highly transactional busy server? Anything needs to be monitored here? what's the difference between a lock and a latch?
Cheers,
Bob
-
Insert operations can absolutely block one another. If a lock, or a latch, is held on a page by one operation, then other operations will wait for access. Latches are basically a type of lock taken internally in memory by SQL Server. You can read all about them, and how to address issues with them, here in this article.
----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
The Scary DBA Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply