Performance tuning for Domino.Doc 3.1

by Volker Weber

Anybody out there who can give me some insights on performance tuning for a Domino.Doc application on Domino 5.0.12. Dual processor DL380, 1 gig of RAM, Windows 2000 Server SP4. Queries take between 1 and 10 seconds after a reboot. 24 hours later, the same queries can take anywhere between 20 seconds and a few minutes. I am suspecting an OS problem, since recycling the Domino server does not cure the issue. You have to reboot the OS.

Any insights? Please leave an email address so I can get back to you.

Comments

I'm no expert in domino.doc but...
1. Did you watch the taskmanager while executing the queries ?
2. Are their any files on the system that increase between the reboots ?
3. What else is this system doing beside serving the domino.doc application ?
4. Is there a virus scanner running on the system or a backup software ?
5. Did you move the system on another machine where the OS is new installed ?
6. Did you take the machine out of the local network and attached it to hub/switch with only on client connected ?

questions over questions...

Sometimes there are the fact that /tmp folders would be to full w/in logs. check the trace log entry.
a further reason can be that shared memory is not cleaned up successfully after index runs overnight.

this are the 2 points which i have expierenced with Domdoc.

cheers
Ingo

Hi Volker,

I'd try to establish whether it is indeed the OS which is loosing some stuff (handles memory ,...).
To that end I'd use W2K performance monitor which can eg be found in Start/Programs/Administrative Tools/Performance .
I'd use 'Performance Logs and Alerts/Counter Logs' and watch the relevant processes for handle usage and working set size for the period in question. Perhaps there is one that stands out.
You might also find Perfmon Counters which are specific to Domino domino.doc..


Martin Forisch, 2004-02-11 17:18

It does sound like an OS problem...

If you find that the performance degredation is not linked to the OS, then if it is just queries that are taking a long time, not general operation, then perhaps there are problems with some of the full-text indexes.

We had a situation where the ft-index of certain cabinets were corrupted and this was slowing down performance...

Don't know about domino.doc in specific, I do do know about Notes in general:

- 6.0 creates a smaller indexes, so huge performance increasements
- rebuilding indexes every 3-6 months is worthwhile. This can also half your query time
- disk defragmentation is also recommendable
- compacting databases also

If you do everything in the right order, there is a lot of gains to be get.

Volker,
have you nicked that problem yet?
I recently also supected an OS problem when a customer's machine started to burn memory like crazy.
But lo and behold it's just been one of the worms endemic at that customer. (one of those that runs as service named scvhost.exe)
So depending where the machine is it might be worthwile to have a look at the memory/handele consumption of all running processes in taskmanager/processexplorer/performance monitor.
Also the physical disk io counters in perfmon might show you why the server is underperforming.
Cu, Martin

Martin Forisch, 2004-02-13 11:02

Post a comment











Shall I remember this for you?




Use your full name and a working email address. Unless you want your comment to be removed. No kidding.



Ceci n'est pas un blog

vowe.net is a personal website published by Volker Weber a.k.a. vowe. I am an author, consultant and systems architect based in Darmstadt, Germany.

rss Click here to subscribe

Hello

About me
Contact
Publications
Certificates
Frequently asked questions
Join the network

Poll

Which BlackBerry could be your next one?

Getting poll results. Please wait...

Local time is 08:23

visitors.gif
146 visitors online

News

Other sources of news, imported into my own format to make them more accessible:

Heise Online
Schlagzeilen
Weather
Blog roll

Archives

As most of my articles roll off the front page rather quickly, I am making an archive of previous posts available here. You can also use the handy search box at the top of the page if you are looking for something particular.

Last 30 days
More archives

Got the T-shirt?

Got the T-shirt?

Systems Architecture

This site runs on an Apache web server on top of the Linux operating system. The content is managed with MovableType 2.661 which is implemented in Perl. Last but not least the HTML code your browser sees is put together with PHP.

© 1992-2008 Volker Weber.
All Rights Reserved.

Impressum