Solved

sql servers using alot of memory on exchange 2003 sbs server

Posted on 2006-07-06
10
302 Views
Last Modified: 2010-04-19
We have an Exchange 2003 SBS server and recently we began to receive performance reports stating " a large amount of memory is committed to applications and processes".   I did a re-boot and the numbers looked better - but they are gradually climbing  back up again.   I noticed that the sql server is taking up quite a bit of memory - and there are 2 sql servers running.  One says it is using 66832 k and the other is 39468 k.  Should there be 2 running and should they be using this much memory?
Any assistance or direction would be greatly appreciated.
0
Comment
Question by:susanmelton
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +1
10 Comments
 
LVL 7

Expert Comment

by:Zadkin
ID: 17054321
0
 

Author Comment

by:susanmelton
ID: 17054513
Ok - so how do I know what the maximum limit should be? He set it to 70 but I have no idea what to set mine at.  Is there a way to calculate it?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17054529
>I noticed that the sql server is taking up quite a bit of memory -
every database system, not only sql server, uses as much memory they can get.
this is normal, to optimize the data access performance.

>and there are 2 sql servers running.  
you possibly have 2 instances running, you might check for what usage the 2 are, possibly one is not needed, and you can stop/uninstall it.

>One says it is using 66832 k and the other is 39468 k.  
so that's 100MB in total, that's NOT much, this is VERY low actually.

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:susanmelton
ID: 17054672
Well - I re-booted at 12:00 today and the memory was freed up considerably.  But the memory has gradually increased all afternoon.  The one using the most memory is MSSQL$SBSMonitoring which is now at 68334k and the other one is MSSQL$SHAREPOINT and has increased very little- 39472k.   Even if this is low, I believe it will keep increasing until again, we get another warning on a large amount of memory is being committed. Do you recommend leaving it alone or trying the fix as described in  bradleys blogs?  If you recommend setting the maximum limits, then how would I calculate that?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17054699
>Well - I re-booted at 12:00 today and the memory was freed up considerably.
> But the memory has gradually increased
yes, this is normal. sql server will take the memory as it reads data from the disk for the queries.

>warning on a large amount of memory is being committed
this "warning" is normal (can be ignored) on database servers, as changes are flushed in prefereably larger blocks to disk. you can safely remove that warning from the monitoring software for all your database servers.
0
 

Author Comment

by:susanmelton
ID: 17054755
Thank you very much!
0
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 17063167
How much RAM do you have installed on your machine?

Jeff
TechSoEasy
0
 

Author Comment

by:susanmelton
ID: 17075232
We recemtly installed 3 gigs - so we now have a total of 3.5 Gigs
0
 
LVL 74

Accepted Solution

by:
Jeffrey Kane - TechSoEasy earned 200 total points
ID: 17077519
Well, that's certainly plenty.  However, you can certainly follow the advice linked above in Susan Bradley's blog... set it at 70 as it suggests, and see if that works... unless you have a wildly different SBS configuration, it should be fine.  If it's not, then increase it a bit.

Jeff
TechSoEasy
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SBS 2011 - migration to Exchange 2016 5 310
IIS 7.5 to 8.0 6 122
Errors  Migrating DHCP from SBS 2008 to Server 2012 r2 2 69
SBS 2003 Windows 7 issues 7 43
Written by Glen Knight (demazter) as part of a series of how-to articles. Introduction One of the biggest consumers of disk space with Small Business Server 2008(SBS) is Windows Server Update Services, more affectionately known as WSUS. For t…
The problem of the system drive in SBS 2003 getting full continues to be an issue, even though SBS 2008 and SBS 2011 are both in the market place.  There are several solutions to this, including adding additional drive space or using third party uti…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question