Results 1 to 2 of 2

Thread: Memory pb

  1. #1
    Join Date
    Nov 2003
    Posts
    68

    Exclamation Unanswered: Memory pb

    Hie,
    When i restrict the memory of the db in property dialog box, the process sqlserv.exe increase his memry above this limit why ?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Have you enabled AWE? That pretty much circumvents the normal Windows process management, mostly because that is exactly what it is supposed to do!

    Even if you haven't enabled AWE, the server responds to its environment. If large blocks of RAM are not being used, then the OS can elect to dynamically ease the restrictions on an application that is memory starved (which happens fast with a busy SQL Server).

    -PatP

Posting Permissions

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