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 |
|
patshaw
Posting Yak Master
177 Posts |
 Posted - 2010-01-18 : 16:27:51
|
| I have a server that operates as a Web and SQL server. The OS is Windows 2008 Standard and SQL Server is 2008 Web Edition. The machine has 4gb RAM. Would enabling AWE and 'Lock Pages in Memory' be a good or bad thing on a machine with exactly 4gb RAM or should this only be done if RAM is greater than 4gb?Also, when enabling AWE should the 3GB switch be used as I always seem to see conflicting information on this subject.Thanks. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
patshaw
Posting Yak Master
177 Posts |
Posted - 2010-01-18 : 17:08:23
|
| Apologies, yes it is 32 bit. I have set max server memory, 2.5gb max reserved for SQL Server. Would you say that is a fair split? |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-18 : 17:10:17
|
| yep. that's probably about where i'd set it. OS needs some RAM and IIS needs some, so 2.5 seems about right.it is almost always a bad idea to have web server and sql server on same machine, so keep an eye on things, especially as activity/usage increases |
|
|
|
patshaw
Posting Yak Master
177 Posts |
Posted - 2010-01-19 : 01:04:55
|
| I will. I don't have any say where that's concerned as this belongs to a friend and he's constrained by budget. I'm just helping out with set up.Thanks for your advice here. |
|
|
|
|
|
|
Should AWE be enabled