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.
.gif)
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
Relationship Cardinalities
|
From
|
To
|
Relationship
|
|
dm_fts_memory_buffers.pool_id
|
dm_fts_memory_pools.pool_id
|
Many-to-one
|
See Also