16 gig of memory (AWE or WSRM)

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • brian
    #1

    16 gig of memory (AWE or WSRM)

    I have a Windows 2003 Enterprise Server with 16 gig of memory on board.

    What is the best way to allow SQL Server 2000 to access that memory?

    Should I turn on the AWE Memory and set a maximum?
    Or Should I use the WSRM to "unlock" the lock addition memory?

    Apparently, I can not do both as WSRM will not manage AWE Memory.

    Any advice or early warnings you can assist me with before I play
    around too much would be greatly appreciated.

    Thank you in advance.

    Tags: None
    • Ray
      #2
      Re: 16 gig of memory (AWE or WSRM)

      If this server is dedicated to SQL Server then AWE is the way to go. WSRM
      will only restrict processes and will not by itself allow SQL to use more
      than 2GB of RAM. Since the server has exactly 16GB of RAM you might play
      with the /3GB switch and AWE to maximize you memory use.

      "brian" <bblanchard@PRO valUSA.com> wrote in message
      news:1107307604 .350030.248930@ g14g2000cwa.goo glegroups.com.. .[color=blue]
      >I have a Windows 2003 Enterprise Server with 16 gig of memory on board.
      >
      > What is the best way to allow SQL Server 2000 to access that memory?
      >
      > Should I turn on the AWE Memory and set a maximum?
      > Or Should I use the WSRM to "unlock" the lock addition memory?
      >
      > Apparently, I can not do both as WSRM will not manage AWE Memory.
      >
      > Any advice or early warnings you can assist me with before I play
      > around too much would be greatly appreciated.
      >
      > Thank you in advance.
      >[/color]


        Comment

        • Simon Hayes
          #3
          Re: 16 gig of memory (AWE or WSRM)


          "brian" <bblanchard@PRO valUSA.com> wrote in message
          news:1107307604 .350030.248930@ g14g2000cwa.goo glegroups.com.. .[color=blue]
          >I have a Windows 2003 Enterprise Server with 16 gig of memory on board.
          >
          > What is the best way to allow SQL Server 2000 to access that memory?
          >
          > Should I turn on the AWE Memory and set a maximum?
          > Or Should I use the WSRM to "unlock" the lock addition memory?
          >
          > Apparently, I can not do both as WSRM will not manage AWE Memory.
          >
          > Any advice or early warnings you can assist me with before I play
          > around too much would be greatly appreciated.
          >
          > Thank you in advance.
          >[/color]

          Error - Office.com
          http://support.microsoft.com/default.aspx?scid=kb;en-us;274750


          Simon


            Comment

            Previous template Next
            Working...