5 GIG on Advanced 2000 with Std Ed 2000

After installing the 5 GIG on the Advanced Server, only two gig is available.
If an upgrade is made to SQL Server 2005 STD for this machine, are there
pitfalls to be aware of? Alternatively, Advanced Server is dual processor,
is there a strategy available to set each processor to use 2 gig?
--
Regards,
JamieHi Jamie,
Can you be specific as to which operation system and SQL version is
currently installed?
Have you added the /3GB switch to boot.ini?
On Jan 20, 9:27 pm, thejamie <theja...@.discussions.microsoft.com>
wrote:
> After installing the 5 GIG on the Advanced Server, only two gig is available.
> If an upgrade is made to SQL Server 2005 STD for this machine, are there
> pitfalls to be aware of? Alternatively, Advanced Server is dual processor,
> is there a strategy available to set each processor to use 2 gig?
> --
> Regards,
> Jamie|||There is no limitations in SQL Server 2005 Standard editions. Limitation is
all based on the type of operating system
Take a look into below URL.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad125641/RequirementsSQL2005.htm
Thanks
Hari
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:82B017BD-E9BE-4E06-89BA-B404ACD42F30@.microsoft.com...
> Advanced Server 2000 (with 5 GIG RAM) running Standard Edition 2000 SQL
> Server
> --
> Regards,
> Jamie
>
> "Shoval" wrote:
>> Hi Jamie,
>> Can you be specific as to which operation system and SQL version is
>> currently installed?
>> Have you added the /3GB switch to boot.ini?
>>
>> On Jan 20, 9:27 pm, thejamie <theja...@.discussions.microsoft.com>
>> wrote:
>> > After installing the 5 GIG on the Advanced Server, only two gig is
>> > available.
>> > If an upgrade is made to SQL Server 2005 STD for this machine, are
>> > there
>> > pitfalls to be aware of? Alternatively, Advanced Server is dual
>> > processor,
>> > is there a strategy available to set each processor to use 2 gig?
>> > --
>> > Regards,
>> > Jamie
>>|||thejamie wrote:
> After installing the 5 GIG on the Advanced Server, only two gig is
> available.
SQL server 2000 standard only supports 2 Gb
http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx
- Peter
--
Hi! I'm a .signature *virus*!
Copy me into your ~/.signature to help me spread!|||Hari,
The limitation on STANDARD Edition 2000 still exists or did that go away
with SP4?
--
Regards,
Jamie
"Hari Prasad" wrote:
> There is no limitations in SQL Server 2005 Standard editions. Limitation is
> all based on the type of operating system
> Take a look into below URL.
> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
> http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad125641/RequirementsSQL2005.htm
> Thanks
> Hari
>
> "thejamie" <thejamie@.discussions.microsoft.com> wrote in message
> news:82B017BD-E9BE-4E06-89BA-B404ACD42F30@.microsoft.com...
> > Advanced Server 2000 (with 5 GIG RAM) running Standard Edition 2000 SQL
> > Server
> > --
> > Regards,
> > Jamie
> >
> >
> > "Shoval" wrote:
> >
> >> Hi Jamie,
> >> Can you be specific as to which operation system and SQL version is
> >> currently installed?
> >> Have you added the /3GB switch to boot.ini?
> >>
> >>
> >>
> >> On Jan 20, 9:27 pm, thejamie <theja...@.discussions.microsoft.com>
> >> wrote:
> >> > After installing the 5 GIG on the Advanced Server, only two gig is
> >> > available.
> >> > If an upgrade is made to SQL Server 2005 STD for this machine, are
> >> > there
> >> > pitfalls to be aware of? Alternatively, Advanced Server is dual
> >> > processor,
> >> > is there a strategy available to set each processor to use 2 gig?
> >> > --
> >> > Regards,
> >> > Jamie
> >>
> >>
>
>|||Peter Lykkegaard wrote:
> SQL server 2000 standard only supports 2 Gb
Ahh I think I might have misunderstood you question slightly :)
You want to upgrade to SQL Server Enterprise?
- Peter
--
Hi! I'm a .signature *virus*!
Copy me into your ~/.signature to help me spread!|||You need either:
* a 64-bit OS and a 64-bit version of SQL Server
* AWE (Address Windowing Extensions) enabled on SQL Server and PAE
(Physical Address Extensions) enabled in your operating system.
When you go to "My Computer", under "Properties" how much RAM do you
see? In the "General" tab, do you see "Physical Address Extensions"
enabled anywhere?
-Dave
--
-Dave Markle
http://www.markleconsulting.com/blog
thejamie wrote:
> After installing the 5 GIG on the Advanced Server, only two gig is available.
> If an upgrade is made to SQL Server 2005 STD for this machine, are there
> pitfalls to be aware of? Alternatively, Advanced Server is dual processor,
> is there a strategy available to set each processor to use 2 gig?|||Things are often difficult to explain. To make this more interesting, when
SQL came back online, the SQL properties indicate SQL is now using 4 gig of
ram rather than 2 gig as before. This may not be a true reading. The
machine is a Dell from 2000 with a dual processor - dual processor shows up
as four processors - standard now for a duo core processor but the technology
is older. Definitely using a Standard Edition of SQL - not an Enterprise
version. Is it possible that with extra processors, the standard edition
will assign up to two gig per processor? I spent many nights worrying and it
doesn't appear to be a problem at the moment. More can be said when we bring
in production Monday morning.
--
Regards,
Jamie
"Peter Lykkegaard" wrote:
> Peter Lykkegaard wrote:
> >
> > SQL server 2000 standard only supports 2 Gb
> Ahh I think I might have misunderstood you question slightly :)
> You want to upgrade to SQL Server Enterprise?
> - Peter
> --
> Hi! I'm a .signature *virus*!
> Copy me into your ~/.signature to help me spread!
>
>|||I see four gig now vs two gig before. Physical Address Extensions cannot be
seen. We do not have the /PAE listed in the boot.ini.
--
Regards,
Jamie
"Dave Markle" <"dma[remove_ZZ]ZZrkle" wrote:
> You need either:
> * a 64-bit OS and a 64-bit version of SQL Server
> * AWE (Address Windowing Extensions) enabled on SQL Server and PAE
> (Physical Address Extensions) enabled in your operating system.
> When you go to "My Computer", under "Properties" how much RAM do you
> see? In the "General" tab, do you see "Physical Address Extensions"
> enabled anywhere?
> -Dave
> --
> -Dave Markle
> http://www.markleconsulting.com/blog
>
> thejamie wrote:
> > After installing the 5 GIG on the Advanced Server, only two gig is available.
> > If an upgrade is made to SQL Server 2005 STD for this machine, are there
> > pitfalls to be aware of? Alternatively, Advanced Server is dual processor,
> > is there a strategy available to set each processor to use 2 gig?
>
>