Forum Replies Created

Viewing 8 posts - 136 through 143 (of 143 total)

  • RE: SQL jobs Dead Locks Issue

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

  • RE: SQL jobs Dead Locks Issue

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

  • RE: SQL jobs Dead Locks Issue

    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...

  • RE: SQL jobs Dead Locks Issue

    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...

  • RE: SQL jobs Dead Locks Issue

    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...

  • RE: SQL jobs Dead Locks Issue

    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...

  • RE: SQL jobs Dead Locks Issue

    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...

  • RE: SQL jobs Dead Locks Issue

    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...

Viewing 8 posts - 136 through 143 (of 143 total)