Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Freeproccache
Message
 
 
To
15/11/2008 07:29:50
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Environment versions
SQL Server:
SQL Server 6.5 and older
Miscellaneous
Thread ID:
01361859
Message ID:
01362118
Views:
9
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform