February 12, 2015 at 10:47 am
Hi,
What is the use of running DBCC FREESESSIONCACHE.
How frequently can we do this on all the databases.
What happens if we schedule to run it every 1min.
Are there any advantages/disadvantages of running this on all databases.
February 12, 2015 at 2:25 pm
DBCC FREESESSIONCACHE removes all queries from the distributed query cache. This however does not impact anything in the standard procedure cache, to clear the standard procedure cache use DBCC FreeProcCache instead. The distributed query cache contains the queries that used the OPENROWSET and OPENDATASOURCE functions to connect to remote data sources.
February 13, 2015 at 1:38 am
Before answering your last three questions...
Why are you considering running it at all?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 13, 2015 at 8:05 am
It has been already running before we took them into support, the guys who managed those and leaving now is saying to make use of more worker threads, which I am not sure.. and also there is a DNS issue going on the server.. where the SQL Server was not able to connect during that issue.
Please suggest
February 18, 2015 at 9:24 pm
Could anyone please suggest on this...
February 18, 2015 at 10:19 pm
This was removed by the editor as SPAM
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply