Awe related qry.
-
I have a new box at my place with windows 2003 enterprise Edt with ( sp1 )installed and it has 17 GB of Physical Memory .
I have installed Sql 2000 ( 32 bit ) with sp4 + hotfix 8.00.2040 on it , do i have to enable AWE on for SQL server ?? .
I think i have to enable this option , snd set min & max memory on the server to somewhere around 14 to 15 GB..
Thanks in advance
K.S.
-
my 2 cents...
1. Check if PAE is enabled. I am sure it is, that's why OS is seeing 17 GB of RAM. To check go to
Start>Run>msconfig and select BOOT.INI tabe
2. run sp_configure 'awe' in query analyzer. If you see below output then you are all set
name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
awe enabled 0 1 1 1
3. Check in Memory counters of SQL server to see how much memory is used by SQL server
4. Another place to check will be SQL Error Logs. You will see a message
Address Windowing Extention enabled
HTH
-
How to configure SQL Server to use more than 2 GB of physical memory
-
just to add to Balmukund Lakhani 's replies :
- check you have installed SQL2000 Enterprise Edition !
- AWE Memory SQL Server Performance Tuning Tips
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
-
Ahhh.. I missed to mention that.
Thanks alzdba
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply