Questions tagged [latch]

A latch is a lightweight lock on an in-memory structure to prevent concurrent writes to an in-memory data page in a concurrent update scenario

Filter by
Sorted by
Tagged with
0
votes
1answer
69 views

Buffer Latch Type 3 and Failed To Generate Checkpoint Errors

I am getting this in the log file: Time-out occurred while waiting for buffer latch type 3 for page (1:4660738) database ID 5 The database is in Full mode & logs are backing up every 15 minutes ...
2
votes
1answer
210 views

Differences of latch and lock

Recently when i was trying to find information about latch_ex wait type, i come across one blog as below which stated about latch and lock. After reading this blog , i m just curious in one thing. ...
1
vote
1answer
332 views

SQL Server - High buffer time

I'm noticing a high number of waitingRequestsCount on SQL server. The latch_class is buffer. See attached screenshots. Going through SQL server dashboard, I see high number (32221334) waits for Buffer ...
5
votes
1answer
171 views

NOLOCK or Read Uncommitted locking / latching behaviours

I've read many, many different takes on how NOLOCK or the read uncommitted isolation levels function in terms of locks / latches taken. When using a SELECT with NOLOCK or in the Read Uncommitted ...
0
votes
1answer
30 views

Wait Stats on Microsoft Azure test

On a particular test we're doing with Microsoft Azure, we are seeing a wait_category called: PAGE LATCH (non-I/O) that we're unfamiliar with. In our test, CaptureSeconds = 1595 and for PAGE LATCH (...
1
vote
1answer
7k views

Non-yielding Scheduler Error with dump caused by heavy queries on SQL 2016

After bringing our databases to new servers with new hardware and new os (2012 server) and new SQL Server version (2016 sp1) we face the following issue: During nightly reporting database update runs,...
5
votes
1answer
364 views

Database ID of a non-existent database - time-out waiting for buffer latch on page appearing in error log

Background: I've recently started at a new shop with lots of databases in various states. I arrived this morning (having just been added to the SQL DBA mailing group) to find an email about the ...
0
votes
1answer
1k views

ACCESS_METHODS_DATASET_PARENT Problem

We had an AlwaysOn Async replica we had some problems so we deleted the availability group After that the database and CPU seem to work abnormally It's very slow and we have waittype = LATCH_EX , ...
5
votes
3answers
12k views

How to reduce huge CXPACKET & LATCH_EX (ACCESS_METHODS_DATASET_PARENT) wait times?

Problem We have been experiencing high levels of user disruption due to SQL timeouts accross our systems since the beginning of the year. The SQL-Server instance in question has very high CPU usage (...
6
votes
1answer
89 views

SELECT xyz INTO #Temp from SSMS is 5x longer in one environment than another [closed]

First time posting, I hope I'm doing it right. I'm a "dba by accident" who is learning a lot but admittedly still has a lot more to learn. Here is my brain dump: Prod server has 5 million rows. I ...
2
votes
1answer
196 views

Non Buffer Latch - Forefront Identity Manager

We are using Forefront Identity Manger and we are doing an initial load to which we are experiencing slow performance. I always start with wait types for such things and can see %30 CXPACKET, %25 ...