Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

sys.dm_fts_memory_pools (Transact-SQL)

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?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.