Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2005

    Memory reading..

    Well, I have a 1GB stick of memory on my SQL server. I check occassionally and it always has less than 16 MB of free memory. There's about 400 MB cached so I thought that 's okay, but when it occasionally started to get spikes of 16 second load times while the server load was below 5, I'm starting to worry.

    Do you think I should purchase an extra stick of memory?

  2. #2
    Join Date
    Jun 2003
    Ukiah, California
    You need to determine if the slow response is due to memory exhaustion or disk IO limitations. Can you paste the results of top/iostat/etc here?
    Jacob Turner -- Ringnebula Systems
    Managed IT solutions for small business

  3. #3
    Join Date
    Mar 2006
    New York USA
    perhaps your SQL server config needs to be optimized? There are some tutorials floating around here on WHT, or simply do a good search on it.

    Good Luck,


Posting Permissions

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