(Blocking Detected On Production Server), Can anybody please help me understand the Report?

I have a blocking report (Blocking Detected On Production Server), Can anybody please help me understand that?

Here are the details:-

Session_id || Status || blocking_session_id || wait_type || wait_resource || WaitSec || cpu_time || Logical_reads || reads || writes

156 || Suspended || 137 || LCK_M_IS || OBJECT: 18:925246351:4 || 172.660000 || 7 || 204 || 66 || 0 ||

Anything more about this will be very helpful.

Thanks in Advance.
Jasmine SandlasAsked:
Who is Participating?
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
That means that the process with id 156 is being blocked by the process with id 137.
The status of the process is Suspended and that means waiting for a resource to available. This can be confirmed by the lock type LCK_M_IS, that means waiting to acquire an intent shared lock.
The process is waiting already for more than 172 seconds for a resource to be released on an object with id 925246351 in the database with id 18. Check in master.sys.databases table for the database name that has the id 18 and then go to that database and check which object has the id 925246351:
-- Identifiy the database
SELECT name
FROM master.sys.databases
WHERE database_id = 18

--Replace the databaseName with the value returned by the previous query
USE databaseName
GO

--Find the object where the block is occuring
SELECT OBJECT_NAME(925246351)

Open in new window

0
 
Sajid Shaik MSr. System AdminCommented:
the above one is related to SQL server ... check sql logs about more details ..

all the best
0
 
Jasmine SandlasAuthor Commented:
Yes this is from SQL server, the logs don't have anything. Just wanted to know how this session ID and blocking session ID related and where we can actually see  table or Stored procedure blocking
0
 
Jasmine SandlasAuthor Commented:
Thanks. This is exactly what I was looking for.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.