Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bigbelly
Starting Member
39 Posts |
 Posted - 2007-07-31 : 00:26:46
|
| We just upgraded the memory of our database server from 2GB to 4GB. And its OS is windows 2003 standard and sql is 2005 standard edition. According to microsoft(http://msdn2.microsoft.com/en-us/library/ms143685.aspx and http://msdn2.microsoft.com/en-us/library/aa366778.aspx#physical_memory_limits_windows_server_2003), this configuration should allow database use up to 4 GB memory. My question is : Do I need to do anything(such as: adjust the maximum memory in management studio) to let our server be able to consume this extra 2 GB memory? Does this solution http://support.microsoft.com/kb/274750 apply for SQL server 2005? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-07-31 : 00:59:20
|
| use the /3GB switch in the boot.ini and the SQL Server will be able to address 3GB of your 4GB.-ec |
 |
|
|
|
|
|
4 GB memory for SQL 2005 std + windows 2003 std