Re: Large Amount of Memory Message

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: Allocated Memory Alert on SBS
    ... Task Manager. ... Monitor the activity of these resources over a few days. ... they continue to use a high level of memory and are less critical processes ... You can disable this alert or change its threshold by using the Change Alert ...
    (microsoft.public.windows.server.sbs)
  • Re: How do you troubleshoot allocated memory alert?
    ... carefully check the dateand times referenced in the alert. ... Allocated Memory Errors After Adding RAM ... limit memory use on some programs, but I'd rather know which one is causing ...
    (microsoft.public.windows.server.sbs)
  • RE: Database Memory
    ... Expand the Performace Logs and alerts group ... Give a Alert name as Memory Monitoring ... > monitor a database's memory. ...
    (microsoft.public.sqlserver.security)
  • RE: Performace montior
    ... I had problem with SQL performance counters and following article helped me ... Performance monitor shared memory setup failed: ... > log or alert will continue, but data for that counter will not be collected. ...
    (microsoft.public.sqlserver.server)
  • 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)
Loading