SQL 2000 server only using half a gig

[yoda]

I got an SQL server, it's database is 14.5GB and the server refuses to use more than 512MB for SQL service dispite having 2GB of free ram...

I try to alter the min and max ram settings from the SQL manager but it says in the log 'can not allocate 1024MB'

I've got "/PAE /3GB" in the boot.ini and the server is running 4GB ram...

Anyone know why it not letting me?

thanks

 

[yoda]

hmmm.... been reading....
I'm wondering if SQL server 2000 is using kernel space not user space....
if I enable /3GB option... user space is the 3gb and kernel space is 1gb as apposed to 2GB / 2GB

I'm going to have a play this weekend....

Any more ideas?

thanks

 

[yoda]

ok, I've removed the /3GB option from boot.ini and rebooted
SQL server is now using 1,061,496K so, thats about 1GB...
The server will get used today, I'll see if I can hammer it to see if it will use more...

Might see if we can put more ram in server...

anyone got any thaughts ect?

Thanks

:edit
The server is still reporting 2GB of ram left?????????

 

[yoda]

well, our DB is 15GB, sql server is now using 1068468K and seems to be running a darn sight faster....

Madman045, what settings you got?

 

[yoda]

 

[yoda]

they are on...
SBS 2003 SP2

I'm not sure what SP the SQL2000 is on... how do I find out?

 

[yoda]

I just phoned them... I gave them a quote for under £200 to double their servers memory from 4GB to 8GB... they said yes and they didn't even argue... I think they learned not to say no otherwise they get ear-ach... lol

 

[yoda]

oh, joy...

oh well... looks like we'll have some un-used ram then...
i've been told it's SBS2003 prem and SQL 2000 prem....
not sure what the diference is... lol