Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: Memory increasing for the SQLServer process

    Out techs informed me that they are getting reports of a system slow down. When they look, they find sqlserver.exe has lots of memory allocated to it. They reboot the server and then it runs okay for a few weeks. They tell me this just started happening recently.

    SQLServer itself has not been touched in months. They are, however, starting to use one of the databases heavier.

    I found a setting where you can set max_server_memory. Any problems if I set this to a value?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 17
    So long as it is set high enought, there are no problems. Keep in mind, SQLServer likes memory. It is around ten times faster to read data from memory as it is from disk. I would check the paging rates, rather than the physical memory usage, to see if there is an actual problem on the box.

Posting Permissions

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