(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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

all the best
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
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
FROM master.sys.databases
WHERE database_id = 18

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

--Find the object where the block is occuring

Open in new window


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jasmine SandlasAuthor Commented:
Thanks. This is exactly what I was looking for.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.