Changing the Page Count Filter setting that is used when calculating SQL database fragmentation
Article ID: 100038533
Updated On:
Description
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] =
WHERE [settingTypeId] = 9801
GO
where,
Example:
o To change page count filter to 2000:
USE [EnterpriseVaultDirectory]
GO
UPDATE [dbo].[ExtendedSetting]
SET [settingValueNumeric] = 2000
WHERE [settingTypeId] = 9801
GO
IMPORTANT: Do not edit this content in Information Manager
Internal Notes
The content of this document is referenced in the Enterprise Vault Code. Do not make changes to this article. If you would like changes to be made to this content, use the Information Manager feedback feature. Alternatively, you can send an e-mail to the owner or the Enterprise Vault Knowledge Management team DL-CS-KM.
Issue/Introduction
Changing the Page Count Filter setting that is used when calculating SQL database fragmentation
Was this article helpful?
Yes
No
Powered by
