AWE SQL 2005 Standard Clustering

Question

Post reply

AWE SQL 2005 Standard Clustering

rpiamont

SSC Veteran

Points: 238
More actions
July 2, 2009 at 6:34 pm

#132467

Hello. I am new here and trying to a be a fledgling DBA. We have a Active/Passive Cluster and I am trying to enable AWE on the Active node. We have 8GB of RAM and I am setting the Max limit as 6144. The problem is it only seems to go as the configured value and never the running value. We have done the /3GB and /PAE switches as well as granting 'Lock Pages in Memory' for the SQL account and Admin group. We rebooted twice already but its not taking it. Here's the main problem I think, the active node has 8 GB of RAM while the Passive Node only has 2 GB RAM. I didn't design it this way, it was just handed to me. Can I enable AWE on a cluster where the nodes are of different configurations? Thank you.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

hi_abhay78 SSCertifiable Points: 6265 More actions · Answer 1

It should work :

Once you failover to the other server with 2 GB Ram this setting should be ignored .

Basically /PAE will give eyes to the OS to be able see more than 2 GB or RAM .its just the capability to see more .If it does not exist , doesn't matter.

On the basis of /PAE AWE will work if the RAM is not more than 2GB AWE will not be effective @ all.

Now try this : after changing the max server memory run 'reconfigure with override' and then restart the SQL Server services.

Open the Perfmon and check these 2 parameters .

SQL Server : Memory Manager

Target server Memory

Total Server Memory

Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)

rpiamont SSC Veteran Points: 238 More actions · Answer 2

Thanks. It looks like it worked. Now, it shows AWE Allocated114688KB in DBCC MEMORYSTATUS. That should grow to about 6GB. Is that correct? Why is it so low? That's only 114MB?

hi_abhay78 SSCertifiable Points: 6265 More actions · Answer 3

AWE allocated will show you at many places in 2005 in dbcc memorystatus .As I sad use perfmon for clarity .

Regards

Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)

joeroshan SSChampion Points: 10377 More actions · Answer 4

for configured

use master

select * from sysperfinfo where counter_name like '%target server memory%'

currently used

use master

select * from sysperfinfo where counter_name like '%total server memory%'

----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe

Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

forsqlserver SSCoach Points: 18902 More actions · Answer 5

DBCC Memorystatus...I am not able understand it comletely can anyone help....

Thanks

John.Sansom SSCertifiable Points: 7335 More actions · Answer 6

Hi Ajay,

Take a look at the following Microsoft Reference for an explanation of the results produced from DBCC MEMORYSTATUS.

Using DBCC MEMORYSTATUS to Monitor SQL Server Memory Usage

Hope this helps.

John Sansom (@sqlBrit) | www.johnsansom.com