Please enter search query.
Search <product_name> all support & community content...
Article: 100038533
Last Published: 2021-10-04
Ratings: 0 0
Product(s): Enterprise Vault
Description
Page count filter setting is used while calculating SQL database fragmentation. This filtering reduces the false positive results that might occur on smaller indexes, because smaller indexes can be stored on mixed extents.
The page count filter setting is stored at Enterprise Vault Directory level in the ‘ExtendedSetting’ table of the ‘EnterpriseVaultDirectory’ database. There is a single entry in the ‘ExtendedSetting’ table per Enterprise Vault directory. A change to this value applies to all the supported Enterprise Vault databases.
As recommended by Microsoft, the default page count filter should be 1000 when calculating database fragmentation. By default, Enterprise Vault uses a page count filter of 1000, but you can change this setting to optimize for your environment.
If you want to change the page count filter value to suit your environment, execute the following SQL query on the SQL Server. The new setting will take effect at next SQL fragmentation execution.
USE [EnterpriseVaultDirectory]
GO
UPDATE [dbo].[ExtendedSetting]
SET [settingValueNumeric] = <NewPageCountFilter>
WHERE [settingTypeId] = 9801
GO
where,
<NewPageCountFilter> is the new page count filter to be set.
Example:
o To change page count filter to 2000:
USE [EnterpriseVaultDirectory]
GO
UPDATE [dbo].[ExtendedSetting]
SET [settingValueNumeric] = 2000
WHERE [settingTypeId] = 9801
GO
Was this content helpful?
Translated Content
Please note that this document is a translation from English, and may have been machine-translated. It is possible that updates have been made to the original version after this document was translated and published. Veritas does not guarantee the accuracy regarding the completeness of the translation. You may also refer to the English Version of this knowledge base article for up-to-date information.