2000 advanced server sp4 memory max with sql 2000 enterprise

S

SPiderman

I have been reading conflicting info on the max memory for 2000 adv server
memory. I know MS mentions that it is 8gb, but then I have found some sql
articles that reference it can go up to 16gb.

Is there a way to get this to work or am I stuck with upgrading to 2003 or
2000 datacenter? The applicaiton won't work on 2003.....
 
J

John John

The SQL version that you are using may be able to use 16GB (or more) of
RAM but it will only be able to use it if the hosting server version
also supports that much RAM. Windows 2000 Advanced Server supports a
maximum of 8GB of RAM, you will not be able to have SQL use more than
that with that server version, you will have to use another server
version to use more than 8GB of RAM.

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 2000 Server does not display maximum memory correctly? 5
Max Memory for 2K Advanced 1
SQL Max Memory Defined 1
memory error while installing W2000 Advanced Server 2
How to tell Version installed??? Advanced/server/smallbusiness/enterprise? 4
upgrade paths for W2K Standard server to W2K Advanced Server 2
WSUS with sql server 5
LogonUser works only after installing SQL Server 2000 6

Top