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 |
|
john.burns
Posting Yak Master
100 Posts |
 Posted - 2007-01-16 : 15:09:05
|
| Is AWE memory possible with SQL 2000 standard edition. Most doco says no but when using it with win2003 server Enterprise edition I cannot find an answer.Specifics are:current environment-->win2k server sp44 gb ram4 cpusql 2000 SE SP3future environment -->win2003 server EE SP18 GB RAM8 CPUsql 2000 SE SP3 Thank you |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-01-16 : 17:19:46
|
| SQL 2000 standard edition is limited to 2GB. There is no way to use any more than that.-ec |
 |
|
|
john.burns
Posting Yak Master
100 Posts |
Posted - 2007-01-17 : 09:06:30
|
| so I guess using the /3gb switch has not effect?thanks |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-01-17 : 11:17:30
|
quote:
Originally posted by john.burns
so I guess using the /3gb switch has not effect?thanks
right. the /3GB does nothing for standard edition. -ec |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2007-01-25 : 12:29:34
|
| The 3GB switch does allow sql std to use more. The only thing to be aware of it allows ALL processes to use 3gb. |
|
|
|
john.burns
Posting Yak Master
100 Posts |
Posted - 2007-01-25 : 13:18:00
|
| interesting, thanks |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-01-25 : 14:32:12
|
quote:
Originally posted by scottpt
The 3GB switch does allow sql std to use more. The only thing to be aware of it allows ALL processes to use 3gb.
You are incorrect about this. SQL Standard will still only use 2GB.-ec |
|
|
|
jayp369
Starting Member
26 Posts |
Posted - 2007-01-25 : 14:38:12
|
| EC is right SQL Standard will only use 2Gb, but SQL Enterprise can use more.Jay |
|
|
|
|
|
|
AWE Question with Standard Edtion