Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Location
    Far away from heaven
    Posts
    194

    Unanswered: General Recommendation

    Hi, folks. I've a production SQL machine with more than 20 users making transactions 24 hrs in 6 days a week. I've only Sunday for maintenance. The server has fixed 2 GB RAM allocation for SQL. Is it good to Restart SQL ( or machine) to clear the Buffer-Cache( or is it good to keep the cache) ....


    Howdy!

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Keep the cache.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The machine needs to be rebooted occaisionally for other reasons, so I wouldn't worry about that. If you start to see free memory problems in your Perfmon traces I'd schedule a reboot, but I'd only expect that after a year or so without a reboot unless you have significant use of the machine from the keyboard (applications can do funny things to services over time).

    This is a case of do as I say, not as I do for other reasons. Our infrastructure team makes significant (often daily) use of our servers from the keyboad because that's how things were always done with NetWare, so we've chosen to reboot our servers weekly. We've got other SQL servers outside the datacenter that haven't been rebooted for 16 months, but aren't showing any signs of distress!

    -PatP

  4. #4
    Join Date
    Jun 2004
    Location
    Far away from heaven
    Posts
    194
    Thanx so much for the advice, blindman & Pat.
    I scarcely use the SQL machine directly, rather connect through EM or QA over the network.
    However i've OUTLOOK2000 window opened on the server machine locally all the time for e-mails.

    Some times the processor usage counter constantly stays above 60%, i use to close the OUTLOOK and reopen it; gets normal.


    Thanx!

Posting Permissions

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