Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Proc Cache Question RE: Proc Cache Question
simon4132-806507
Mr or Mrs. 500
Points: 580
More actions
October 16, 2012 at 8:48 am
#1549615
Hi,
I'm not sure how the memory could be a problem.
When I clear the cache it is back up to 4gb again within a short period (e.g. an hour or less) but the system does not slow down for days.
It has 32gb memory for a 40gb database.
Thanks
Simon