November 20, 2018 at 11:11 am
What is the command to clear query cache?
What is the best way or time to do it? Can I clear the query cache anytime or will impact performance?
Do I have to do it for each db?
The instance has only 7 user abs ( small size) with 4 processors.
Please share your thoughts. thank you!
November 20, 2018 at 12:27 pm
sizal0234 - Tuesday, November 20, 2018 11:11 AMWhat is the command to clear query cache?
What is the best way or time to do it? Can I clear the query cache anytime or will impact performance?
Do I have to do it for each db?
The instance has only 7 user abs ( small size) with 4 processors.
Please share your thoughts. thank you!
DBCC FREEPROCCACHE
You can do this anytime, but the question is WHY do you want to do this, and what problem are you trying to fix?
You do not have to do this for every DB. The command clears the entire cache for the instance.
And my thoughts, especially considering your other post here, is that you are trying to solve some issues and the approach your are taking may not be the correct one.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 20, 2018 at 2:32 pm
Thank you for our reply it worked.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply