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 (non-I/O) it reports:
wait_time_ms = 126666216
wait_time_ms_per_sec = 79364
max_waiting_tasks = 13086110
average_wait_time_ms = 9
max_Wait_time_ms = 2526
Can someone tell me what PAGE LATCH (non-I/O) wait category is and whether this is indicating a problem of some sort?
Thanks,
RW
Asked by Robert West
(21 rep)
Oct 3, 2018, 03:06 PM
Last activity: Oct 3, 2018, 03:24 PM
Last activity: Oct 3, 2018, 03:24 PM