sys.dm_fts_memory_buffers (Transact-SQL)

APPLIES TO: YesSQL Server YesAzure SQL Database NoAzure Synapse Analytics (SQL DW) NoParallel Data Warehouse

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.


The following column will be removed in a future release of MicrosoftSQL Server: 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.


On SQL Server, requires VIEW SERVER STATE permission.
On SQL Database Premium Tiers, requires the VIEW DATABASE STATE permission in the database. On SQL Database Standard and Basic Tiers, requires the Server admin or an Azure Active Directory admin account.

Physical Joins

Significant joins of this dynamic management view

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)