Deadlock - deadlocked on lock resources

[Former Member]

Hello,

We are running into D/B deadlocking issues time to time, we don't know why is happening... Here is the log:

Any help will be greatly appreciated..

==============[System Error Tracing]==============

[System  Name] : OSoftOptimizeManage

[Message Type] : ErrorMessage

[Job Name]     : CheckProcessState()

[DateTime]     : 10/23/2014 12:05:14 PM

[UserId]       : BPPUKUSER

[SqlException]

    Type      : System.Data.SqlClient.SqlException

    Errors    : System.Data.SqlClient.SqlErrorCollection

    Class     : 13

    LineNumber: 3

    Message   : {Transaction (Process ID 270) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.}

    Number    : 1205

    Procedure :

    Server    : UKBRIWBPCDBPT\UKOLTP

    State     : 56

    Source    : .Net SqlClient Data Provider

    TargetSite:

    HelpLink  :

==============[System Error Tracing  End ]==============

[Former Member]

Syed,

I'd suggest to talk to your DBA regarding this. SQL Server would have more info about deadlock then BPC log. SQL trace flags 1204 and 1222 would help your DBA to provide you more info.

regards,

Akim

[former_member186498]

Hi Syed,

probably you're running a non-lite optimize during user activity or when other oackages are running.

Only the lite optimize without flag (compress, etc) should be run during user activity and the other types (also lite optimize flagged) should be scheduled on the night.

Regards

     Roberto

[Former Member]

Thanks Roberto...No, we run Lite optimize w/o compression during the day and run FULL optimization every night (This is also without Compression) and weekly we optimize ALL application with compression manually...

Hope this helps, let me know if you have any more questions...Thanks for your time...

[former_member186498]

Hi Syed,

which optimize has the dealock?

Did you try to execute it again?

Regards

     Roberto