MS SQL Server – Identify and resolve concurrency problems (monitorowanie bazy)

– Right click on SQL Server in SSMS and than click on Activity Monitor;
– SQL and T-SQL statements – Dynamic management view and exec sp_who2 which provides information about current users, sessions, and processes in an instance of the SQL Server Database Engine:

select * 
from sys.dm_tran_locks
where resource_database_id = 5

select *
from sys.dm_os_waiting_tasks
where session_id in ()

select *
from sys.dm_exec_requests

exec sp_who2