Changing the Page Count Filter setting that is used when calculating SQL database fragmentation

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?