Professional Web Applications Themes

Page locks - Microsoft SQL / MS SQL Server

Hello, I have been knocking myself out trying to find the answer to what I thought was a simple question: What is the maximum number of page locks for SQL Server 2000? I have searched on BOL, all over the web, and cannot seem to find a straight answer to this. If someone can answer this I would really appreciate it. Thanks in advance, John Wilson...

  1. #1

    Default Page locks

    Hello,

    I have been knocking myself out trying to find the answer to what I
    thought was a simple question:

    What is the maximum number of page locks for SQL Server 2000?

    I have searched on BOL, all over the web, and cannot seem to find a
    straight answer to this. If someone can answer this I would really
    appreciate it.

    Thanks in advance,

    John Wilson

    John Guest

  2. #2

    Default Re: Page locks

    From Books Online, topic Maximum Capacity Specifications:

    Maximum locks per instance of SQL Server:
    2,147,483,647 (static)
    40% of SQL Server memory (dynamic)

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "John Wilson" <com> wrote in message
    news:earthlink.net... 


    Jacco Guest

  3. #3

    Default Re: Page locks

    If you run out of locks then your certainly not doing something right<g>.

    --

    Andrew J. Kelly
    SQL Server MVP


    "John Wilson" <com> wrote in message
    news:earthlink.net... 


    Andrew Guest

Similar Threads

  1. Should I use locks?
    By Laphan in forum ASP Database
    Replies: 3
    Last Post: June 28th, 10:57 AM
  2. How much memory do locks use?
    By Sailesh Krishnamurthy in forum IBM DB2
    Replies: 0
    Last Post: July 25th, 07:35 PM
  3. DW MX Locks Up
    By Daz in forum Macromedia Dreamweaver
    Replies: 0
    Last Post: July 24th, 12:36 PM
  4. Locks next to filenames (k)
    By Stern PowerBook in forum Macromedia Dreamweaver
    Replies: 2
    Last Post: July 23rd, 09:00 PM
  5. Too many Locks
    By Jay in forum Informix
    Replies: 1
    Last Post: July 21st, 12:36 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139