Ok.  I believe the number is the main reason for the Remove Cache operation.  In fact when this number of deletes inserts happen, the statistics change drastically, and SQL Server will recompile the stored procedure always. If the statistics changes, It is good to include WITH RECOMPILE option in the stored procedure header so that it ...

Hi Zahran,  Removing cache is not recommended (even though you can remove the cached plan). Plan caching increases the performance by reusing the same execution plan (instead of creating one for each execution).  Cache remove operation happens when the cache in memory become outdated.  If it is happening only once in a while, ...