Re: Recommended Max Memory for SQL - MSFW, WSUS, SBSMonitoring, SharePoint

Tech-Archive recommends: Fix windows errors by optimizing your registry

Adjusting the memory of the database is like doing a tune up of a race care
You select a base number, based on the amount of RAM in your box and what
the SQL server is doing
Then you query users on performance of the application and you monitor the
SBS box
If they say its running fine...back it down abit...is it still running fine?
If they tell you from the start that its bad...bump it up...how is it
now...and so on
Its a painstaking process to find the sweet spot.

--
Cris Hanna [SBS-MVP]
-------------------------------------------------
Microsoft MVPs
Independent Experts (MVPs do not work for MS)
Real World Answers
---------------------------------------------------------
Please do not contact me directly regarding issues

"wdsnews" <wdsnews.0640@xxxxxxxxxxxxxx> wrote in message
news:%23xpo$W7tHHA.1212@xxxxxxxxxxxxxxxxxxxxxxx
I did the same search and found the same blogsite as you. I guess I'm
comforted to know that many people are asking the same question. But
where's the suggested numbers? Many of the comments on the blog ask the
same question: "how much memory to set as the maximum?" But there's no
answer.

Is there a Microsoft recommended memory size or a suggested method for
determining the maximum memory size?



"Kevin Weilbacher [SBS-MVP]" <kweilbacMVP@xxxxxxx> wrote in message
news:ub6nHg4tHHA.1060@xxxxxxxxxxxxxxxxxxxxxxx
http://msmvps.com/blogs/bradley/archive/2005/02/04/34984.aspx

--
Kevin Weilbacher [SBS-MVP]
"The days pass by so quickly now, the nights are seldom long"


"wdsnews" <wdsnews.0640@xxxxxxxxxxxxxx> wrote in message
news:%23yYXhS4tHHA.4952@xxxxxxxxxxxxxxxxxxxxxxx
It's well known that SQL takes as much memory as it can, and several
experts tell us to manually set the memory size to xxx. But what number
should I use for xxx? I often see "100" as the example. I assume this
means 100MB. But why that number? How could I be more methodical in
picking a number? In the SQL 2005 Enterprise Manager that comes with the
Premium Edition, I can pick a SQL instance, choose properties, and
select the 'Memory' page. Can I get the same result by entering 100 in
the field called "Maximum server memory (in MB)"? What is the recommend
Maximum and Minimum for:

MSFW
WSUS
SBSMonitoring
SharePoint

Thanks for your help in fixing the slowness of some services.









.

Relevant Pages

  • Re: FTS Performance in SQL 2005
    ... Looking for a SQL Server replication book? ... The Memory Usage and VM Size never increase over about 65 MB and 20MB. ... Can you post you query plans and the output of statistics IO ... cost relative to the whole batch, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SBS 2003 SP2 Memory
    ... MY PF is up to 4.75GB and free Physical memory is at 1.8GB. ... about the SQL instances and watching their individual need over time. ... part if your server rarely uses the pagefile. ... each of them based on usage so watch their RAM usage for a week or more and ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL .mdf privacy violation - huge file contains personal contents
    ... The .NET runtime handles memory management ... ... in memory, archived to disk, but never deleted. ... them into temp files, which again, would be a privacy violation. ... SQL Server pre-allocates space for transaction logs, fill-space, etc. ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Do I need to run SQL services
    ... Thanks for using the SBS newsgroup! ... high memory usage and especially the SQL service take up much memory. ... particular server installation. ...
    (microsoft.public.windows.server.sbs)
  • Re: AWE settings.
    ... dynamic AWE to work using SQL 2005, but don't quote me on that. ... Microsoft SQL Server MVP ... immediately allocates memory at system startup. ...
    (microsoft.public.sqlserver.setup)