DBCC FREESESSIONCACHE (Transact-SQL)

**APPLIES TO:** SQL Server (starting with 2008) Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse

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

Transact-SQL Syntax Conventions

Syntax

DBCC FREESESSIONCACHE [ WITH NO_INFOMSGS ]  

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)