Hi,
Sorry for confused.
Actually is like this, my customer is facing performance problem when using our application. After some investigation, he found that event viewer logged SQL Server is running FREEPROCCACHE statement.
Therefore, I would like to know, how to prevent this? I search from internet and posts mentioned it could be caused by scheduled tasks. However, that is no any scheduled task in SQL Server.
Any advice?
Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...