全文檢索耙梳頻寬伺服器組態選項ft crawl bandwidth Server Configuration Option

適用於: 是SQL Server 否Azure SQL Database 否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 Server Configuration Option
sp_configure (Transact-SQL)sp_configure (Transact-SQL)