Solved

sql servers using alot of memory on exchange 2003 sbs server

Posted on 2006-07-06
10
267 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
  • 4
  • 2
  • 2
  • +1
10 Comments
 
LVL 7

Expert Comment

by:Zadkin
Comment Utility
0
 

Author Comment

by:susanmelton
Comment Utility
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 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
>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
 

Author Comment

by:susanmelton
Comment Utility
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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
>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
Comment Utility
Thank you very much!
0
 
LVL 74

Expert Comment

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

Jeff
TechSoEasy
0
 

Author Comment

by:susanmelton
Comment Utility
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
Comment Utility
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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I've often see, or have been asked, the question about the difference between the Exchange 2010 SP1 version, available as part of Small Business Server (SBS) 2011, and the “normal” Exchange 2010 SP1 Standard. The answer to the question is relativ…
If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

744 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now