RE: Allocated Memory Error



Hello Tani,

Thank you for your update and thank Duncan for the good supplement.

I hope the information is help for you.

If there's anything else about this issue I can do for you, please do not
hesitate to let me know.

Thank you and have a nice day,

Best regards,

Terence Liu(MSFT)

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: Allocated Memory Error
| thread-index: AciEMeYJ3hF6W26PQa2hoW7Cxan06w==
| X-WBNR-Posting-Host: 207.46.19.168
| From: =?Utf-8?B?VGFuaQ==?= <Tani@xxxxxxxxxxxxxxxxxxxxxxxxx>
| References: <B3E4CBCA-6D34-4C06-874C-9721BA573216@xxxxxxxxxxxxx>
<X6CJrnChIHA.6264@xxxxxxxxxxxxxxxxxxxxxx>
| Subject: RE: Allocated Memory Error
| Date: Wed, 12 Mar 2008 04:12:02 -0700
| Lines: 137
| Message-ID: <AFEB039A-4AF5-495E-86B4-F9450F8D5DD4@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.2992
| Newsgroups: microsoft.public.windows.server.sbs
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:97865
| NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| Thanks to everyone. We will review the links and see what happens.
|
| Tani
|
| "Terence Liu [MSFT]" wrote:
|
| > Hello Tani,
| >
| > Thank you for posting here. Let's also thank Henrik for the input.
| >
| > According to your description, I understand that the SBS uses large
memory
| > after he started SBS 1 or 2 weeks ago. If I have misunderstood the
problem,
| > please don't hesitate to let me know.
| >
| > From the top 5 processes by memory usage we know the first is SQL
Server.
| > It used 1.6GB memory.
| >
| > Based on my research, this is a by-design behavior of SQL Server.
| >
| > When you start SQL Server, SQL Server memory usage may continue to
steadily
| > increase and not decrease, even when activity on the server is low.
| > Additionally, the Task Manager and Performance Monitor may show that
the
| > physical memory available on the computer is steadily decreasing until
the
| > available memory is between 4 to 10 MB.
| >
| > This behavior alone does not indicate a memory leak. This behavior is
| > normal and is an intended behavior of the SQL Server buffer pool.
| >
| > By default, SQL Server dynamically grows and shrinks the size of its
buffer
| > pool (cache) depending on the physical memory load reported by the
| > operating system. As long as enough memory is available to prevent
paging
| > (between 4 - 10 MB), the SQL Server buffer pool will continue to grow.
As
| > other processes on the same computer as SQL Server allocate memory, the
SQL
| > Server buffer manager will release memory as needed. SQL Server can
free
| > and acquire several megabytes of memory each second, allowing it to
quickly
| > adjust to memory allocation changes.
| >
| > For more information, please refer to:
| > How to adjust memory usage by using configuration options in SQL Server
| > http://support.microsoft.com/?id=321363
| >
| > How to determine proper SQL Server configuration settings
| > http://support.microsoft.com/?id=319942
| >
| > I hope these steps will give you some help.
| >
| > Thanks and have a nice day!
| >
| > Best regards,
| >
| > Terence Liu(MSFT)
| >
| > 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: Allocated Memory Error
| > | thread-index: AciDbDhgzA/oWSqcSVm/UKubA792Kw==
| > | X-WBNR-Posting-Host: 207.46.19.168
| > | From: =?Utf-8?B?VGFuaQ==?= <Tani@xxxxxxxxxxxxxxxxxxxxxxxxx>
| > | Subject: Allocated Memory Error
| > | Date: Tue, 11 Mar 2008 04:37:00 -0700
| > | Lines: 27
| > | Message-ID: <B3E4CBCA-6D34-4C06-874C-9721BA573216@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.2992
| > | Newsgroups: microsoft.public.windows.server.sbs
| > | Path: TK2MSFTNGHUB02.phx.gbl
| > | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:97620
| > | NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| > | X-Tomcat-NG: microsoft.public.windows.server.sbs
| > |
| > | What do I need to do to correct this? Of course, If I reboot the
server
| > | during maintenance, the memory usage decreases but is back to 4G
range
| > within
| > | a week or 2.
| > |
| > | Background:
| > | We have the following installed:
| > | SBS 2003 Premium, BES Express (1 license), WSS 3.0 (side by side
| > | installation). 4G RAM installed
| > |
| > | Allocated Memory
| > |
| > | A large amount of memory is committed to applications and processes.
| > | Consistently high memory usage can cause performance problems.
| > |
| > | Top 5 Processes by Memory Usage
| > |
| > | sqlservr - 2564 1,688 MB
| > | store - 6644 337 MB
| > | sqlservr - 2504 167 MB
| > | OfcService - 2984 104 MB
| > | SMEX_Master - 3724 102 MB
| > |
| > | Memory in use 4,146 MB 4,273 MB
| > |
| > | Thanks,
| > | Tani
| > |
| > |
| >
| >
|

.



Relevant Pages

  • Re: Allocated memory alerts and changed threshold still doesnt si
    ... Microsoft Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... Allocated memory alerts and changed threshold still doesn't ... | week or so of server operation without a restart. ...
    (microsoft.public.windows.server.sbs)
  • Re: Accessing sql server
    ... port, select All ports, in Remote port, select Fixed port and input 1433 ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... | I have now checked and I can access the sql server when creating an ODBC ...
    (microsoft.public.windows.server.sbs)
  • Re: Accessing sql server
    ... Filters rule to see if we can resolve this issue. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... | I have now checked and I can access the sql server when creating an ODBC ...
    (microsoft.public.windows.server.sbs)
  • Re: WSUS Problem - Help Needed
    ... You met the following error when using WSUS 3.0 SP1 Server Clean Up Wizard: ... Verify that SQL server is running on the WSUS Server. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: Companyweb sts_config error with event id 1000 50070
    ... I am sure that you are using the SQL Server 2000. ... errorlog you have sent on 2nd Sep, ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)

Loading