RAM

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

    RAM

    Is it true that SQL Server Standard edition can only use 2 GB of RAM?

    If so, and the box has more, does that mean the excess WILL be
    available for the O/S and any other apps?
    Tags: None
    • GL
      #2
      Re: RAM

      You are correct

      (assuming we are talking about SQL server 2000 standard edition)

      GL

      "Ellen K." <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message
      news:ia8d805t3v p4c3riv2hfnfgaa 3ubhk0nvp@4ax.c om...[color=blue]
      > Is it true that SQL Server Standard edition can only use 2 GB of RAM?
      >
      > If so, and the box has more, does that mean the excess WILL be
      > available for the O/S and any other apps?[/color]


        Comment

        • Ellen K.
          #3
          Re: RAM

          Thanks.

          On Wed, 21 Apr 2004 11:01:28 -0700, "GL"
          <GL@noSpam.Repl yToNewsgroup.co m> wrote:
          [color=blue]
          >You are correct
          >
          >(assuming we are talking about SQL server 2000 standard edition)
          >
          >GL
          >
          >"Ellen K." <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message
          >news:ia8d805t3 vp4c3riv2hfnfga a3ubhk0nvp@4ax. com...[color=green]
          >> Is it true that SQL Server Standard edition can only use 2 GB of RAM?
          >>
          >> If so, and the box has more, does that mean the excess WILL be
          >> available for the O/S and any other apps?[/color]
          >[/color]

            Comment

            • Ellen K.
              #4
              Re: RAM

              I didn't know the O/S itself limits us to 4 GB, that is very important
              information, thank you. But at least if the 2 GB that SQL Server
              can't use WILL be used by the O/S, we are probably good.

              On Wed, 21 Apr 2004 15:41:22 -0400, "Daniel A. Thomas"
              <dathomas@--spam--istar.ca> wrote:
              [color=blue]
              >
              >"Ellen K." <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message
              >news:ia8d805t3 vp4c3riv2hfnfga a3ubhk0nvp@4ax. com...
              >| Is it true that SQL Server Standard edition can only use 2 GB of RAM?
              >|
              >| If so, and the box has more, does that mean the excess WILL be
              >| available for the O/S and any other apps?
              >
              >
              >Keep your OS specifications in mind when choosing your version of SQL
              >Server. For example, Windows Server 2000 / 2003 Standard Edition has the
              >following memory specifications:
              >
              >Support for up to 4GB of memory. Of that 4GB, the operating system always
              >reserves anything above 2GB for its own use. This allows applications
              >on the server to share a maximum of 2GB.
              >
              >Dan Thomas[/color]

                Comment

                • GL
                  #5
                  Re: RAM

                  If you move to Windows 2003 Server, those memory limits are raised...

                  See this MS page for more info on Windows Server 2003 specs:
                  http://www.microsoft.com/windowsserver2003/evaluation/features/compareeditions.mspx


                  GL

                  "Ellen K." <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message
                  news:7grf80d6v6 pbnfb966q8ak5ib 2ab7pq1ou@4ax.c om...[color=blue]
                  > I didn't know the O/S itself limits us to 4 GB, that is very important
                  > information, thank you. But at least if the 2 GB that SQL Server
                  > can't use WILL be used by the O/S, we are probably good.
                  >
                  > On Wed, 21 Apr 2004 15:41:22 -0400, "Daniel A. Thomas"
                  > <dathomas@--spam--istar.ca> wrote:
                  >[color=green]
                  > >
                  > >"Ellen K." <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message
                  > >news:ia8d805t3 vp4c3riv2hfnfga a3ubhk0nvp@4ax. com...
                  > >| Is it true that SQL Server Standard edition can only use 2 GB of RAM?
                  > >|
                  > >| If so, and the box has more, does that mean the excess WILL be
                  > >| available for the O/S and any other apps?
                  > >
                  > >
                  > >Keep your OS specifications in mind when choosing your version of SQL
                  > >Server. For example, Windows Server 2000 / 2003 Standard Edition has the
                  > >following memory specifications:
                  > >
                  > >Support for up to 4GB of memory. Of that 4GB, the operating system always
                  > >reserves anything above 2GB for its own use. This allows applications
                  > >on the server to share a maximum of 2GB.
                  > >
                  > >Dan Thomas[/color]
                  >[/color]


                    Comment

                    • Daniel A. Thomas
                      #6
                      Re: RAM


                      "Ellen K." <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message
                      news:ia8d805t3v p4c3riv2hfnfgaa 3ubhk0nvp@4ax.c om...
                      | Is it true that SQL Server Standard edition can only use 2 GB of RAM?
                      |
                      | If so, and the box has more, does that mean the excess WILL be
                      | available for the O/S and any other apps?


                      Keep your OS specifications in mind when choosing your version of SQL
                      Server. For example, Windows Server 2000 / 2003 Standard Edition has the
                      following memory specifications:

                      Support for up to 4GB of memory. Of that 4GB, the operating system always
                      reserves anything above 2GB for its own use. This allows applications
                      on the server to share a maximum of 2GB.

                      Dan Thomas

                        Comment

                        • Ellen K.
                          #7
                          Re: RAM

                          That page still shows 4 GB for the Standard Edition, but it's a good
                          reference, thanks. :)

                          I think we will be fine with 4 GB.

                          On Thu, 22 Apr 2004 10:19:17 -0700, "GL"
                          <GL@noSpam.Repl yToNewsgroup.co m> wrote:
                          [color=blue]
                          >If you move to Windows 2003 Server, those memory limits are raised...
                          >
                          >See this MS page for more info on Windows Server 2003 specs:
                          >http://www.microsoft.com/windowsserv...eeditions.mspx
                          >
                          >GL
                          >
                          >"Ellen K." <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message
                          >news:7grf80d6v 6pbnfb966q8ak5i b2ab7pq1ou@4ax. com...[color=green]
                          >> I didn't know the O/S itself limits us to 4 GB, that is very important
                          >> information, thank you. But at least if the 2 GB that SQL Server
                          >> can't use WILL be used by the O/S, we are probably good.
                          >>
                          >> On Wed, 21 Apr 2004 15:41:22 -0400, "Daniel A. Thomas"
                          >> <dathomas@--spam--istar.ca> wrote:
                          >>[color=darkred]
                          >> >
                          >> >"Ellen K." <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message
                          >> >news:ia8d805t3 vp4c3riv2hfnfga a3ubhk0nvp@4ax. com...
                          >> >| Is it true that SQL Server Standard edition can only use 2 GB of RAM?
                          >> >|
                          >> >| If so, and the box has more, does that mean the excess WILL be
                          >> >| available for the O/S and any other apps?
                          >> >
                          >> >
                          >> >Keep your OS specifications in mind when choosing your version of SQL
                          >> >Server. For example, Windows Server 2000 / 2003 Standard Edition has the
                          >> >following memory specifications:
                          >> >
                          >> >Support for up to 4GB of memory. Of that 4GB, the operating system always
                          >> >reserves anything above 2GB for its own use. This allows applications
                          >> >on the server to share a maximum of 2GB.
                          >> >
                          >> >Dan Thomas[/color]
                          >>[/color]
                          >[/color]

                            Comment

                            • Ellen K.
                              #8
                              Re: RAM

                              Thanks.

                              On Wed, 21 Apr 2004 11:01:28 -0700, "GL"
                              <GL@noSpam.Repl yToNewsgroup.co m> wrote:
                              [color=blue]
                              >You are correct
                              >
                              >(assuming we are talking about SQL server 2000 standard edition)
                              >
                              >GL
                              >
                              >"Ellen K." <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message
                              >news:ia8d805t3 vp4c3riv2hfnfga a3ubhk0nvp@4ax. com...[color=green]
                              >> Is it true that SQL Server Standard edition can only use 2 GB of RAM?
                              >>
                              >> If so, and the box has more, does that mean the excess WILL be
                              >> available for the O/S and any other apps?[/color]
                              >[/color]

                                Comment

                                • Ellen K.
                                  #9
                                  Re: RAM

                                  I didn't know the O/S itself limits us to 4 GB, that is very important
                                  information, thank you. But at least if the 2 GB that SQL Server
                                  can't use WILL be used by the O/S, we are probably good.

                                  On Wed, 21 Apr 2004 15:41:22 -0400, "Daniel A. Thomas"
                                  <dathomas@--spam--istar.ca> wrote:
                                  [color=blue]
                                  >
                                  >"Ellen K." <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message
                                  >news:ia8d805t3 vp4c3riv2hfnfga a3ubhk0nvp@4ax. com...
                                  >| Is it true that SQL Server Standard edition can only use 2 GB of RAM?
                                  >|
                                  >| If so, and the box has more, does that mean the excess WILL be
                                  >| available for the O/S and any other apps?
                                  >
                                  >
                                  >Keep your OS specifications in mind when choosing your version of SQL
                                  >Server. For example, Windows Server 2000 / 2003 Standard Edition has the
                                  >following memory specifications:
                                  >
                                  >Support for up to 4GB of memory. Of that 4GB, the operating system always
                                  >reserves anything above 2GB for its own use. This allows applications
                                  >on the server to share a maximum of 2GB.
                                  >
                                  >Dan Thomas[/color]

                                    Comment

                                    • GL
                                      #10
                                      Re: RAM

                                      If you move to Windows 2003 Server, those memory limits are raised...

                                      See this MS page for more info on Windows Server 2003 specs:
                                      http://www.microsoft.com/windowsserver2003/evaluation/features/compareeditions.mspx


                                      GL

                                      "Ellen K." <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message
                                      news:7grf80d6v6 pbnfb966q8ak5ib 2ab7pq1ou@4ax.c om...[color=blue]
                                      > I didn't know the O/S itself limits us to 4 GB, that is very important
                                      > information, thank you. But at least if the 2 GB that SQL Server
                                      > can't use WILL be used by the O/S, we are probably good.
                                      >
                                      > On Wed, 21 Apr 2004 15:41:22 -0400, "Daniel A. Thomas"
                                      > <dathomas@--spam--istar.ca> wrote:
                                      >[color=green]
                                      > >
                                      > >"Ellen K." <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message
                                      > >news:ia8d805t3 vp4c3riv2hfnfga a3ubhk0nvp@4ax. com...
                                      > >| Is it true that SQL Server Standard edition can only use 2 GB of RAM?
                                      > >|
                                      > >| If so, and the box has more, does that mean the excess WILL be
                                      > >| available for the O/S and any other apps?
                                      > >
                                      > >
                                      > >Keep your OS specifications in mind when choosing your version of SQL
                                      > >Server. For example, Windows Server 2000 / 2003 Standard Edition has the
                                      > >following memory specifications:
                                      > >
                                      > >Support for up to 4GB of memory. Of that 4GB, the operating system always
                                      > >reserves anything above 2GB for its own use. This allows applications
                                      > >on the server to share a maximum of 2GB.
                                      > >
                                      > >Dan Thomas[/color]
                                      >[/color]


                                        Comment

                                        • Ellen K.
                                          #11
                                          Re: RAM

                                          That page still shows 4 GB for the Standard Edition, but it's a good
                                          reference, thanks. :)

                                          I think we will be fine with 4 GB.

                                          On Thu, 22 Apr 2004 10:19:17 -0700, "GL"
                                          <GL@noSpam.Repl yToNewsgroup.co m> wrote:
                                          [color=blue]
                                          >If you move to Windows 2003 Server, those memory limits are raised...
                                          >
                                          >See this MS page for more info on Windows Server 2003 specs:
                                          >http://www.microsoft.com/windowsserv...eeditions.mspx
                                          >
                                          >GL
                                          >
                                          >"Ellen K." <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message
                                          >news:7grf80d6v 6pbnfb966q8ak5i b2ab7pq1ou@4ax. com...[color=green]
                                          >> I didn't know the O/S itself limits us to 4 GB, that is very important
                                          >> information, thank you. But at least if the 2 GB that SQL Server
                                          >> can't use WILL be used by the O/S, we are probably good.
                                          >>
                                          >> On Wed, 21 Apr 2004 15:41:22 -0400, "Daniel A. Thomas"
                                          >> <dathomas@--spam--istar.ca> wrote:
                                          >>[color=darkred]
                                          >> >
                                          >> >"Ellen K." <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message
                                          >> >news:ia8d805t3 vp4c3riv2hfnfga a3ubhk0nvp@4ax. com...
                                          >> >| Is it true that SQL Server Standard edition can only use 2 GB of RAM?
                                          >> >|
                                          >> >| If so, and the box has more, does that mean the excess WILL be
                                          >> >| available for the O/S and any other apps?
                                          >> >
                                          >> >
                                          >> >Keep your OS specifications in mind when choosing your version of SQL
                                          >> >Server. For example, Windows Server 2000 / 2003 Standard Edition has the
                                          >> >following memory specifications:
                                          >> >
                                          >> >Support for up to 4GB of memory. Of that 4GB, the operating system always
                                          >> >reserves anything above 2GB for its own use. This allows applications
                                          >> >on the server to share a maximum of 2GB.
                                          >> >
                                          >> >Dan Thomas[/color]
                                          >>[/color]
                                          >[/color]

                                            Comment

                                            Previous template Next
                                            Working...