SQL Server Performance

would "Rowlock" cause deadlocks?

Discussion in 'General DBA Questions' started by eramgarden, Aug 8, 2006.

  1. eramgarden New Member

    I turned on profiler, looked at the vendor app and saw they're using a "rowlock" and an "index hint" for some "select" statements..

    Read some about "rowlock"...is that a bad idea? client has reported some deadlocks so i was wondering..

  2. Luis Martin Moderator

    From BOL:

    The SQL Server query optimizer automatically makes the correct determination. It is recommended that table-level locking hints be used to change the default locking behavior only when necessary. Disallowing a locking level can affect concurrency adversely.

    What about long queries, and try to optimize those queries?. Execution plan, better indexes, etc.

    Luis Martin

    All in Love is Fair
    Stevie Wonder

    All postings are provided “AS IS” with no warranties for accuracy.

  3. satya Moderator

Share This Page