December 3, 2002 at 11:01 am
Hi Evryone,
My SQL2K currently have 1 GB of RAM. I will add another 1 GB. I think I should do something with sp_configure to tell SQL about the new 1 GB but I'm not sure what it is. Can you guys share it?
Thx.
December 3, 2002 at 11:54 am
If the memory is set to dynamic, you should't have to to do anything for up to 2GB. If you've set a maximum on your memory within SQL Server, you'll need to change that. The easiest way for most people is through Enterprise Manager by bringing up the server properties and adjusting the memory settings that way.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
December 3, 2002 at 11:58 am
Hi Brian,
I set SQL memory usage to dynamic. I thought I need to do something with AWE and sp_configure.
Thx.
December 3, 2002 at 12:13 pm
Up to 2GB you don't need to do anything. Once you pass 2GB, then you have things to configure. NT and 2000 will allocate up to 2GB of RAM to an application without any special settings.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
December 5, 2002 at 8:19 pm
You might be thinking of the considerations for when you have >2Gb of memory on your machine. Check out BOL topics "Managing AWE Memory" and "Server Memory Options" for details. You might need to configure NT to allow more APP VM by editing Boot.ini file.
December 10, 2002 at 8:54 am
Since we are talking about memory, keep in mind that > 2GB requires either Enterprise or Developer editions of SQL Server.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply