RE: RAM hungry SBSMonitoring .

Hello Tony,

Thank you for posting to the SBS Newsgroup.

Thanks a lot for Dirk-Thomas Brown's great sharing!

I understand that you want to know how to restrict the RAM usage of
SBSMonitoring instance of SQL. If I have misunderstood your concern, please
let me know.

Dirk-Thomas Brown's web link has showed you detail steps. Here I have some
additional information for you, please see:

Information 1. Configure SQL instance memory usage.

We can use max server memory to prevent SQL Server from using more that the
specified amount of memory (we can also use min server memory to guarantee
a minimum amount of memory to an instance of SQL Server). To do so, open a
command prompt and run the following command:

osql -E -S sbsserver\SBSMONITORING

You will enter the osql command prompt. Run the commends below (replace
<xxx> with the amount of memory):

1> EXEC sp_configure ''show advanced options'', 1
2> reconfigure
3> go

1> EXEC sp_configure ''min server memory'', <xxx>
2> reconfigure
3> go

1> EXEC sp_configure ''max server memory'', <xxx>
2> reconfigure
3> go

After doing the above steps, you may run the commands to check the
configured memory usage:

1> EXEC sp_configure
2> go

More information, please check KB 321363.
INF: SQL Server Memory Usage
http://support.microsoft.com/kb/321363

Information 2. Optimize Exchange server memory usage.

Please follow KB 815372 to optimize Exchange server usage.

How to optimize memory usage in Exchange Server 2003
http://support.microsoft.com/kb/815372

Hope the above information helps and we look forward to working with you
again.

Best regards,

Brandy Nee

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.



--------------------
>Thread-Topic: RAM hungry SBSMonitoring .
>thread-index: AcWsdCIdgFe+39e7RPWKWF7Rr854uA==
>X-WBNR-Posting-Host: 196.22.209.70
>From: "=?Utf-8?B?VG9ueVY=?=" <TonyV@xxxxxxxxxxxxxxxxxxxxxxxxx>
>Subject: RAM hungry SBSMonitoring .
>Date: Mon, 29 Aug 2005 01:32:03 -0700
>Lines: 3
>Message-ID: <1C8575D8-BB86-49D0-B73B-B036632AF18A@xxxxxxxxxxxxx>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.windows.server.sbs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:148698
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>My SBS monitoring uses a lot of RAM.
>How can I limit this SQL instance to use only a certain specified amount?
>
>

.

Relevant Pages

  • Re: Indexing uses *lots* of memory
    ... Do you install SQL Server on Exchange Server? ... Microsoft is providing this information as a convenience to you. ... This newsgroup only focuses on Exchange technical issues. ... I'm not worried about store.exe memory usage (the ...
    (microsoft.public.exchange2000.general)
  • RE: w3wp Memory Usage
    ... Thank you for posting in SBS newsgroup. ... | Thread-Topic: w3wp Memory Usage ...
    (microsoft.public.windows.server.sbs)
  • RE: Allocated Memory Alert on DOMAIN
    ... the large memory usage is an expected behavior. ... install the ISA server 2004 with the default installation options, ... command to limit the maximum memory usage for the MSDE instance. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Another Allocated Memory Alert Question
    ... "Jerry zhao (MSFT)" wrote: ... As for the memory usage for the SQL ... > INF: SQL Server Memory Usage ...
    (microsoft.public.windows.server.sbs)
  • Re: Exchange 2000 does not release memory
    ... For all your question it's better that you post them in an Exchange ... newsgroup instead of in an Outlook newsgroup. ... > Our Exchange Server 2000 SP3 Shows strange memory usage behaviour. ...
    (microsoft.public.outlook.general)
Loading