If you can shed some light on what do I need to be digging for to possibly find problem relating to blocked by and blocking.
Under locks/process id
there is spid 12 (blocked by 12)
and right below there is spid 12 (blocking)
I can see on which db this blocking is happenning but what else would you look for to see if there is any possible problem happenning.
when I go to properties for different types of lock type within that spid, it says
Last TSQL command batch: sp_unprepare;1
Thank you in advance for help.