SQL server 2000 on SBS2003 out of memory error

[yoda]

Basically, I got passed this one from a m8 and I've done everything I can think of..

The server is a quad core dell power edge 2900 with 8 SAS drives in one RAID 5 array with 4GB of ram.

I've let SQL handle it's own memory, I've set it to use 2gb and I'm still getting out of memory errors...

The database total size is about 14GB so not that big, but their is a couple of tables that are 10,000 records or over.

Does anyone have any ideas?

Thanks

 

[yoda]

The server is brand new....

PAE is allready enabled...
AWE should not be enabled for 4GB of ram

 

[yoda]

Already done a full memory test when we first got it 3 weeks ago...

I've found some of the more, 'funky' memory settings and I've alterd them... so....

minimum queery memory changed from 1MB to 1KB
Maximum number of threads changed from 256 to 32K

See if this helps....