[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

sql servers using alot of memory on exchange 2003 sbs server

Posted on 2006-07-06
10
Medium Priority
?
316 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
 

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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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 800 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

In the event you manage a Small Business Server 2003, and you are audited for PCI compliance, there are several changes you must make in order to pass the audit. I can take no credit for discovering any of these fixes or workarounds, but there is no…
The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

649 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