Skip to content

Latest commit

 

History

History
62 lines (46 loc) · 1.78 KB

dbcc-freesessioncache-transact-sql.md

File metadata and controls

62 lines (46 loc) · 1.78 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
DBCC FREESESSIONCACHE (Transact-SQL)
DBCC FREESESSIONCACHE flushes the distributed query connection cache used by distributed queries against an instance of SQL Server.
rwestMSFT
randolphwest
12/05/2022
sql
t-sql
language-reference
FREESESSIONCACHE
FREESESSIONCACHE_TSQL
DBCC_FREESESSIONCACHE_TSQL
DBCC FREESESSIONCACHE
DBCC FREESESSIONCACHE statement
distributed queries [SQL Server], cache
clearing distributed query cache
flushing distributed query cache
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 ]

[!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 AdventureWorks2022;
GO
DBCC FREESESSIONCACHE WITH NO_INFOMSGS;
GO

See also