dbcc-freesessioncache-transact-sql.md

title	DBCC FREESESSIONCACHE (Transact-SQL)
description	DBCC FREESESSIONCACHE flushes the distributed query connection cache used by distributed queries against an instance of SQL Server.
author	rwestMSFT
ms.author	randolphwest
ms.date	12/05/2022
ms.service	sql
ms.subservice	t-sql
ms.topic	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 [!INCLUDEssNoVersion].

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: 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 AdventureWorks2022;
GO
DBCC FREESESSIONCACHE WITH NO_INFOMSGS;
GO

See also

• DBCC (Transact-SQL)