February 4, 2009 at 10:22 pm
SQL 2000 enterprize is installed on windows server 2003. server memory is 2GB. i want to check AWE is enabled or not?
if AWE is enabled, i hv 2 GB memory, and if i don't apply 'SQL2000.MSDE-KB884525-SP4-x86-ENU' on the server, will it affect the performance?
Please reply asap.
Thanks in advance.
February 5, 2009 at 1:08 pm
Check the value of awe enabled under sp_configure output.
MJ
February 6, 2009 at 4:01 am
if you only have 2gb memory on the server no point configuring it to use AWE
the patch you mention is SP4 but for MSDE, this is not what you want if you are running enterprise edition. You want SQL2000-KB884525-SP4-x86-ENU.EXE
SP4 was not a performance release but you should apply it if possible, having tested it in dev first and confirmed whatever the app is is certified against it. (SP4 is years old so i would guess it is). You should also consider post SP4 applying HF 2187 and then MS08-040 to get right up to date.
---------------------------------------------------------------------
February 9, 2009 at 10:17 pm
I totally agree with you with context to 2GB memory.
i am not trying to configure AWE. my question is 'is AWE is enabled by default?' or it has to be explicitly configure? how to find out that AWE is enabled or not.
regarding SQL2000-KB884525-SP4-x86-ENU.EXE - this patch has already been applied. MSDE was not applied, which is now applied but still the problem of performance persists.
What i found from MS site that problem is not with SQL server. it is hardware (network card) problem. we are now working in this direction.
if you could throw light on AWE then please do it.
Thank you for the reply.
Regards.
February 9, 2009 at 10:30 pm
I found the following info regarding AWE...
If the total available memory is less than 3 GB, the instance of SQL Server 2000 will be started in non-AWE mode even if awe enabled is set to 1. In this situation, you do not need to manage AWE memory because dynamic memory allocation is used automatically.
AND
by default the value of AWE is 0. 0 means minimum value. does it mean disabled?
thank you all for replies.
February 10, 2009 at 3:57 am
a value of 0 for AWE setting does mean it is disabled.
check this in query analyser with command: (run one line at a time)
exec sp_configure 'advanced options',1
reconfigure
exec sp_configure 'AWE'
exec sp_configure 'advanced options',0
reconfigure
---------------------------------------------------------------------
February 13, 2009 at 12:17 am
thanks for the reply 🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply