Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Posts
    268

    Unanswered: SQL Server Error Log

    Hi All,

    I found this message in the SQL Server log:

    Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.

    I am not sure if it is an error or just an informational message. I checked the web and found couple of articles but after reading them I still don't understand what it is all about. Can somebody explain it in simple terms?

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    It's informational.

  3. #3
    Join Date
    Jul 2004
    Posts
    268
    What causes it?

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    It's a standard startup message, so you should see this whenever the SQL Server service starts. It just means that there is no set limit to how many locks you can have. Back in the days of SQL 6.5, you had to declare at service start how many locks could be held at any one time. Now it is dynamic.

  5. #5
    Join Date
    Jul 2004
    Posts
    268
    That helps. Thanks.

Posting Permissions

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