October 8, 2001 at 8:42 pm
Our dedicated SQL 7 Server has 640MB of RAM. I noticed, using Task manager, that SQL claims 580MB for itself.
Does SQL really need all this memory? Some users are starting to report sluggish performance and I wonder if NT and our remote-control program, etc on this box are being starved for real (not virtual) memory.
TIA,
Bill
October 9, 2001 at 5:08 am
Whether it really needs it depends on how much data you're loading, you need a large cache for data and procedures. By default SQL grabs it all, then releases some back to the OS if needed. You can set a hard upper limit for memory if you're having problems.
Unless your data is only a hundred megs or so, you'll definitely see an improvement by adding memory - as much as the box will hold! Memory is cheap, its a good time to see if adding some will help (or even if you think it will help).
Andy
October 9, 2001 at 9:28 am
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy