How to determine if you've got a session lock from your web application?

Question

Web Application setup:

.Net Framework 4.5.2
SessionState Mode: SQLServer

I'd like to know how we can determine if the application got a session lock.

I tried using performance monitor but i don't know what are the performance counters needed and what exactly are the pointers that we can say that it's a session lock.

Do you mean SQL Server query lock or ASP.NET MVC session lock ? — StepUp, Dec 07 '18 at 11:50
maybe it helps to you https://stackoverflow.com/questions/3629709/i-just-discovered-why-all-asp-net-websites-are-slow-and-i-am-trying-to-work-out — StepUp, Dec 07 '18 at 13:07
@StepUp already saw that but it's not helpful to my question. what i'd like to know is how you can come up that the slowness of the site is caused by session lock. like does it logged an error to the server or what? — John Russel Punio, Dec 07 '18 at 14:30

score 0 · Answer 1 · answered Dec 07 '18 at 12:18

You can use this query to know the blocked Session Information-

SELECT session_id,        
   status,
        DB_NAME(database_id) [Database],
        blocking_session_id,
        wait_type,
        wait_time,
        wait_resource 
FROM    sys.dm_exec_requests
WHERE   blocking_session_id <> 0
GO

And to know some text regarding it use the following query-

SELECT  A.Session_id,
        A.blocking_session_id,
        DB_NAME(B.database_id) [Database],
        C.text
FROM    sys.dm_exec_requests A
        LEFT JOIN sys.dm_exec_requests B ON A.blocking_session_id = B.session_id
        OUTER APPLY sys.dm_exec_sql_text(B.sql_handle) C
WHERE   A.blocking_session_id <> 0

How to determine if you've got a session lock from your web application?

1 Answers1