How to see the number of items waiting to be indexed for each index volume

Description

This information can only be obtained from the SQL server.

Note: The SQL queries below assume that the Vault Store database and Enterprise Vault Directory database are located on the same SQL server. An alternative approach would be needed if this was not the case.


1.    Run the following SQL query against the Vault Store database to determine the number of new items waiting to be indexed:

select Records, ArchiveName
FROM
(select ArchivePoint.ArchivePointId, count(*)  Records
from journalarchive
inner join ArchivePoint on ArchivePoint.ArchivePointIdentity = JournalArchive.ArchivePointIdentity
where indexcommited=0
group by JournalArchive.ArchivePointIdentity, ArchivePoint.ArchivePointId) SQ
INNER JOIN EnterpriseVaultDirectory.dbo.ArchiveView ON ArchiveView.VaultEntryId = SQ.ArchivePointId
order by Records desc

This provides a list of the index volumes that have items waiting to be indexed. The list is ordered by the number of items waiting to be indexed.

2.    Run the following SQL query against the Vault Store database to determine the number of indexed items waiting to be updated:

select Records, ArchiveName
FROM
(select ArchivePoint.ArchivePointId, count(*)  Records
from journalupdate
inner join ArchivePoint on ArchivePoint.ArchivePointIdentity = JournalUpdate.ArchivePointIdentity
where indexcommitted=0
group by JournalUpdate.ArchivePointIdentity, ArchivePoint.ArchivePointId) SQ
INNER JOIN EnterpriseVaultDirectory.dbo.ArchiveView ON ArchiveView.VaultEntryId = SQ.ArchivePointId
order by Records desc

This provides a list of the index volumes that have items waiting to be indexed. The list is ordered by the number of items waiting to be indexed.

3.    Run the following sql query against the Vault Store database to determine the number of indexed items waiting to be deleted:

select Records, ArchiveName
FROM
(select ArchivePoint.ArchivePointId, count(*)  Records
from journaldelete
inner join ArchivePoint on ArchivePoint.ArchivePointIdentity = JournalDelete.ArchivePointIdentity
where indexcommitted=0
group by JournalDelete.ArchivePointIdentity, ArchivePoint.ArchivePointId) SQ
INNER JOIN EnterpriseVaultDirectory.dbo.ArchiveView ON ArchiveView.VaultEntryId = SQ.ArchivePointId
order by Records desc

These SQL queries provide a list of the index volumes that have items waiting to be indexed. The list is ordered with the index volumes with the most number of items waiting to be indexed at the top.

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)