To Check SQL Server Status & Blocking Process

-- 1. To check any blocking in SQL server

SELECT CMD, * FROM SYS.SYSPROCESSES WHERE BLOCKED > 0

-- 2. Check the log space in the server

DBCC SQLPERF (LOGSPACE)

GO

  

-- 3. Check any process is running for long time.

SP_WHO2