Question : I am trying to troubleshoot an issue with below things noticed:- There is this stored proc which gets […]
Tag: latch
NOLOCK or Read Uncommitted locking / latching behaviours
Question : I’ve read many, many different takes on how NOLOCK or the read uncommitted isolation levels function in terms […]
Wait Stats on Microsoft Azure test
Question : On a particular test we’re doing with Microsoft Azure, we are seeing a wait_category called: PAGE LATCH (non-I/O) […]
SELECT xyz INTO #Temp from SSMS is 5x longer in one environment than another [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
SQL Server – High buffer time
Question : I’m noticing a high number of waitingRequestsCount on SQL server. The latch_class is buffer. See attached screenshots. Going […]
LATCH_EX and CX_PACKETS for a stored proc seen when timing out
Question : I am trying to troubleshoot an issue with below things noticed:- There is this stored proc which gets […]