Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Freeproccache
Message
From
15/11/2008 07:29:50
 
 
To
14/11/2008 18:56:57
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
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:
01362066
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
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...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform