Standard Edition w/ x64 bit - SQL Server Forums

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 2005 Forums

SQL Server Administration (2005)

Standard Edition w/ x64 bit

Author

Topic

john.burns
Posting Yak Master

100 Posts

Posted - 2007-11-15 : 12:29:10

All,
I'm new to x64 bit architecture.

Server OS is 2003 R2 EE x64
Sql is 2005 Std sp2 with hotfix
4 way processors
4 GB of RAM

I reading that all x32 configurations do not apply... pae , awe
enabled etc....

after sp_configure ..sql is set to 2gb max memory setting.
Does this not have to be increased for sql to see more
memory .. I've confirmed that OS can see the 4GB but
don't think SQL can.

Does 'AWE enabled' still haveto be set up (or anything else)with this setup to optimize memory.

thanks much
John

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-11-15 : 15:47:18

If you want SQL to use more than 2 GB you still need to set max memory higher. AWE enabled is not necessary.

Future guru in the making.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-15 : 22:52:21

If it's dedicated sql server, let sql manage memory dynamically.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources