TechNet
Export (0) Print
Expand All

sys.dm_fts_memory_buffers (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse 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.

System_CAPS_ICON_note.jpg Note

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.

ColumnData typeDescription
pool_idintID of the allocated memory pool.

0 = Small buffers

1 = Large buffers
memory_addressvarbinary(8)Address of the allocated memory buffer.
namenvarchar(4000)Name of the shared memory buffer for which this allocation was made.
is_freebitCurrent state of memory buffer.

0 = Free

1 = Busy
row_countintNumber of rows that this buffer is currently handling.
bytes_usedintAmount, in bytes, of memory in use in this buffer.
percent_usedintPercentage of allocated memory used.

Requires VIEW SERVER STATE permission on the server.

Significant joins of this dynamic management view

FromToRelationship
dm_fts_memory_buffers.pool_iddm_fts_memory_pools.pool_idMany-to-one

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

Community Additions

ADD
Show:
© 2016 Microsoft