November 1, 2011 at 12:15 pm
Hello,
I have Windows 2003 R2 Enterprise Edition 32-bit and Windows SQL2005 Standard Edition 32-bit with 8 GB RAM on Server in VMWare. Which the OS see the 8 GB without having to add Switch to the boot.ini.
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="WindowsServer 2003, Enterprise"/noexecute=optout /fastdetect
My question is do I need to add /AWE to the boot.ini for me to use AWE in SQL Server 2005 and also do I need to Enable the Lock Page in Memory Option.
For me to run the following script.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Thank you
November 1, 2011 at 1:35 pm
Order of processing is important with AWE.
First set your max server memory and only then enable AWE !
In your case (8GB total allocated VM ram) You would need /3GB /PAE in your boot.ini
ref: http://www.sql-server-performance.com/2006/awe-memory/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 1, 2011 at 1:49 pm
Even with my server displace 8 GB ram in task manger and in system prop. tell me it has access to the ram. I still need to add the two switch lines in my boot.ini and then enable AWE in sql server
November 1, 2011 at 1:51 pm
Yes.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 1, 2011 at 1:59 pm
Ok so VMWare is misled the OS with amount of it can access
Do I need to worry about Enable the Lock Page in Memory Option when I enable AWE in SQL
November 1, 2011 at 2:04 pm
It depends ....
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 1, 2011 at 2:15 pm
with 32 bit you MUST enable lock pages in memory to use AWE. You will need to restart SQL.
---------------------------------------------------------------------
November 1, 2011 at 2:42 pm
Correct George.
This is the ref .. http://technet.microsoft.com/en-us/library/ms179301(SQL.90).aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 1, 2011 at 2:56 pm
Ok. So I treat the server as stand one server and set it up with two switch in the boot.ini and enable page lock manage. And not to worry about VMWare causing the OS to read 8GB of ram
November 1, 2011 at 2:59 pm
MaxDD (11/1/2011)
And not to worry about VMWare causing the OS to read 8GB of ram
not sure I understand what you mean by that?
---------------------------------------------------------------------
November 1, 2011 at 3:09 pm
Sorry
I was trying to say not to worry about the OS saying 8Gb because of VMWare. And that I need to follow the steps of adding two switches in boot.ini and enable page lock manage for me to take advantage of 8Gb in the server.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply