SQL server 2000 on SBS2003 out of memory error

yoda · 28 Apr 2008 at 11:18

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

VeNT · 28 Apr 2008 at 12:27

try that boot.ini thing that lets windows x86 based systems use more than 3GB of ram?
failing that get a bigger server?

yoda · 28 Apr 2008 at 12:43

The server is brand new....

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

VeNT · 28 Apr 2008 at 13:12

hmm, guessing here but could it be duff ram?
any poss of backing up the data and re-installing the lot?

yoda · 28 Apr 2008 at 14:30

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....

VeNT · 28 Apr 2008 at 14:42

well either it will work or the server will implode, either way, pics tbh

madman045 · 28 Apr 2008 at 19:28

SQL 2000 is limited to 2GB ram by design, I have a client with the same situation and they are looking to move and upgrade to SQL 2005 X64