dbcc-freesessioncache-transact-sql.md

title	DBCC FREESESSIONCACHE (Transact-SQL)
description	DBCC FREESESSIONCACHE (Transact-SQL)
author	rwestMSFT
ms.author	randolphwest
ms.date	07/16/2017
ms.service	sql
ms.subservice	t-sql
ms.topic	language-reference
f1_keywords	FREESESSIONCACHE FREESESSIONCACHE_TSQL DBCC_FREESESSIONCACHE_TSQL DBCC FREESESSIONCACHE
helpviewer_keywords	DBCC FREESESSIONCACHE statement distributed queries [SQL Server], cache clearing distributed query cache flushing distributed query cache
dev_langs	TSQL

DBCC FREESESSIONCACHE (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Managed Instance]

Flushes the distributed query connection cache used by distributed queries against an instance of [!INCLUDEmsCoName] [!INCLUDEssNoVersion].

Transact-SQL Syntax Conventions

Syntax

DBCC FREESESSIONCACHE [ WITH NO_INFOMSGS ]  

[!INCLUDEsql-server-tsql-previous-offline-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)