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 RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply