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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply