Hi All,
Basically the issue we are seeing is that the Buffer Cache is being filled up of AdHoc queries which are only being executed once and the SQL Server appears to be removing Procecure Queries from the Cache instead
of the AdHoc queries which is resulting in a recompile of the Procedures which will then be placed in the cache again for it then to be removed again within x minutes.
The only solution to stop this is to free the cache (DBCC FREEPROCCACHE) which gives you around 2 hours before the cache becomes full again and the same cycle occurs, please could you anyone advise whether there
is some option with SQL 2014 that is causing this behaviour or if there is a work around, we have tried many options to combat this but nothing has resolved the issue.
We have tried the following so ...
Go to the complete details ...