How much memory can SQL 2000 Standard Edition utilize

How much memory can SQL 2000 Standard Edition utilize?
For some reason I thought it was 4 GB, but when I looked
at the hardware specification it comes up with 2 GB. I
guess I really never paid much attention to this.
OR, does the service pack increase it to 4 GB and that's
why I have 4 GB in my head.
Or, is the theory that the OS will use 2 GB and dedicating
the other 2 GB to SQL.
Also, thought I have seen in the SQL Enterprise Manager
that I was able to slide the memory to 4 GB as well.2 gb.
Please refer to the article in BOL entitled, "Maximum Capacity
Specifications".
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:22e9c01c45de6$68234660$a401280a@.phx.gbl...
> How much memory can SQL 2000 Standard Edition utilize?
> For some reason I thought it was 4 GB, but when I looked
> at the hardware specification it comes up with 2 GB. I
> guess I really never paid much attention to this.
> OR, does the service pack increase it to 4 GB and that's
> why I have 4 GB in my head.
> Or, is the theory that the OS will use 2 GB and dedicating
> the other 2 GB to SQL.
> Also, thought I have seen in the SQL Enterprise Manager
> that I was able to slide the memory to 4 GB as well.
>|||What is BOL? What is the link?
>--Original Message--
>2 gb.
>Please refer to the article in BOL entitled, "Maximum
Capacity
>Specifications".
>"Lee" <anonymous@.discussions.microsoft.com> wrote in
message
>news:22e9c01c45de6$68234660$a401280a@.phx.gbl...
>> How much memory can SQL 2000 Standard Edition utilize?
>> For some reason I thought it was 4 GB, but when I looked
>> at the hardware specification it comes up with 2 GB. I
>> guess I really never paid much attention to this.
>> OR, does the service pack increase it to 4 GB and that's
>> why I have 4 GB in my head.
>> Or, is the theory that the OS will use 2 GB and
dedicating
>> the other 2 GB to SQL.
>> Also, thought I have seen in the SQL Enterprise Manager
>> that I was able to slide the memory to 4 GB as well.
>
>.
>|||SQL Server Books Online. It's SQL Server's help file... Check out
Programs -> Microsoft SQL Server -> Books Online. Or, click Help from
within Query Analyzer or Profiler.
<anonymous@.discussions.microsoft.com> wrote in message
news:2270401c45de9$b5cde7f0$a601280a@.phx.gbl...
> What is BOL? What is the link?
> >--Original Message--
> >2 gb.
> >
> >Please refer to the article in BOL entitled, "Maximum
> Capacity
> >Specifications".
> >
> >"Lee" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:22e9c01c45de6$68234660$a401280a@.phx.gbl...
> >> How much memory can SQL 2000 Standard Edition utilize?
> >> For some reason I thought it was 4 GB, but when I looked
> >> at the hardware specification it comes up with 2 GB. I
> >> guess I really never paid much attention to this.
> >>
> >> OR, does the service pack increase it to 4 GB and that's
> >> why I have 4 GB in my head.
> >>
> >> Or, is the theory that the OS will use 2 GB and
> dedicating
> >> the other 2 GB to SQL.
> >>
> >> Also, thought I have seen in the SQL Enterprise Manager
> >> that I was able to slide the memory to 4 GB as well.
> >>
> >
> >
> >.
> >|||BOL - SQL Server Books online.
Tahnks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2270401c45de9$b5cde7f0$a601280a@.phx.gbl...
> What is BOL? What is the link?
> >--Original Message--
> >2 gb.
> >
> >Please refer to the article in BOL entitled, "Maximum
> Capacity
> >Specifications".
> >
> >"Lee" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:22e9c01c45de6$68234660$a401280a@.phx.gbl...
> >> How much memory can SQL 2000 Standard Edition utilize?
> >> For some reason I thought it was 4 GB, but when I looked
> >> at the hardware specification it comes up with 2 GB. I
> >> guess I really never paid much attention to this.
> >>
> >> OR, does the service pack increase it to 4 GB and that's
> >> why I have 4 GB in my head.
> >>
> >> Or, is the theory that the OS will use 2 GB and
> dedicating
> >> the other 2 GB to SQL.
> >>
> >> Also, thought I have seen in the SQL Enterprise Manager
> >> that I was able to slide the memory to 4 GB as well.
> >>
> >
> >
> >.
> >|||Does anyone have a link to the Maximum Capacity Specifications for Win 2003
Server editions? Also for SBS Premium 2003?
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uchVeeeXEHA.3044@.TK2MSFTNGP09.phx.gbl...
> 2 gb.
> Please refer to the article in BOL entitled, "Maximum Capacity
> Specifications".
> "Lee" <anonymous@.discussions.microsoft.com> wrote in message
> news:22e9c01c45de6$68234660$a401280a@.phx.gbl...
> > How much memory can SQL 2000 Standard Edition utilize?
> > For some reason I thought it was 4 GB, but when I looked
> > at the hardware specification it comes up with 2 GB. I
> > guess I really never paid much attention to this.
> >
> > OR, does the service pack increase it to 4 GB and that's
> > why I have 4 GB in my head.
> >
> > Or, is the theory that the OS will use 2 GB and dedicating
> > the other 2 GB to SQL.
> >
> > Also, thought I have seen in the SQL Enterprise Manager
> > that I was able to slide the memory to 4 GB as well.
> >
>|||That would be better answered in one of the Windows groups
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Victoria Yudin" <victoria@.flex-solutions.com> wrote in message
news:%23qDd$yhXEHA.1128@.TK2MSFTNGP10.phx.gbl...
> Does anyone have a link to the Maximum Capacity Specifications for Win
2003
> Server editions? Also for SBS Premium 2003?
>
> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
> news:uchVeeeXEHA.3044@.TK2MSFTNGP09.phx.gbl...
> > 2 gb.
> >
> > Please refer to the article in BOL entitled, "Maximum Capacity
> > Specifications".
> >
> > "Lee" <anonymous@.discussions.microsoft.com> wrote in message
> > news:22e9c01c45de6$68234660$a401280a@.phx.gbl...
> > > How much memory can SQL 2000 Standard Edition utilize?
> > > For some reason I thought it was 4 GB, but when I looked
> > > at the hardware specification it comes up with 2 GB. I
> > > guess I really never paid much attention to this.
> > >
> > > OR, does the service pack increase it to 4 GB and that's
> > > why I have 4 GB in my head.
> > >
> > > Or, is the theory that the OS will use 2 GB and dedicating
> > > the other 2 GB to SQL.
> > >
> > > Also, thought I have seen in the SQL Enterprise Manager
> > > that I was able to slide the memory to 4 GB as well.
> > >
> >
> >
>