February 8, 2009 at 6:08 pm
I am getting the following values in Perfmon:
\\CLAEIS01
Memory
Available MBytes 5055
Pages/sec 0.000
PhysicalDisk _Total
Avg. Disk Queue Length 0.000
Process _Total
Working Set 2644439040
Processor _Total
% Processor Time 13.867
SQLServer:Buffer Manager
Buffer cache hit ratio 97.101
Page life expectancy 132
SQLServer:Memory Manager
Total Server Memory (KB) 1661888
The Boot.Ini contains:
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect /PAE
In the SQL Server Properties, I have:
* Memory\Dynamically Configure SQL Server memory: Min=0, Max=6550 (MB)
The server is Win2K3 SP2 Enterprise, DELL PE6850, 3.16 GHz Xeon Quad CPU with 8 GB RAM.
It looks like SQL Server is only allocating 1.6 GB of RAM of the possible 8 GB. I just read that I need to set the property "Lock Pages In Memory" for the service account which SQL uses, so I am performing this tonight.
Is there anything else I can do to have SQL Server use the hardware RAM as efficiently as possible? Thanks.
February 8, 2009 at 7:50 pm
I am not quite sure about the above stats, we need to wait for the experts but as far as I am concerned the SQL server uses the memory only if it needs to even if you set it to some specified value at max memory option.
February 9, 2009 at 5:10 pm
Do you have awe enabled?
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
February 10, 2009 at 3:13 pm
I ran:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
exec sp_configure 'awe enabled'
Which gave me:
awe enabled
Min: 0
Max:1
Config_value: 1
Run_value: 1
So, yes it is. Thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply