Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Posts
    63

    Question Unanswered: Freeing up Server Memory...

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

  2. #2
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102
    try doing a scheduled checkpoint for flushing memory to disk?

  3. #3
    Join Date
    Dec 2002
    Posts
    63
    Any pointers on how to do that?

    Anyone else have any ideas?

  4. #4
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •