Skip to content

sys-dm-fts-memory-buffers-transact-sql.md

Latest commit

 

History

History
70 lines (57 loc) · 3.22 KB

sys-dm-fts-memory-buffers-transact-sql.md

File metadata and controls

70 lines (57 loc) · 3.22 KB

title: "sys.dm_fts_memory_buffers (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/29/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database" ms.service: "" ms.component: "dmv's" ms.reviewer: "" ms.suite: "sql" ms.technology:

  • "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
  • "sys.dm_fts_memory_buffers"
  • "dm_fts_memory_buffers_TSQL"
  • "dm_fts_memory_buffers"
  • "sys.dm_fts_memory_buffers_TSQL" dev_langs:
  • "TSQL" helpviewer_keywords:
  • "sys.dm_fts_memory_buffers dynamic management view" ms.assetid: 56895fe5-e8df-4d75-9adc-c1f7757cdef8 caps.latest.revision: 33 author: "douglaslMS" ms.author: "douglasl" manager: "craigg" ms.workload: "Inactive" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"

sys.dm_fts_memory_buffers (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

Returns information about memory buffers belonging to a specific memory pool that are used as part of a full-text crawl or a full-text crawl range.

Note

The following column will be removed in a future release of [!INCLUDEmsCoName][!INCLUDEssNoVersion]: row_count. Avoid using this column in new development work, and plan to modify applications that currently use it.

Column Data type Description
pool_id int ID of the allocated memory pool.

0 = Small buffers

1 = Large buffers
memory_address varbinary(8) Address of the allocated memory buffer.
name nvarchar(4000) Name of the shared memory buffer for which this allocation was made.
is_free bit Current state of memory buffer.

0 = Free

1 = Busy
row_count int Number of rows that this buffer is currently handling.
bytes_used int Amount, in bytes, of memory in use in this buffer.
percent_used int Percentage of allocated memory used.

Permissions

On [!INCLUDEssNoVersion_md], requires VIEW SERVER STATE permission.
On [!INCLUDEssSDS_md], requires the VIEW DATABASE STATE permission in the database.

Physical Joins

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

See Also

Dynamic Management Views and Functions (Transact-SQL)
Full-Text Search and Semantic Search Dynamic Management Views and Functions (Transact-SQL)