June 3, 2009 at 10:28 am
Despite of having 32GB of memory, windows task manager shows that SQL server is only using 279MB at all times, windows performance monitor also shows little memory utilization but I am running processes (math processes) that really should be using lots of memory, or at least more than 300MB.
Also, the CPU utilization and I/O seems high. I did not set a Max memory utilization in SQL properties
SQL version : 2000 ENT
OS: Windows 2003 ENT 32bit
Server memory: 32 GB
Server processors: 8
Thanks!.
June 3, 2009 at 11:19 am
Right click sql server properties and change Memory MAX setting to x gig.
May have to reboot if SQL 2000 i know 2005 you do not need to.
June 3, 2009 at 1:24 pm
Is AWE enabled - with the /PAE switch in the boot.ini also?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 3, 2009 at 1:29 pm
Jeffrey,
I am new in SQL server, can you explain a little bit AWE and point where can I check if it is enabled?
Thanks!.
June 3, 2009 at 1:40 pm
In the boot.ini file on the server - you have to have the /PAE switch set. I am going to guess that this is already the case because the OS can see all 32GB of memory.
To find out if AWE is enabled, open a query window and execute:
Execute sp_configure 'Show Advanced Options', 1;
Reconfigure with override;
Execute sp_configure 'awe enabled';
Check the run value to see if it is set to 1. If not, AWE is not enabled and will need to be set. You can set it by:
Execute sp_configure 'awe enabled', 1;
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 3, 2009 at 2:29 pm
Jeffrey,
I just checked and yes, AWE is enabled, but I don't see the /PAE switch in the boot.ini
how can I add that and how it would benefit the memory utilization?
Thanks
June 3, 2009 at 2:37 pm
If the server (OS) already sees all 32GB of memory, and SQL Server is reporting 32GB of memory available then the PAE switch is enabled.
Now, all you have to do is set the max memory to 28GB (no more than this, because the OS needs at least 4GB of memory to manage it all).
To validate that SQL Server is using the memory, you cannot rely on Task Manager. Task Manager on 32-bit systems has a problem reporting more than 2GB of memory. Use perfmon to capture the SQL Server memory counters.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply