>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
Check
http://www.sqlmag.com/Article/ArticleID/47052/sql_server_47052.html
If it's not broken, fix it until it is.
My Blog