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-12-07 : 11:26:55
|
| I have a 32 bit instance of SQL Server 2008 Standard that was installed on a 64 bit machine (silly yes, but done before my time). This instance is currently RTM with no AWE config set so I need to install SP2. Once installed I am unsure as to how I should treat AWE/Locked Pages in Memory because of the 32bit/64bit installation.It is my guess that because SQL Server is 32 bit then AWE and Lock Pages in Memory will need enabling as there is 8gb RAM on the machine of which SQL Server should be using 6gb. Is this correct in this scenario?On a 64 bit SQL instance I would set only the Locked Pages option as AWE is not required, I am guessing this will change on a 32 bit SQL instance even though the server is 64 bit. |
|
|
sqllogi
Starting Member
4 Posts |
Posted - 2010-12-31 : 16:06:12
|
| If it is a 32bit sql install, check AWE and lock pages in memory. You are right on 64bit, just enable locked pages in memory. |
 |
|
|
|
|
|
AWE considerations for SQL Server 2008 32bit on 64