March 21, 2006 at 12:42 pm
we have a development machine (win 2003 standard, 4 GB memory) that two instances of sql server 2000 dev edition, sp3 running. We are having this memory problem where available memory is only 200 MB, and no memory intensive process running when I do 'select * from sysprocesses' on either of the instance. I tried reboot the server, did not fix it. And then disable 'auto start sql server on os start', started the machine again, avaible memory is 3.8G, but once I restarted SQL Server, the available memory declined to 200MB, PF Usage stays at 3.6GB. Can anyone please shed some light?
March 21, 2006 at 8:45 pm
Hi,
Did u fix the memory usage for SQL Server is yes then change to dynamic.
Look in the SQL Server Properties.
HTH
from
Killer
March 22, 2006 at 11:57 am
Thanks for the thought. The machine is running OK now. We used to set the memory for both instances to be 0-4GB(which is the total amount of memory on the machine), and allow sql server to dynamically allocate memory. Last night, I changed the max memory for both instances to be 2GB. And the machine has been running fine since then. I am not sure what has been going on. I suspect maybe sql server has issues with dynamically allocating memory to two instances on the same machine? And what happened yesterday was a memory leak, leaving the majority of the machine's memory unaccounted for? Any thoughts?
Thanks!
March 23, 2006 at 8:33 am
Hi,
Can u pls tell me did u enabled awe.Is OS Boot.ini is configured to use 4 GB of RAM.
It may or may not be a memory leak because u have configured the server to use 0-4GB of memoery.
No memeory is left for OS.
from
Killer
March 23, 2006 at 9:07 am
I dont think awe is enabled. Here is the entry from sp_configure :
name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
awe enabled 0 1 1 1
and there is no boot.ini file on the server.
What would be good memory settings for two instances on the same server? Right now, I am giving max memory of 2 G to both instances. How much should I leave for the OS?
Thanks!
March 24, 2006 at 12:04 am
Hi ,
Did u restarted ur SQL Server after enableing awe.
Every OS has a BOOT.ini but is hidden.
U can unhide it by this command
c:>attrin -r -a -s -h boot.ini
then go to c drive and open boot.ini in notepad window.
in the last add \PAE so that 4 GB RAM can be used.
and restart ur Server.
OS do not take much memory but i will say leave 128 MB for OS.Also search in Google according to ur HArdware config.
From
Killer
March 24, 2006 at 12:05 am
In ur case AWE is enabled.If it is not enabled thevalue will be 0
from
Killer
March 29, 2006 at 11:08 am
Raj:
The below update was top notch. Thanks for it.
Where did you fetch this info ?? Would be nice to know !!!
"U can unhide it by this command
c:>attrin -r -a -s -h boot.ini "
March 29, 2006 at 10:29 pm
Hi Arul,
Sorry for the mistake the command start as attrib not attrin.
from
killer
April 1, 2006 at 3:01 am
Hey, Raj that was not the problem...
Just wanted to know from where did you pick these comments...
Is it in BOL ?? Would like to know the reference...its actually gud !! : - )
April 2, 2006 at 8:08 pm
Hi Arul,
I get these contents from SQL-Performance.com
from
Killer
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply