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.
|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.|
On SQL Server, requires
VIEW SERVER STATE permission.
On SQL Database Premium Tiers, requires the
VIEW DATABASE STATE permission in the database. On SQL Database Standard and Basic Tiers, requires the Server admin or an Azure Active Directory admin account.