Ok, so I have this server which currently has 2200 databases on it. At any given time, only around 100 of them are being used. They are small, most in the 2 - 3 Meg range. My problem is, the server will run for about a week, then it uses up all 3 gigs of ram and has to page to do any operations. Is there some way to force SQL to free the memory up without restarting the service? I dont want to have to reboot this server every week. Would running something like DBCC FREEPROCCACHE help?
TIA...try doing a scheduled checkpoint for flushing memory to disk?|||Any pointers on how to do that?
Anyone else have any ideas?|||create an agent job with one step per database, each one issuing
the t-sql command "checkpoint"...schedule to run fairly frequently.
(set job steps to fire in each database respectively)
maybe looking in syscacheobjects will shed some light on what is using the most memory before & after checkpoints?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment