Recently I have noticed some threads running on our sql server which are invoked from our application, which are in a sleeping status for a few minutes and have open transactions (usually just one).
I added the parameter @get_locks = 1 to sp_whoisactive to see what they were holding and the xml result set looks like this
<Database name="NOG_APP"> <Locks> <Lock request_mode="S" request_status="GRANT" request_count="1" /> </Locks> </Database>
I don't see any objects in here... how am I to interpret this? Does it mean that this thread is not holding any locks? If so why doesn't the output return NULL?
Running SQL Server 2012 SP3.