How to check session deatils with blocked in MS_SQL

How to check session deatils with blocked in MS_SQL
=======================================

======================================================
Full session deatils with blocked
=========================================================
USE Master
GO
EXEC sp_who2
GO


----------------------------------or--------------------------


SELECT spid, kpid, blocked, d.name, open_tran, status, hostname,
cmd, login_time, loginame, net_library
FROM sys.sysprocesses p
INNER JOIN sys.databases d
 on p.dbid=d.database_id



No comments:

Post a Comment

Common Oracle Clusterware crsctl commands

  Oracle Clusterware crsctl commands: # Check cluster status crsctl check crs crsctl check cluster # Cluster resources crsctl status reso...