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 |
|
aliyesami
Starting Member
30 Posts |
 Posted - 2008-10-11 : 11:50:40
|
| I need to know why the properties menu of sqlserver 2000 under windows 2003 is showing max memory as 4 MB where as the physical memory in the box is 32 GB but when I use sp_configure it shows max memory as 2147483647 mb? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-13 : 04:01:13
|
Have you set the /3gb or any other setting in boot.ini to enable sql server to use memory above 4 gb?Also1) This is a SQL Server 2005 forum2) You have posted SQL Server 2000 problem
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-10-16 : 04:07:53
|
| 2147483647 is default setting for SQL Server memory. On 32 bit system, SQL by default can use max of 2GB RAM (3 GB with /3GB enabled). You can increase this by setting AWE and then SQL can use as much available to the system/ upto max serve emory if set.On 64 bit system, SQL 2000 by default can use max of 4GB. With AWE ofcourse, you can use more. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-16 : 09:15:37
|
quote:
Originally posted by SimpleSQL
2147483647 is default setting for SQL Server memory. On 32 bit system, SQL by default can use max of 2GB RAM (3 GB with /3GB enabled). You can increase this by setting AWE and then SQL can use as much available to the system/ upto max serve emory if set.On 64 bit system, SQL 2000 by default can use max of 4GB. With AWE ofcourse, you can use more.
There is no use of AWE in 64-bit Server. |
|
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-10-16 : 22:15:09
|
| For SQL 2000 (32 bit, as no x64 is avlbl for SQL 2000), you are still constrained by 4 GB VAS (Virtual Address Space) even on a 64 bit operating system. So Should SQL need to use more than 4GB memory, it will have to use AWE.On SQL 2005 64 bit, it is a different story, here, there is no use of AWE. |
|
|
|
|
|
|
|
|
urgent help needed