Re: Large Amount of Memory Message

You don't really need to throttle that memory IMO. What I initially did
when I was getting these alerts daily was to ignore them for a month. Then
I went in and set the alert threshold to 110 or 120% of the 30-day average
value. If you're not having specific symptoms that lead you to want to make
adjustments, I'd just up the alert threshold rather than mess with SQL.

For anything you change from its default, I recommend keeping a written
record of the default setting in case you get an unintended result.


"thomas" <thomas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:05BDF6AC-3DF9-4014-96D5-82B45E6C3140@xxxxxxxxxxxxxxxx
Thanks Mr. Nickason for the quick reply.

The first site was very helpful except now I don't know what is causing
the
problem.

Once I've gone to the Health Monitor > Right click on Allocated Memory
Properties:

The Expression I have is "If the average value of Committed Bytes [Real
Number] Is greater that 3500000000 (3.5 GB).

So I'm not sure what that is pertaining to or what is causing this value?

Also, I have seen Susan's blog about changing the throttling for RAM for
SQL
instances, should I do this? I didn't think it need to be done.

Thomas

"Dave Nickason [SBS MVP]" wrote:

I recommend going to this article and verifying that the alert settings
are
correct. This is the blog of top-level SBS support at MS, so please add
to
your feeds or bookmark for future reference. These guys watch the
community
for common issues, so there's always a lot of good stuff here.

Allocated Memory Errors After Adding RAM
http://blogs.technet.com/sbs/archive/2006/06/07/433707.aspx

Failing that, I'd search Susan Bradley's blog for information on
throttling
the RAM allocation for SQL instances. Susan's blog is a primary source
of
relevant and current info about SBS, and other small business computing
issues, and also lots of good security stuff.

http://msmvps.com/blogs/bradley/default.aspx

"thomas" <thomas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A68D2660-34A7-43E4-9EF1-F96CEA20E52B@xxxxxxxxxxxxxxxx
Hello All! Please give me some guidance.

We currently have SBS 2003 SP1 and 3GB of Memory.

I've been receiving this alert:

"A large amount of memory is committed to applications and processes.
Consistently high memory usage can cause performance problems.

To determine which processes and applications are using the most
memory,
use
Task Manager. Monitor the activity of these resources over a few days.
If
they continue to use a high level of memory and are less critical
processes
or services, try stopping and then restarting them.

You can disable this alert or change its threshold by using the Change
Alert
Notifications task in the Server Management Monitoring and Reporting
taskpad."

The SQL process is using (Under Task Manager > Processes > Mem Usuage)
1.8
GB of memory. I'm assuming the alert above is pertaining to this
process.
This is our primary use for SBS other than for file sharing. It the
alert
it
says "you can disable this alert", but I haven't been able to figure
out
how
to do that.

Am I correct in my assesment, that SQL is causing this alert? Should I
allow SQL to reserve 1.8 GB of memory? IF so how to I disable the
alert.
I've gone to the Monitor and Reporting under Server Management, but
have
been
unable to find this specific alert.

Thanks for you assitance,

Thomas








.

Relevant Pages

  • Re: Large Amount of Memory Message
    ... But wasn't really sure how to match each instance of SQL with a specific ... physical RAM - in other words, if it's using the page file. ... Memory Properties) means so I don't want to necessarily change the alert: ...
    (microsoft.public.windows.server.sbs)
  • Re: Allocated Memory Errors
    ... generally seems to fix it even without throttling down the msde instances. ... I did change my alert threshold to the appropriate 2 gig level but it ... Allocated Memory Errors After Adding ...
    (microsoft.public.windows.server.sbs)
  • Re: 2 Critical Alerts since I added more RAM
    ... the memory alert issue is ... Issues that are fixed in Exchange Server 2003 Service Pack 2 ... This newsgroup only focuses on SBS technical issues. ... the allocating more memory than usual alert issue ...
    (microsoft.public.windows.server.sbs)
  • Re: Large Amount of Memory Message
    ... Yesterday i noticed On my own SBS that one of the sqlserver instances was ... I doublechecked and noticed that It was the embedded version of SQL used ... It's alerting you if the server is using more memory than the amount ... I went in and set the alert threshold to 110 or 120% of the 30-day ...
    (microsoft.public.windows.server.sbs)
  • Re: 2 Critical Alerts since I added more RAM
    ... Exchange Server 2003 in a Small Business Server environment. ... 815372 How to Optimize Memory Usage in Exchange Server 2003 ... Click Change Alert Notifications, ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
Loading