Meg is this a dedicated SQL Server? Or do you have other applications
running?

Patrick Gallucci
MCT, MCDBA, MCSE, CCIE
www.patrickgallucci.com
214-642-0524
[Email Address Removed]

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


Hello!

You know the value for max server memory is 2147483647? Is that bits or
bytes or KB? Might sound like a silly question but I'm only a junior!
Also, we have 2GB of RAM and our 'set working set size' is set to 0, our
min memory is 0 and our max memory is 2047. Does this sound like a good
plan or would you recommend changing?

Thanks!
Meg

-----Original Message-----
From: Chris Kempster [mailto:[Email Address Removed]
Sent: 03 December 2002 14:13
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] email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________


**********************************************************************
DISCLAIMER
Any opinions expressed in this email are those of the individual and not
necessarily of Mondial Assistance (UK) Ltd. This email and any files
transmitted with it, including replies and forwarded copies (which may
contain alterations) subsequently transmitted from the Company, are
confidential and solely for the use of the intended recipient. If you
are not the intended recipient or the person responsible for delivering
to the intended recipient, be advised that you have received this email
in error and that any use is strictly prohibited.

If you have received this email in error please notify the IT support
desk by telephone on +44 (0)208 2393984 or via email to
[Email Address Removed] including a copy of this message.
Please then delete this email and destroy any copies of it. Thank you.

Mondial Assistance (UK) Ltd
Mondial House
102 George Street
Croydon
CR9 1AJ

Mondial Assistance (UK) Ltd Registered in England No.1710361
Registered office as above
**********************************************************************


________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________

MS Sql Server LazyDBA home page