A user’s process will occasionally hang or spin and lock out other sessions. If the DBA still has access to the database, she can usually just issue the following query. (R)
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help