Skip to Content
0
Former Member
Nov 18, 2010 at 10:46 AM

SQL Server Memory filling up after processing dims

45 Views

Hi guys

We're seeing an issue with our SQL server (BPC 5.1 SP5)

Whenever we update a dimension and process it, the SQL server RAM use shoots up.

It usually sits at around 4.5GB used out of an available 16GB

However, after processing a dim, it jumps up to around 15GB used and stays there until SQL Server Service is restarted the next morning.

This obviously leads to a slowdown for the remainder of the day (all dim processing is done before 9am so as not to affect the business).

Has anyone seen this issue and is there anything that we can do about it (other than restarting the SQL Server Process, as we can't really do that durning business hours)

Thanks

Craig