Post reply

DB lock

  • October 10, 2012 at 5:04 am

    #263727

    I have a huge database accessing multiple user( Node) and perform number of transactions

    from today morning an error occurred transaction db lock for generating reports so please give me a solution how to control it.

  • October 10, 2012 at 6:59 am

    #1547633

    Need more details. Database locks are usually harmless and to be ignored. Only exclusive DB locks (from altering the DB) are problematic, and the operations that require those shouldn't be run on a production DB during business hours.

    For general blocking, chapter 6: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply