Re: Large Amount of Memory Message

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

OK, so that's the default instance, while the others are named instances.
If you know what the four instances are, you can deduce what the fourth one
is. It's got to be the Time Matters one, right?


"thomas" <thomas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:96312D31-E415-4785-9A69-2DEFE867DFA2@xxxxxxxxxxxxxxxx
After following your instruction I get:

sqlservr.exe Pid #1956 MSSQL$BKUPEXEC
sqlservr.exe Pid #1968 MSSQL$SBSMONITORING
sqlservr.exe Pid #1984 MSSQL$SHAREPOINT
sqlservr.exe Pid #2004 MSSQLSERVER

For PID# 2004 it still doesn't clarify which application is running with
SQL.

Any other suggestions?

Thomas

"Dave Nickason [SBS MVP]" wrote:

On the server, open a cmd prompt and type "tasklist /svc" without the
quotes. It'll give you the instance names for each of those PIDs.

Time Matters does sound like the culprit, though. I can't recall ever
seeing any of the built-in instances go that high. If it's that, you
could
mention it to their tech support to see if they have recommendations.
Personally, I wouldn't mess with that instance unless they sign off on
your
plan, especially in the absence of negative symptoms.

"thomas" <thomas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:37CF8081-52C0-454B-B107-F2C6F02E65F3@xxxxxxxxxxxxxxxx
It should be our main application (Time Matters/Billing Matters
Enterprise
7.0).

But wasn't really sure how to match each instance of SQL with a
specific
application.

I have 4 Instances of SQL running. With PID # 1956, 1968, 1984, and
2004.

Thomas

"Dave Nickason [SBS MVP]" wrote:

If you have 3 GB of RAM, according to the support blog, that figure
should
be set to 3221225472.

It's alerting you if the server is using more memory than the amount
of
physical RAM - in other words, if it's using the page file. It's not
that
any one process is using an abnormal amount of RAM, but rather that
the
total RAM in use by the server is high. If you have a single SQL
instance
using 1.8 out of 3 GB, I'd say that's a big part of the cause. What's
running in that instance?


"thomas" <thomas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:650FF589-3FC7-4D8E-8FD1-36C36CFBF761@xxxxxxxxxxxxxxxx
Mr. Nickason,

I guess my problem is I don't understand what this expression (for
Allocated
Memory Properties) means so I don't want to necessarily change the
alert:

If the average value of Committed Bytes [Real Number] Is greater
than
3500000000
(3.5GB).

Before I learned how to interact with this property I assumed it was
related
to the SQL instance that was using 1.8 GB of memory. But now I
don't
think
that is the case.

Besides I only have 3 GB of RAM memory so how would it every go over
3
GB?

If you would please explain this Expression for me because I'm
obviously
not
understanding.

I only care about this because it was set up as default not because
of
any
symptons.

Again, thanks for you patience.

Thomas
"Dave Nickason [SBS MVP]" wrote:

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: A large amount of memory is committed to applications and proc
    ... I can't argue with ignoring something when that alert is the only symptom. ... I don't think inetinfo.exe has any business using all that RAM. ... the INETINFO.EXE process is allocating more memory than usual....etc. ... Meanwhile, if the server is functioning properly, another option would be ...
    (microsoft.public.windows.server.sbs)
  • Re: Large Amount of Memory Message
    ... If you have 3 GB of RAM, according to the support blog, that figure should ... Memory Properties) means so I don't want to necessarily change the alert: ... I have seen Susan's blog about changing the throttling for RAM ...
    (microsoft.public.windows.server.sbs)
  • Re: Large Amount of Memory Message
    ... Allocated Memory Errors After Adding RAM ... If you have a single SQL ... I'd just up the alert threshold rather than mess with SQL. ...
    (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: Large Amount of Memory Message
    ... For PID# 2004 it still doesn't clarify which application is running with SQL. ... physical RAM - in other words, if it's using the page file. ... Memory Properties) means so I don't want to necessarily change the ... I went in and set the alert threshold to 110 or 120% of the 30-day ...
    (microsoft.public.windows.server.sbs)