Question around IndexCommited
- 12 years ago
OK so here's what i would do
1. get a SELECT COUNT(*) FROM JournalArchive WHERE indexCommited = 0
2. Go to the Vault admin console,right click your site name and go to properties
3. Go to the Monitoring tab, second item down should be "Archived Items Awaiting Index"
4. What is the "Threshold" set to, is it higher than the COUNT(*) you got from step one?
5. Is it even Checked to monitor for items awaiting index?
6. If you right click "Status" under your "Directory on ...." , click "re-run all checks"
7. Does the alert then come up ?
One obscure thing it could be that i remember in the back of my mind is that you may need to update statistics in SQL, as i seem to remember a case or two when it would complain that it had X amount of items awaiting backup when it was really a lot lower and it was reporting stale information
So in that case i would do this and run the following SQL StatementsUSE EVVSYourVaultStore_1
ALTER INDEX ALL ON JournalArchive REBUILD
GO
UPDATE STATISTICS JournalArchive
GO
DBCC FREEPROCCACHE
GO
DBCC UPDATEUSAGE (EVVSYourVaultStore_1, "JournalArchive")
GO