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

Article:HOWTO59167  |  Created: 2011-09-05  |  Updated: 2011-09-07  |  Article URL http://www.symantec.com/docs/HOWTO59167
Article Type
How To



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.




Article URL http://www.symantec.com/docs/HOWTO59167


Terms of use for this information are found in Legal Notices