Q
Problem solve Get help with specific problems with your technologies, process and projects.

Database performance slowing down

This developer wants to know why the performance database on his Domino server slows down every three days, forcing Domino to be re-started.

The performance of a database on a server is slowing down every two days. The database has around 130,000 documents and is around 2GB. It is not full-text indexed. It works for two days pretty well. On the third day it goes for a toss. Domino has to be restarted to get the database back to work. When the database is giving problems (it takes about 15-20 minutes to open), the Windows CPU utilization shows around 3% utilized. There are only six applications on the server, but these are highly critical applications that need to be up 24/7.

If restarting the Domino server helps, that suggests that this is a memory issue. I suggest you check how much memory the Domino server processes are using, and how much disk activity there is. CPU utilization is not the only important factor.

If you determine that there's a memory leak, figuring out what's causing it may be tricky. Knowing which process owns the excess memory will help. Possibly, as an interim solution, you could address the issue by restarting just that one process every couple of days, rather than the whole server.

However, this one application that's getting slow may well not be causing of the problem. Possibly there's a general server slowdown caused by another application or process, and you only notice it in this application because this is the one that places the heaviest demands on the server.

I would also look for any agents in any databases that process large numbers of documents. Are they using the Delete statement (in LotusScript, or recycle in Java) to remove NotesDocument objects from memory? If you don't do this, the objects are cached in the agent manager's memory and can accumulate over time.

Also look for any processes that delete and create large numbers of documents. I'm not sure this would cause the problem you're seeing, but I frequently see large databases that are reloaded nightly by deleting and recreating all documents from some outside data source. This can cause severe performance issues.

Do you have comments on this Ask the Expert question and response? Let us know.

Dig Deeper on Lotus Notes Domino Performance

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchDataCenter

SearchContentManagement

Close