I have just started using
Spotlight as I'm a software developer, but I am forced to identify database issues causing blocking (Spotlight shows me
AWAITING_COMMAND at the points and all other processes are blocked, I assume this happens because the awaiting command involves a lock on a table that the rest of processes are trying to update). But this is not the case actually.
In SQL Activity => Locks I've noticed that there's plenty of locks in
S mode on DATABASE (Lock Type), would anyone explain me what that actually means, is it harmful for the database and what may be the cause of it?
sys.dm_tran_locks and what I'm receiving are locks on
resource_type DATABASE. This is basically what I'd like to get insight on. I don't understand what that means.