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 Pool. Can someone please explain what could contribute to high number of waits?

Asked by Adit Bhatia
(21 rep)
Oct 15, 2019, 03:13 PM
Last activity: Feb 20, 2020, 11:00 PM
Last activity: Feb 20, 2020, 11:00 PM