Forum Replies Created

Viewing 15 posts - 31 through 45 (of 70 total)

  • RE: Tuning on parallel processing

    Any help ?

  • RE: Tuning on parallel processing

    This is the update statement within the sproc which is getting stuck and creating deadlock (when run parallely in various sessions)

  • RE: Tuning on parallel processing

    First enabled ALTER DATABASE DatabaseName SET ALLOW_SNAPSHOT_ISOLATION ON. Then inside sproc mentioned SET TRANSACTION ISOLATION LEVEL SNAPSHOT. While running it shows error saying "Transaction failed because this DDL statement is...

  • RE: Tuning on parallel processing

    Snapshot isolation didn't worked. It seems it does not work in a sproc where update statement is defined.

  • RE: Tuning on parallel processing

    1. Database is Case Sensitive.

    2. Function definition is attached.

    3. We have to equate the condition that way.

    4. I'll check that out.

    5. It's A.COBDate= B.COBDate (I'll rectify that)

  • RE: Tuning on parallel processing

    Gail, I read your article again and again. That's interesting but still I'm not able to get solution. Can you check for example the attached execution plan and Statistics and...

  • RE: Tuning on parallel processing

    Gail, Isn't Conflict detection present in Snapshot isolation ? Apart from that, is there any way by which we can neglect deadlocks ? Using some locking hints or something ?...

  • RE: Tuning on parallel processing

    That is something which can be achieved using jobs. However I have to work withing codings to avoid deadlocks. I am stuck and not getting any solution.

  • RE: Tuning on parallel processing

    srikant, No issues of different order usage of tables, since we are using same procedure in different sessions (only with different parameteres)

  • RE: Tuning on parallel processing

    I'm planning to use SET TRANSACTION ISOLATION LEVEL SNAPSHOT before update. Will it help me avoid deadlocks ?

  • RE: Tuning on parallel processing

    I checked all almost all of the things. Everything looks fine to me. However there is one update which affects around one thousand rows (on an average) on a table....

  • RE: Tuning on parallel processing

    Hello Gail, I read both the links and they are quite useful. However my main problem is little different. We are using one procedure parallely multiple times (around 30 times...

  • RE: Strange Problem

    Thanks Grant. It certainly helped.

  • RE: Strange Problem

    Hello Grant, I'm really not able to figure it out, though I tried a lot. We are still facing the issue.

  • RE: Can this query be written more efficiently ?

    Thats true if you have only one Field1 value. However if you need resultset for lots of Field1 values, then TOP is not going to work.

Viewing 15 posts - 31 through 45 (of 70 total)