1. Support
  2. Knowledge base
  3. 100013897

Running the 'ReadFragmentationResults' stored procedure

Article: 100013897
Last Published: 2020-02-05
Ratings: 1 0
Product(s): Enterprise Vault

Problem

The 'ReadFragmentationResults' stored procedure enables you to determine which tables and indexes are fragmented. This stored procedure is present in the Directory, Vault Store, and Fingerprint databases. It accepts an optional 'smallint' parameter (which is an average fragmentation % filter). The fragmentation results returned by the stored procedure are filtered out based on this value. When you do not pass any filter value the stored procedure uses a default value of 30 for filtering the results.

Solution

Use the following command in the SQL query window to get the fragmentation details:
USE [EnterpriseVaultDirectory]
GO
 
DECLARE @AvgFragFilter AS smallint
 
SELECT @AvgFragFilter = [Threshold]
FROM [dbo].[Monitoring]
WHERE [MonitoringItemType] = 34
                AND [SiteEntryId] = '<SiteEntryID>'
 
USE <DatabaseName>
 
EXEC [dbo].[ReadFragmentationResults] @AvgFragFilter
GO
where,
<DatabaseName> is the name of the Directory, Vault Store or Fingerprint database for which to get the fragmentation results.
<SiteEntryID> is the Entry ID of the Enterprise Vault Site to read current fragmentation threshold.
 
Examples:
o    To run the stored procedure on ‘EnterpriseVaultDirectory’ database using the default average fragmentation % filter value:
 
USE [EnterpriseVaultDirectory]
 
EXEC [dbo].[ReadFragmentationResults]
GO
 
o    To run the stored procedure of Vault Store database named ‘EVVSExpressVaultStore_1’ associated with the Enterprise Vault Site having SiteEntryId as '1529582D4F8AEA04496E4208654CE90A11d10000MW-2K8R2-x64-2-A', and by using the already configured average fragmentation % filter value for that Site:
 
USE [EnterpriseVaultDirectory]
GO
 
DECLARE @AvgFragFilter AS smallint
 
SELECT @AvgFragFilter = [Threshold]
FROM [dbo].[Monitoring]
WHERE [MonitoringItemType] = 34
        AND [SiteEntryId] = '1529582D4F8AEA04496E4208654CE90A11d10000MW-2K8R2-x64-2-A'
 
USE [EVVSExpressVaultStore_1]
 
EXEC [dbo].[ReadFragmentationResults] @AvgFragFilter
GO

 

 

 

Was this content helpful?

Article Languages