Memory Question

[hosenfeffer]

We have a 4 processor SQL server with 1.5 GB of ram running on win 2000 that hosts a Geographical Information System database. When the memory load gets quite high, say 840 megs of memory due to usage, it never drops. If the users have gone, the memory being used stays quite high. The only way to drop it down again is to do a restart. Is there a way to do a memory flush on a scheduled basis?

 

[InfrArch]

Definitely , the problem is because of MS bug.
Did you applied the latest SP's for SQL and SP3 for w2k?
If not, definitely do so, I think, then your problem will be solved.


Victor K
psas@canada.com
MCSE+I;MCSA;MCSE(w2k);CNE(5.1);MCNE(6);CIWSP;CIWSA.