Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayft notify bandwidth (server configuration option)
Applies to: 
SQL Server
Use the ft notify bandwidth option to specify the size to which the pool of small memory buffers can grow. Small memory buffers are 64 kilobytes (KB) in size. The max parameter value specifies the maximum number of buffers that the full-text memory manager should maintain in a small buffer pool. If the max value is zero, then there is no upper limit to the number of buffers that can be in a small buffer pool.
The min parameter specifies the minimum number of memory buffers that must be maintained in the pool of small memory buffers. Upon request from the Microsoft SQL Server memory manager, all extra buffer pools will be released but this minimum number of buffers will be maintained. If, however, the min value specified is zero, then all memory buffers are released.
Under certain circumstances the number of buffers currently allocated is less than the value specified by the min parameter.
Note
This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Server Configuration Options (SQL Server)
ft crawl bandwidth Server Configuration Option
sp_configure (Transact-SQL)
Additional resources
Documentation
-
ft crawl bandwidth (server configuration option) - SQL Server
Learn about the ft crawl bandwidth option. See how it affects the number of buffers that SQL Server maintains in the pool of large memory buffers.
-
sp_helpfilegroup (Transact-SQL) - SQL Server
sp_helpfilegroup returns the names and attributes of filegroups associated with the current database.
-
Out-of-memory with large XML schema collections - SQL Server
Learn about solutions for handling out-of-memory conditions when loading or dropping a large XML schema collection.