May 6, 2003 at 10:36 am
I have a database server with 2G of memory. In sp_configure the max server memory (MB) maximum, config_value and run_value are set to 2147483647. However, when I look at the properties memory in SQLServer it only shows 1024MB as the maximum, and when I check the server in taskmgr it only is using 1064500 at most.
How do I increase the amount of memory that SQL Server will use?
May 8, 2003 at 3:25 pm
if it is a enterprise edition on OS enterprise version you can define the max in the boot.ini file
May 9, 2003 at 3:59 am
I believe you are thinking of rthe /3GB siwtch vambati which should not be needed here.
Pomalis, oes the OS see the 2GBs and has the machien been pushed to see if it would use anything above 1GB successfully (there are tools for this). EVen if it can see the 2GB if they are seperate sticks and not matched right then one may not be getting used by the OS properly.
May 9, 2003 at 2:53 pm
Thanks, I'll check into that. It may very well be the case.
May 15, 2003 at 5:11 pm
Count your blessings that it is not using all of the available memory. SQL Server will start at the min server memory when it starts up. As it performs more work (services new connections, reads index and data pages, creates/drops locks, etc.), it will acquire more memory from the OS up until it reaches the max server memory amount. If it does reach the max server memory limit, it will determine what items it can unload from memory (similar to Least Recently Used) to accommodate the new memory requirements.
That being said, if you have not yet reached the total memory available to SQL Server then you have enough memory in the machine. In my experience, having sufficient memory for SQL Server is the single biggest performance gain you achieve.
David R Buckingham, MCDBA,MCSA,MCP
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply