Applies To: SQL Server 2014, SQL Server 2016 Preview
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.
The following column will be removed in a future release of Microsoft SQL Server: row_count. Avoid using this column in new development work, and plan to modify applications that currently use it.
Applies to: SQL Server (SQL Server 2008 through current version).
ID of the allocated memory pool.
0 = Small buffers
1 = Large buffers
Address of the allocated memory buffer.
Name of the shared memory buffer for which this allocation was made.
Current state of memory buffer.
0 = Free
1 = Busy
Number of rows that this buffer is currently handling.
Amount, in bytes, of memory in use in this buffer.
Percentage of allocated memory used.
Requires VIEW SERVER STATE permission on the server.