Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a weird problem. I enabled AWE on a Sql 2000 sitting on a Windows 2003 server. The server has 20 gigs of memory but when i enable AWE sql process is showing as having only 128 MB. From perfmon however looks like a bit part of memory is being allocated to a process (i think it's SQL).

However SQL runs slower with AWE then without it. Has anyone got any ideea ?

share|improve this question
add comment

2 Answers

up vote 3 down vote accepted

sql process is showing as having only 128 MB

You have checked it with Task Manager? It's Task Manager limitation (bug) and you shouldn't belive in such numbers.

Performance monitor will show you correct data (use SQL Server:Memory Manager counters)

share|improve this answer
    
From support.microsoft.com/kb/907877: 'Performance Monitor (PerfMon) and Task Manager do not account for memory correctly if Address Windowing Extentions (AWE) support is enabled' –  Remus Rusanu Oct 2 '09 at 18:25
add comment

For fear of losing performance with AWE/PAE and hyperthreading, I did extensive (for me) tests using SQL. I quickly got into the weeds with varying query types, but I did gather some evidence that AWE/PAE may be worse for queries using large amounts of I/O. Other queries that benefit from >2GB memory for caching were better. What does one do? If your box is running a variety of queries, you can't restart with a new config in between! We went with it, and then x64 came along and laid the matter to rest.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.