You are viewing limited content. For full access, please sign in.

Question

Question

How to improve performance

asked on August 28, 2014

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

 

 

1 0

Replies

replied on August 28, 2014

Hey Bernard,

 

Improving performance is a tricky subject to troubleshoot from afar, because there is usually many different reasons that the same symptoms can occur.  I'm not the best resource for Database Administration topics, but I wanted to share a tool that you might not be aware of!

 

It's called Performance Monitor (perfmon, for short) and is included in most Windows environments.  This allows you to view different counters, or metrics on your machine, such as memory, processor speed, etc.  You can use the Performance Monitor to track these counters in real time, or use it as a tool to track the counters over an extended period of time to see a more comprehensive view.  Tracking these counters can help you understand if your resources are being maxed out and give you more direct knowledge of what components of the hardware might benefit the system most, if upgraded.

 

As I stated earlier, I'm not Database Administrator, but hopefully you'll find this tool helpful.  There are many resources available online to learn more.

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.