Ran into this; search for article Q274750 at
http://support.microsoft.com
memory usage is dependent on SS version (enterprise vs standard) and
your OS...

-----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