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

    thanks.
  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
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


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



  3. satya Moderator

Share This Page