Results 1 to 3 of 3

Thread: locks

  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: locks

    I Have 359 locks on MY Database ,They are always there on my DB.The DB is a development database and lots of summary Stored procedures will be running on this DB.
    Does it effect the performance.How can I remove those locks.
    Thanks.

  2. #2
    Join Date
    Apr 2003
    Posts
    176
    HEre is the info about the locks.

    spid dbid objid indid type resource mode status
    51 8 0 0 DB s GRANT
    52 8 0 0 DB s GRANT
    53 8 0 0 DB s GRANT

    .........................
    .......................
    444 8 0 0 DB s GRANT




    I Have 359 locks on MY Database ,They are always there on my DB.The DB is a development database and lots of summary Stored procedures will be running on this DB.
    Does it effect the performance.How can I remove those locks.
    Thanks.

  3. #3
    Join Date
    Jul 2004
    Posts
    60
    no worries, mate.
    all is right with the world.
    locks are an essential operating function.
    BLOCKS are a different matter all together. (EDIT: note that blocks are results of exclusive locks...so they are related)
    Now...SOME types of locks can hinder SOME types of operations from a performance perspective...but i wouldnt personally fret about it unless i was troublehsooting an actual problem.

    For a primer go to SQL Books Online, Accessing and Changing Relational Data, Locking, Understanding Locking in SQL Server.

    Note: if locks scare you or your procedures are runnning too slow and you just wanna see how they work without them use the (nolock) table hint in all your select statements. It would help to understand the concept of a dirty read, though - it might not matter if this is a warehouse and not transactional.

    Cheers!
    Last edited by oddity; 07-01-04 at 16:17.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •