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