sys-dm-fts-memory-buffers-transact-sql.md

title	sys.dm_fts_memory_buffers (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/29/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.dm_fts_memory_buffers dm_fts_memory_buffers_TSQL dm_fts_memory_buffers sys.dm_fts_memory_buffers_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.dm_fts_memory_buffers dynamic management view
ms.assetid	56895fe5-e8df-4d75-9adc-c1f7757cdef8
caps.latest.revision	33
author	douglaslMS
ms.author	douglasl
manager	jhubbard

sys.dm_fts_memory_buffers (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx_md]

Returns information about memory buffers belonging to a specific memory pool that are used as part of a full-text crawl or a full-text crawl range.

Note

The following column will be removed in a future release of [!INCLUDEmsCoName][!INCLUDEssNoVersion]: row_count. Avoid using this column in new development work, and plan to modify applications that currently use it.

Column	Data type	Description
pool_id	int	ID of the allocated memory pool. 0 = Small buffers 1 = Large buffers
memory_address	varbinary(8)	Address of the allocated memory buffer.
name	nvarchar(4000)	Name of the shared memory buffer for which this allocation was made.
is_free	bit	Current state of memory buffer. 0 = Free 1 = Busy
row_count	int	Number of rows that this buffer is currently handling.
bytes_used	int	Amount, in bytes, of memory in use in this buffer.
percent_used	int	Percentage of allocated memory used.

Permissions

On [!INCLUDEssNoVersion_md], requires VIEW SERVER STATE permission.
On [!INCLUDEssSDS_md] Premium Tiers, requires the VIEW DATABASE STATE permission in the database. On [!INCLUDEssSDS_md] Standard and Basic Tiers, requires the Server admin or an Azure Active Directory admin account.

Physical Joins

Relationship Cardinalities

From	To	Relationship
dm_fts_memory_buffers.pool_id	dm_fts_memory_pools.pool_id	Many-to-one

See Also

Dynamic Management Views and Functions (Transact-SQL)
Full-Text Search and Semantic Search Dynamic Management Views and Functions (Transact-SQL)