Skip to content

Latest commit

 

History

History
45 lines (38 loc) · 2.32 KB

File metadata and controls

45 lines (38 loc) · 2.32 KB
title ft notify bandwidth Server Configuration Option | Microsoft Docs
ms.custom
ms.date 03/02/2017
ms.prod sql-non-specified
ms.prod_service database-engine
ms.service
ms.component configure-windows
ms.reviewer
ms.suite sql
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic article
dev_langs
TSQL
helpviewer_keywords
ft notify bandwidth opion
small memory buffers
memory [SQL Server], buffers
ms.assetid 9ca284c5-f3e0-4a67-a132-fff376ff0ffe
caps.latest.revision 19
author MikeRayMSFT
ms.author mikeray
manager craigg
ms.workload Inactive

ft notify bandwidth Server Configuration Option

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

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 [!INCLUDEmsCoName] [!INCLUDEssNoVersion] 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

[!INCLUDEssNoteDepFutureAvoid]

See Also

Server Configuration Options (SQL Server)
ft crawl bandwidth Server Configuration Option
sp_configure (Transact-SQL)