SQLServerMemory.jpg

<div>
Thanks for this. One of the most informative responses I've had on this site to date.
</div>


Thanks for this. One of the most informative responses I've had on this site to date.

<div>
I had the same problem with our server. &nbsp;This solution works and keeps the memory down to whatever level you set it at. &nbsp;Score of 10 imo. &nbsp;Thanks
</div>


I had the same problem with our server.  This solution works and keeps the memory down to whatever level you set it at.  Score of 10 imo.  Thanks

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
It's not a major problem, but I've noticed recently, that each day, the SBS Monitoring database instance on SQL Express 2005 seems to use more and more memory and won't free it up. After about 3 days, the process is up to 1.7gb and affects the performance of the server and I have to kill the running process to free up the memory. It then begins again...<br />
<br />
Is this to do with the daily reports generated from the SBS on performance and health? Is there anything i can do to get it to release the memory without me having to kill the process manually?<br />
<br />
Thanks<br />
<br />
Paul
</div>
</div>


Hi,

It's not a major problem, but I've noticed recently, that each day, the SBS Monitoring database instance on SQL Express 2005 seems to use more and more memory and won't free it up. After about 3 days, the process is up to 1.7gb and affects the performance of the server and I have to kill the running process to free up the memory. It then begins again...

Is this to do with the daily reports generated from the SBS on performance and health? Is there anything i can do to get it to release the memory without me having to kill the process manually?

Thanks

Paul

SBS Monitoring and SQL not freeing up memory

Small Business Server (SBS) is a line of server operating systems targeted at small businesses by bundling the operating system with a number of other Microsoft products that would normally need to be purchased or licensed separately. The most notable inclusions are Exchange, SQL Server, SharePoint and ISA/TMG (Microsoft's firewall and proxy server).

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.