Our database has millions of documents, each one of them with more than 10 index fields and every page is OCR'ed; plus 100 users are performing searches, participating in workflows and retrieving documents.
Can some one please help:
1. Suggested maintenance plan for the database
2. List of tables that require special maintenance
3. Can the index files from the OCR be partitioned or split? it is over 10GB
4. Any suggestions regarding infrastructure? Requirements for each server? which server requires more RAM, which more CPU, which more I/O?
5. Should any of the services (LF, WF, AT, WA, WL, LFFTS, SQL) be on the same server or it is better to have them all separated in Virtualized servers?
Thanks