Post reply

@@LOCK_TIMEOUT

  • August 27, 2003 at 10:09 am

    #59433

    What does this value mean when I run Select @@LOCK_TIMEOUT?

    -1

    Thanks


    Aurora

  • August 27, 2003 at 5:43 pm

    #471712

    Check Books Online. A value of -1 means that the lock timeout hasn't been set for the current session.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • August 28, 2003 at 6:46 am

    #471784

    What about when locks are configured with the default values such as this result from sp_configure 'locks':

    name minimum maximum config_value run_value

    locks 5000 2147483647 0 0

    Is the default 0, set as SQL server will use as many as it needs? I am having some locking issues and wonder if I'm heading in the right direction. A victim resouce happens when I do a bulk insert load. Loading approx. 50 million rows.

    Thanks


    Aurora

  • August 28, 2003 at 6:53 am

    #471789

    Have a look at the TABLOCK option for BULK INSERT in Books Online

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • August 28, 2003 at 7:11 am

    #471801

    Thanks! But is the default 0 grabbing all it needs?


    Aurora

  • August 28, 2003 at 7:18 am

    #471804

    With a setting of 0, SQL will dynamically allocate locks as needed up to approx 40% of the memory SQL Server currently has allocated to it. If it needs more than that, and its configured to dynamically allocate memory, it will grab more memory from the OS.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • August 28, 2003 at 7:54 am

    #471817

    Thanks Phill, you have been a big help pointing me in the right direction. I truly appreciate it.


    Aurora

Viewing 7 posts - 1 through 6 (of 6 total)

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