Nuta
Dostęp do tej strony wymaga autoryzacji. Możesz spróbować się zalogować lub zmienić katalog.
Dostęp do tej strony wymaga autoryzacji. Możesz spróbować zmienić katalogi.
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.
[!UWAGA]
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 "Znaczące sprzężenia tego widoku zarządzania dynamicznego")
Relationship Cardinalities
From |
To |
Relationship |
|---|---|---|
dm_fts_memory_buffers.pool_id |
dm_fts_memory_pools.pool_id |
Many-to-one |
Zobacz także
Odwołanie
Dynamic Management Views and Functions (Transact-SQL)
Full-Text Search and Semantic Search Dynamic Management Views and Functions (Transact-SQL)