Noel

if you have dynamic memory management set for SQL Server then the ideal min
value will be zero and ideal max 2048 (on a 2GB box), SQL server will then
adjust memory appropriately depending on what other applications are running

Richard



-----Original Message-----
From: Noel Tan [mailto:[Email Address Removed] Tuesday, 3 December 2002 11:46 AM
To: LazyDBA.com Discussion
Subject: SQL Server memory


Hi all! In SQL Server memory, what is the ideal dynamically configuration
for min(MB) and max(MB) if you have 2 gigabytes of memory?

thanks
MS Sql Server LazyDBA home page