susanmelton
asked on
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.
Any assistance or direction would be greatly appreciated.
ASKER
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?
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
>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.
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.
ASKER
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?
>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.
> 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.
ASKER
Thank you very much!
How much RAM do you have installed on your machine?
Jeff
TechSoEasy
Jeff
TechSoEasy
ASKER
We recemtly installed 3 gigs - so we now have a total of 3.5 Gigs
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You don't have to like it, see: http://msmvps.com/blogs/bradley/archive/2005/02/04/34984.aspx