Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |
See Also
Reference
Dynamic Management Views and Functions (Transact-SQL)
Full-Text Search and Semantic Search Dynamic Management Views and Functions (Transact-SQL)