Export (0) Print
Expand All

sys.dm_fts_memory_pools

Updated: 12 December 2006

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.

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 full-text gatherer of the SQL Server process.

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

Release History

12 December 2006

New content:
  • Added example.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft