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
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.
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
Requires VIEW SERVER STATE permission on the server.
Physical Joins
.gif "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 |