This topic has not yet been rated - Rate this topic

sys.dm_fts_memory_pools (Transact-SQL)

SQL Server 2008 R2

Returns information about the shared memory pools available to the Full-Text Gatherer component 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.

Requires VIEW SERVER STATE permission on the server.

From	To	Relationship
dm_fts_memory_buffers.pool_id	dm_fts_memory_pools.pool_id	Many-to-one

The following example returns the total shared memory owned by the Microsoft Full-Text Gatherer component of the SQL Server process:

SELECT SUM(buffer_size * buffer_count) AS "total memory" 
    FROM sys.dm_fts_memory_pools

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions