Usage of DBCC FREESESSIONCACHE

Use DBCC FREESESSIONCACHE command to clear distributed query connection Cache.

When we write distributed queries,it will use a connection cache against a SQL Server Instance.We can clear that distributed query connection cache using DBCC FREESESSIONCACHE. The only argument "WITH NO_INFOMSGS" will suppresses all informational messages. We should have sysadmin role to issue this command.