Hi

Leave around 100 to 200Mb free, set the max memory setting and thats it.
NEVER let sqlserver take over your box in terms of memory, your OS will hate
you for it :)

-----Original Message-----
From: Noel Tan [mailto:[Email Address Removed] Tuesday, 3 December 2002 8: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