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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Should AWE be enabled

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

Posted - 2010-01-18 : 16:54:17
32 bit or 64 bit?

here is a nice short and to the point article. http://blogs.solidq.com/EN/rdyess/Lists/Posts/Post.aspx?List=46f36841%2D4c69%2D4240%2Db060%2De0712db6f3ba&ID=10

msdn has plenty of detailed info too.

i would say no in your case if it's 32x

also, make sure you have set the max server memory in MSSQL -- particularly since you're sharing this box with a web server
Go to Top of Page

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?
Go to Top of Page

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
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -