You obviously do not have any boxes running SMS. You need to be careful
dedicating too much ram to SQL Server, because you can actually cause the DB
Engine to starve the OS. Been there, done that, wont go back.

Greg Murrell PC/LAN Engineer-MCP
Wells Fargo Services Company
Email greg.[Email Address Removed]


-----Original Message-----
From: Viradia, Ashish [mailto:[Email Address Removed]
Sent: Tuesday, December 03, 2002 7:20 AM
To: LazyDBA.com Discussion
Subject: RE: SQL Server memory


I agree with Chris! In fact I have 80 servers running at MAX = 95% of total
RAM

Ashish Viradia.
Database Administration



-----Original Message-----
From: Chris Kempster [mailto:[Email Address Removed] Tuesday, December 03, 2002 9:13 AM
To: LazyDBA.com Discussion
Subject: RE: SQL Server memory


Sorry, but letting SQL Server take all the ram is bad practice as far as im
concerned. I have seen many a server grind to a halt with huge queries and
large users bases over short periods causes sqlserver to jump its memory
consumption to max. When we talk max, its around 10 to 15mb less than the
TOTAL ram. With servers (esp .net servers) running losts of other services
in the background for a variety of internal and other reasons to satisfy
dbms and OS calls, then have fun with that dedicated box! you will need it.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional
commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional
commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page