Results 1 to 2 of 2

Thread: Memory pb

  1. #1
    Join Date
    Nov 2003

    Exclamation Unanswered: Memory pb

    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
    In front of the computer
    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).


Posting Permissions

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