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 |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2005-09-26 : 17:01:51
|
| We have one server with SQL Server 2000 Standard Edition running on Windows Server 2003 Standard Edition. The server is reporting 3.6GB of memory installed. I know SQL 2000 SE can use a maximum of 2GB. If I set the max memory to 2 GB for SQL Server will the OS utilize the remaining 1.6GB of memory or do I need to set the PAE switch? I've been researching PAE/AWE, but most information I found deals with 2003 Enterprise Edition or Datacenter Edition.Thanks, Dave |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-09-26 : 17:29:20
|
| AWE and PAE are only options for the enterprise editions of SQL Server and win2k3 (or advanced or datacenter edition of win2k).You are limited to 2GB memory per SQL instance with the software you are currently running. There is no way around this, you have to upgrade to the enterprise editions if you want address more memory. -ec |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-09-26 : 18:03:19
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210/3GB switch ? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-09-26 : 18:31:17
|
quote:
Originally posted by rockmoose
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210/3GB switch ?
turns out that SQL standard edition will still only address 2GB RAM with the /3GB switch active. To get to more memory, you need the Enterprise edition.-ec |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-09-26 : 18:48:14
|
| Yes,but I was thinking You could let sql use 2GB and free more of the rest to the OS... |
|
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2005-09-26 : 23:42:35
|
| Thanks all. I was asking more about the OS then SQL Server. I understand SQL Server Standard Edition maxes-out at 2GB, but I wasn't sure if the OS would use the remaining memory without any switch being set. From rockmoose'sssss link it sounds as if Windows 2003 Standard will use up to 2GB without a switch being set. If that's correct I have all the info I need.Thanks, Dave |
|
|
|
|
|
|
Windows Server 2003 SE and Memory