Memory limitation SQL 2000 Standard

Hi folks,
I have a question regarding the memory limitation of SQL 2000 Standard.
We´re planning a new server with 4 GB of physical memory.
One of the limitation auf SQL 2000 Standard Edition is 2 GB of memory.
Is this limitation based on the physical memory of the machine or will SQL
only use 2 GB of memory.
2 GB of memory would be enough for our SQL Server, leaving the remaining
memory to the other applications.
Or does the SQL 2000 Standard fail, if it has 4 GB of physical memory
thanks in advance
Wolfgang HandlHi
SQL will not fail, but be aware of the following:
The memory area below 2Gb will be shared by SQL AND the other applications,
whilst the OS will use the memory abouve 2GB. Unless an application is
written to make use of the memory area above 2Gb, it won't.
In effect, the other 2 Gb are a waste unless you use Enterprise Edition.
Regards
Mike
"news.microsoft.com" wrote:
> Hi folks,
> I have a question regarding the memory limitation of SQL 2000 Standard.
> We´re planning a new server with 4 GB of physical memory.
> One of the limitation auf SQL 2000 Standard Edition is 2 GB of memory.
> Is this limitation based on the physical memory of the machine or will SQL
> only use 2 GB of memory.
> 2 GB of memory would be enough for our SQL Server, leaving the remaining
> memory to the other applications.
> Or does the SQL 2000 Standard fail, if it has 4 GB of physical memory
> thanks in advance
> Wolfgang Handl
>
>|||What happens if the /3GB switch is enabled?
~Mateo
>--Original Message--
>Hi
>SQL will not fail, but be aware of the following:
>The memory area below 2Gb will be shared by SQL AND the other applications, >whilst the OS will use the memory abouve 2GB. Unless an application is >written to make use of the memory area above 2Gb, it won't.
>In effect, the other 2 Gb are a waste unless you use Enterprise Edition.
>Regards
>Mike
>"news.microsoft.com" wrote:
>> Hi folks,
>> >> I have a question regarding the memory limitation of SQL 2000 Standard.
>> >> We=C2=B4re planning a new server with 4 GB of physical memory.
>> One of the limitation auf SQL 2000 Standard Edition is 2 GB of memory.
>> >> Is this limitation based on the physical memory of the machine or will SQL >> only use 2 GB of memory.
>> >> 2 GB of memory would be enough for our SQL Server, leaving the remaining >> memory to the other applications.
>> Or does the SQL 2000 Standard fail, if it has 4 GB of physical memory
>> >> thanks in advance
>> >> Wolfgang Handl >> >> >> >.
>