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 |
|
travisl
Starting Member
12 Posts |
 Posted - 2004-01-14 : 09:55:36
|
| My production server is SQL Server 2000 on a Windows 2000 Server machine with 4gigs of RAM. The load on the server is going to increase a lot soon, and one of the things I'm looking into is the "4-Gig Tuning" "fix" for Windows.As I understand it, even though my machine has 4gig of RAM, SQL Server can only use 2gig of it, because Windows is using 2gig. Apparently, you can edit the boot.ini file in such a way as to tell Windows to only use 1gig, which would leave 3gig free for applications such as SQL Server.Have any of you had experience with this? Is it really as simple as editing my boot.ini file and rebooting? Are there any pitfalls to watch out for? Do I need either Windows or SQLServer Super Duper Edition to do this? Once it's done, do I need to do something in SQL Server?Any advice would be greatly appreciated.Travis |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-01-14 : 10:29:16
|
| Have you read BOL for all AWE articles as a starting point?Raymond |
 |
|
|
travisl
Starting Member
12 Posts |
Posted - 2004-01-14 : 10:34:39
|
| No, because I was under the impression that AWE was only on Advanced Server and Datacenter Server. The bits that I've read seem to indicate that the "4GT" switch can be done on standard Windows 2000 Server.But I'll go take a look anyway, since you mentioned them. Thanks!Travis |
|
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-01-14 : 10:37:44
|
| Can't say on the OS end, but for SQL Server"Note This feature is available only in the SQL Server 2000 Enterprise and Developer editions."from the Managing AWE Memory topic.Raymond |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2004-01-14 : 10:41:00
|
Yes you need "SQLServer Super Duper Edition" to do this  You also need Windows 2000 Advanced Server or higher, For more info have a look at [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;274750[/url] |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
travisl
Starting Member
12 Posts |
Posted - 2004-01-14 : 11:57:53
|
| Thanks guys!Travis |
|
|
|
|
|
|
|
|
4GT