Export (0) Print
Expand All

sys.dm_fts_memory_buffers (Transact-SQL)

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 Note

The following column will be removed in a future release of Microsoft SQL Server: row_count. Avoid using this column in new development work, and plan to modify applications that currently use it.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

Requires VIEW SERVER STATE permission on the server.

From

To

Relationship

dm_fts_memory_buffers.pool_id

dm_fts_memory_pools.pool_id

Many-to-one

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft