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 the shared memory pools available to the full-text gatherer for a full-text crawl or a full-text crawl range.
| Column name | Data type | Description |
|---|---|---|
pool_id |
int |
ID of the allocated memory pool. 0 = Small buffers 1 = Large buffers |
buffer_size |
int |
Size of each allocated buffer in the memory pool. |
min_buffer_limit |
int |
Minimum number of buffers allowed in the memory pool. |
max_buffer_limit |
int |
Maximum number of buffers allowed in the memory pool. |
buffer_count |
int |
Current number of shared memory buffers in the memory pool. |
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 |
Examples
The following example returns the total shared memory owned by the full-text gatherer of the SQL Server process.
SELECT SUM(buffer_size * buffer_count) AS "total memory"
FROM sys.dm_fts_memory_pools
See Also
Reference
Dynamic Management Views and Functions
Full-Text Search Related Dynamic Management Views
Other Resources
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
12 December 2006 |
|