Home > Ask the Domino Experts > Domino Development Questions & Answers > Database performance slowing down
Ask The Domino Expert: Questions & Answers
EMAIL THIS

Database performance slowing down

Andre Guirard EXPERT RESPONSE FROM: Andre Guirard

Pose a Question
Other Domino Categories
Meet all Domino Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 29 September 2005
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.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Domino Development
Can I create and copy Microsoft Excel spreadsheets with LotusScript?
'Illegal circular use: Audit Trail' error when opening Lotus Notes docs
How to make computed fields recalculate
Sending and logging faxes from Lotus Notes and Domino
Accessing documents in a Lotus Notes database
Adding an action to the Lotus Notes right-click menu
Writing temporary text files that email as attachments
Trapping the on-click event of a radio button
Copying a form object using LotusScript
Connecting to a remote DB2 server with LEI

Lotus Notes Domino Performance
Top 10 Lotus Notes/Domino administration tips of 2009
Domino Mailbag: Notes/Domino clustering
Domino Domain Monitoring hints and gotchas
Using Domino Administrator to manage client settings
Build your own Domino multi-server test environment
How the Agent Profiler tool improves Notes/Domino performance
Benefits of virtualizing Lotus Domino servers
Configuring Domino Domain Monitoring (DDM)
How to move Notes databases off Domino 8 servers and save disk space
What is Notes 8.5's DAOS (Domino Attachment and Object Storage) feature?

Lotus Notes Domino Agents
LotusScript agent moves new mail to folder
Quickly scan all databases on a Lotus Domino server
How the Agent Profiler tool improves Notes/Domino performance
Run or restart Notes/Domino agents via text messages
Calculating results for a column in a Lotus Notes view
Approve Lotus Notes documents using a BlackBerry mobile device
LotusScript agent indexes Lotus Notes/Domino databases
Top 10 Lotus Notes/Domino coding and development tips of 2008
Open documents in Lotus Notes from the Web without a UNID
Fix and update Lotus Notes documents with limited access

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Lotus Notes Domino on Blackberry and mobile devices
HomeTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersDomino IT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2010, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts