December 2, 2004 at 4:41 am
Hi,
I am getting a buffer manager cache hit ratio of 93%.
SQL Server is set to dynamically use memory and there is over 1gb of memory free but SQL Server does not appear to be using it.
The Maximum Server Memory parameter has been set lower than total memory available. Is this preventing SQL Server from grabbing more memory?
December 2, 2004 at 4:52 am
How much RAM is in the server and what version of SQL Server are you using?
Standard edition cannot adress more than 2 GB of RAM.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
December 2, 2004 at 5:00 am
Hi Frank,
thanks for replying so quickly. There is 4gb of memory on the box and I am running SQL Server 2k Enterprise Edition.
December 2, 2004 at 5:32 am
Is the /3GB switch correctly set?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
December 2, 2004 at 6:52 am
Frank,
the /3gb switch is not set at all. I can not find a boot.ini file on any of my disks and the awe enabled parameter in sp_configure is set to zero.
My understanding is this: If there is 4gb of memory on the system, SQL Server 2k can use up to 3gb provided the /3gb switch is set and awe is enabled?
Presumably though, as these aren't set, I can not use more than 2gb whatever the maximum server memory parameter is set to?
December 2, 2004 at 6:56 am
This might clear things up:
http://www.sql-server-performance.com/awe_memory.asp
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
December 8, 2004 at 5:16 pm
boot.ini should be there. It could'be been hidden.
December 9, 2004 at 2:45 am
Yep, found the file, changed it and everything is okay now.
Many thanks for all your help.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply