Re: /3GB switch in 64-bit environment

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Oops, I was interpreting his tables wrong. Thanks for pointing that out.

"Arnie Rowland" wrote:


From:
http://www.sql-server-performance.com/jc_system_storage_configuration.asp

The table below shows SQL Server 2000 processor and memory support by
edition. The SQL Server 2000 64-bit version is for Itanium only.


SQL Server 2000 Processor and Memory support by Edition Standard
Ed. 32-bit / 64-bit
Enterprise Ed. 32-bit / 64-bit

Max Processor (Sockets)
4
No Limit

Max Memory
2GB
64GB / 512GB



--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Travis" <Travis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0C788E6E-8282-4A9A-8627-5E81DAF97DE6@xxxxxxxxxxxxxxxx
Not according to 64-bit windows. You should be able to use the /3GB
switch
in a 64-bit environment. SQL 2000 standard can use it and SQL 2005
standard
can use up to the Operating System's Max memory. Here is the link I got
my
info from:
http://www.sql-server-performance.com/jc_system_storage_configuration.asp

"Tom" wrote:

SQL2000 Standard si limited to 2GB. You need to upgrade to SQL 2000
Enterprise or SQL2005 Standard to use above 2GB of RAM .


Tom.


"Travis" <Travis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5C22333E-60F0-481D-9632-69B4CA16B059@xxxxxxxxxxxxxxxx
I already moved the max memory setting to 3072.

"Arnie Rowland" wrote:

You have to also change the max memory setting in SQL Server
properties.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Travis" <Travis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B6EB6A58-99DD-47F9-95A3-61777697C52F@xxxxxxxxxxxxxxxx
I recently put in the /3GB switch on our Windows 2003 Server R2
boot.ini
file. We are running SQL 2000 Standard. After the reboot our
physical
memory is not going over 2GB. Is there something else I missed?
Thanks.










.

Relevant Pages

  • Re: Windows 2003 SP1 standard + SQL 2005 standard
    ... Enterprise Edition includes clustering, large memory ... Most good judgment comes from experience. ... WRT the cpus unfortunately woodcrest doesn't support HT yet .. ... you will want SQL Server to startup with the /3GB ...
    (microsoft.public.sqlserver.setup)
  • Re: /3GB switch in 64-bit environment
    ... SQL Server 2005, Standard Edition allows 4 GB memory -if that's of any help. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.setup)
  • Re: Bug in Enterprise Manager (SQL 2000)
    ... There is an small possibility that this may be related to memory issues. ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... I have just tried the identical query on another workstation and there ...
    (microsoft.public.sqlserver.tools)
  • Re: Can I set multiple filters?
    ... Post your suggestions for SQL Server here: ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... The best way to query the database is to know how to query the database ...
    (microsoft.public.sqlserver.clients)
  • Re: Tools For Scanning Data?
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... >> Corey, ... If we are transferring a database from the old SQL Server to a new, ...
    (microsoft.public.sqlserver.security)