contiguous memory issue

Question

contiguous memory issue

ron.casaul

SSC Journeyman

Points: 76
More actions
July 3, 2009 at 9:24 am

#207859

we are running sql 2000 sp3 under a win2000 Sp2 OS. we recently upgraded the server ram from 4 gb to 8gb. afterwards, we started to get the error 'not enough contiguous memory'. we did not have this issue when we were just using 4gb but after the upgrade to a bigger memory we started to get one. before rolling back the upgrade as a last resort, we would like to know if there are settings that we could change/modified to get around this problem. we are constraint by the application we are running to stay in current version of the OS as well as the SQL.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

David O Hall of Fame Points: 3228 More actions · Answer 1

Upgrade to at least service pack 4. The sp 4 fix list has 5 or 6 fixes for memory leaks. I dealt with this battle why back when and this message points to a memory leak or memory pressure in memtoleave. You can also look at bumping up your memtoleave allocation to 386 MG. If you google you'll find lots of references on how do to that.

I'd suggest upgrade all the way to 8.00.2187 if you can.

David O Hall of Fame Points: 3228 More actions · Answer 2

Upgrade to at least service pack 4. The sp 4 fix list has 5 or 6 fixes for memory leaks. I dealt with this battle why back when and this message points to a memory leak or memory pressure in memtoleave. You can also look at bumping up your memtoleave allocation to 386 MG. If you google you'll find lots of references on how do to that.

I'd suggest upgrade all the way to 8.00.2187 if you can.

Carl Federl One Orange Chip Points: 25384 More actions · Answer 3

After installing SQL Server 2000 SP4, there is also a hot fix needed in order to get AWE to function correctly: http://support.microsoft.com/kb/899761

SQL = Scarcely Qualifies as a Language

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 4

Are you running 2000 Standard ot 2000 Enterprise ? If you are running SQL 2000 Standard then adding more memory to the server will not help since SQL 2000 Standard is 'limited' on the amount of memory it can address and use - 2 Gb !

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

ron.casaul SSC Journeyman Points: 76 More actions · Answer 5

we are running sql2000 enterprise...we could not go to sp4 bec of the app running against it...our concern is that when we were using just 4 GB RAM we did not have this problem...however after expanding the RAM to 8, we started to have this issue...it seems something was not set right during the upgrade...