SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Using AWE option in SQL !!!
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

admin001
Posting Yak Master

Germany
166 Posts

Posted - 08/19/2004 :  22:03:18  Show Profile  Reply with Quote
Hi ,

We just executed some performance tests on one of our SQL 2000 servers Enterprise Edition ) and the team has recommended to use the AWE option of Windows 2000 server because as per their reports they feel that SQL is not utilising the entire 4 GB which is the physical RAM on that server .

Is that correct ? Because I think SQL manages memory dynamically and will all the available memory by default unless you set the max memory option to restrict .

Also the AWE option , as per all the related articles on the net , should be enabled only if the server has more that 4 GB of RAM . But in my case what if the server just has 4 Gigs ? Will the AWE and the PAE options work ? I just reviewed the MS article 274750 but was not clear .

We have Windows 2000 Advanced server and the the max memory setting is set to use the maximum .

Thanks

derrickleggett
Pointy Haired Yak DBA

USA
4184 Posts

Posted - 08/19/2004 :  22:21:22  Show Profile  Visit derrickleggett's Homepage  Send derrickleggett an AOL message  Send derrickleggett a Yahoo! Message  Reply with Quote
It won't improve anything because there's nothing for it to improve with. If you only have 4gb AND it's a dedicated SQL Server, you should probably add the /3gb switch to the boot.ini. This allows SQL Server to use 3gb instead of 2. The OS then has 1 to use. Don't do this if it's not a dedicated SQL Server though. Leave the SQL Server memory settings at the default. There's no reason to change it unless you have more than 4gb of RAM, unless you're running other apps on the server.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

admin001
Posting Yak Master

Germany
166 Posts

Posted - 08/19/2004 :  22:28:15  Show Profile  Reply with Quote
Got it !! Thanks a lot .

But does that mean that when SQL server memory is set to max then it will not use the entire RAM when it needs . I thought it would use the entire 4 GB when it is required and then later release it and that /3 GB switch would not help in any way .

The box is a dedicated SQL box.
Go to Top of Page

MichaelP
Jedi Yak

USA
2489 Posts

Posted - 08/20/2004 :  00:42:00  Show Profile  Visit MichaelP's Homepage  Reply with Quote
By default, no app can use more than 2GB of memory. If you add the /3GB switch, the OS will get 1 GB, and SQL server will get 3GB.

If you have more than 4GB of RAM, then you should explore AWE. You take a performance hit by using AWE, so you only want to use it when you have more than 4GB of RAM.

Haben Sie eines guten Tag!

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page

admin001
Posting Yak Master

Germany
166 Posts

Posted - 08/20/2004 :  02:37:47  Show Profile  Reply with Quote
Noted .

Danke Michael and Derrick für Ihre Antwort.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000