sys.dm_fts_memory_pools

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

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

Full-Text Search Architecture

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
12 December 2006	New content: Added example.