Sample Header Ad - 728x90

What does it mean if all of my wait_resources in the System Health Extended Event are the same pointer?

3 votes
1 answer
103 views
It's notoriously impossible to decode [what the wait_resource pointer in the System Health Extended Event means](https://dba.stackexchange.com/questions/320594/identifying-wait-resource-for-wait-info-extended-events) . But if all of my long waits in that Extended Event for a certain time period are reporting the same pointer, then does that indicate anything at all? I'm experiencing high PAGELATCH_SH waits for this time period and expect that the reason why all of pointers are the same will be related to that. I've not included the XML here because I am absolutely certain that it won't help answer the question. I'm just trying to fathom if there is ever a case where I should pay attention to the wait_resource value in this Extended Event when it is obviously a pointer.
Asked by J. Mini (1225 rep)
Mar 5, 2025, 06:28 PM
Last activity: Mar 11, 2025, 03:04 AM