Hi Kevin,
What is the os you are using?
Is the Os able to see all the memory.

In case of Winnt you have to set the option
/3Gb/FastDetect in the Boot.ini and reboot the system.

Set the sql server memeory to dynamic and set the sql server memory to
(total memory)-X mb
Where X Mb is the approximate memory which any other process on the server
can use.

Deepak

-----Original Message-----
From: Sexton, Kevin [mailto:kevin.[Email Address Removed] Thursday, March 28, 2002 6:55 AM
To: [Email Address Removed] [Email Address Removed] 1.7 GB memory


I am unable to get SQLServer to use more than the default 1.7GB memory.
The machine has 4GB of RAM but I am getting insufficient memory errors
for SQL Server and when I check task manager the machine is only using
just over 1.8GB and SQLServer is using 1.7GB

-Kevin J. Sexton


---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page