DBCC FREESESSIONCACHE (Transact-SQL)

Applies to: yesSQL Server (all supported versions) YesAzure SQL Managed Instance

Flushes the distributed query connection cache used by distributed queries against an instance of Microsoft SQL Server.

Topic link icon Transact-SQL Syntax Conventions

Syntax

DBCC FREESESSIONCACHE [ WITH NO_INFOMSGS ]  

Note

To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation.

Arguments

WITH NO_INFOMSGS
Suppresses all informational messages.

Permissions

Requires membership in the sysadmin fixed server role.

Examples

The following example flushes the distributed query cache.

USE AdventureWorks2012;  
GO  
DBCC FREESESSIONCACHE WITH NO_INFOMSGS;  
GO  

See Also

DBCC (Transact-SQL)