When you asked for graph, were you referring to SQL Server Profiler graph?

It looks like SPID 76,85 and 91 are suspended. Not sure what process is responsible for it. Is it SPID 25?

So do you need any other log? if yes. can you please tell me what it is and where can find it.

Gila Monster: The above log is from the...

This is SQL Server Log for the whole day. This is all I have. I did not edit the log. The job kicks off an informatica workflow which does ETL...

My manager asked me investigate this and raise a email thread with complete analysis of issue. I just know only 2 points by looking the above error log. I don't...

Please find the below error log.

04/03/2012 16:17:25,spid25s,Unknown,waiter id=processbd531708 mode=IX requestType=wait

04/03/2012 16:17:25,spid25s,Unknown,waiter-list

04/03/2012 16:17:25,spid25s,Unknown,owner-list

04/03/2012 16:17:25,spid25s,Unknown,pagelock fileid=1 pageid=3535848 dbid=8 objectname=dbVelocityMetadata.dbo.WorkQueue id=lock1ac021680 mode=S associatedObjectId=72057594108837888

04/03/2012 16:17:25,spid25s,Unknown,waiter id=process5863048 mode=IX requestType=wait

04/03/2012 16:17:25,spid25s,Unknown,waiter-list

04/03/2012 16:17:25,spid25s,Unknown,owner id=process627948 mode=S

04/03/2012 16:17:25,spid25s,Unknown,owner-list

04/03/2012 16:17:25,spid25s,Unknown,pagelock...

Hustler1986 (4/3/2012)

---

I enabled the trace 1222 on my server.

I just wanna figure out when and where this dead lock is occuring.

If anyone can help me walk through this, I can...

I enabled the trace 1222 on my server.

I just wanna figure out when and where this dead lock is occuring.

If anyone can help me walk through this, I can provide...