• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

sql servers using alot of memory on exchange 2003 sbs server

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
susanmelton
Asked:
susanmelton
  • 4
  • 2
  • 2
  • +1
1 Solution
 
susanmeltonAuthor Commented:
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>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.

 
susanmeltonAuthor Commented:
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>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
 
susanmeltonAuthor Commented:
Thank you very much!
0
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
How much RAM do you have installed on your machine?

Jeff
TechSoEasy
0
 
susanmeltonAuthor Commented:
We recemtly installed 3 gigs - so we now have a total of 3.5 Gigs
0
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
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

Independent Software Vendors: 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!

  • 4
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now