Team is experencing issues related to the performance as CPU usga e was quite high so in between they just flushed the cache and after that the performance issue got...

We have sp2 on the box. When team execute DBCC FreeProcCache the problem get solved. Is there any way using which users who are not in sysadmin roles can execute...

Yes I agree that DB will manage automatically what to store in cache and what not so there is a very rare chance that performance issues are there because of...

I got your point and I will try to get more info on the same. Thanks for the Input. I am wondering how I could miss that point 🙂

Let me phrase the problem once more. We are facing issues with performance because there are too many things in procedure cache. So to boost up performance, we need to...

We tried with Recomplie option but the same is not removing the plan from cache. Could you please suggest what could be the reason for the same?

Another way could...