ft crawl bandwidth 服务器配置选项ft crawl bandwidth Server Configuration Option

适用对象:是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

使用 ft crawl bandwidth 选项可指定较大内存缓冲池可增长到多大。Use the ft crawl bandwidth option to specify the size to which the pool of large memory buffers can grow. 较大内存缓冲区的大小为 4 MB。Large memory buffers are 4 megabytes (MB) in size. max 参数值可指定全文内存管理器应在较大缓冲池中保持的最大缓冲区数。The max parameter value specifies the maximum number of buffers that the full-text memory manager should maintain in a large buffer pool. 如果 max 的值为零,则较大缓冲池中可以保持的缓冲区数没有上限。If the max value is zero, then there is no upper limit to the number of buffers that can be in a large buffer pool.

min 参数可指定较大内存缓冲池中必须保持的最小内存缓冲区数。The min parameter specifies the minimum number of memory buffers that must be maintained in the pool of large memory buffers. MicrosoftMicrosoft SQL ServerSQL Server 内存管理器发出请求后,将释放所有额外的缓冲池,但将保留该最低数量的缓冲区。Upon request from the MicrosoftMicrosoft SQL ServerSQL Server memory manager, all extra buffer pools will be released but this minimum number of buffers will be maintained. 不过,如果指定的 min 值为零,则释放所有内存缓冲区。If, however, the min value specified is zero, then all memory buffers are released.

在某些情况下,当前分配的缓冲区数会小于 min 参数指定的值。Under certain circumstances, the number of buffers currently allocated is less than the value specified by the min parameter.

备注

此功能处于维护模式并且可能会在 Microsoft SQL Server 将来的版本中被删除。This feature is in maintenance mode and may be removed in a future version of Microsoft SQL Server. 请避免在新的开发工作中使用该功能,并着手修改当前还在使用该功能的应用程序。Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

另请参阅See Also

服务器配置选项 (SQL Server) Server Configuration Options (SQL Server)
ft notify bandwidth 服务器配置选项 ft notify bandwidth Server Configuration Option
sp_configure (Transact-SQL)sp_configure (Transact-SQL)