Poor database performance

Hi,

I have and domino 8.5 with 25 users. One database has the size of 13.5G.

Only this database user has complaining the poor database performance.

Is the size the cause maybe?

How Can I test it?

Thanks,

Anderson

Subject: Poor database performance, thinks to check

You can try this, It’s very useful

Keyword Client_Clock Description
Enables certain time keeping logging…see the link
http://www.drcc.com/ref/notesini.nsf/all/7A4872639FB90313C12567D70052CE32
From MartinScott Consulting technique for figuring out what causes delays

50 Ways to Make Your Domino Apps Faster (From Jamie Magee and Franziska Tanner)

Have you checked the user activity in the log.nsf db? You could be surprise.
Are there any massive reading?

Is there any private views on one of the servers.
Is there any special agents running ?
Do you maintain unread documents count?

Have you read those? Seems to be

About readers fields, three very interesting documents:

Performance Considerations for Domino Applications
http://www.redbooks.ibm.com/redbooks/pdfs/sg245602.pdf

Notes from Support: Reader Names fields can impact performance

and
technote : Use of ReaderNames fields slows view performance in Notes

Product: Lotus Notes > Lotus Notes > Version 7.0, 6.5, 6.0, 5.0
Platform(s): Mac OS, Windows
Doc Number: 1097609
Published 2006-05-22

http://www-1.ibm.com/support/docview.wss?uid=swg21247611

Excellent article

Great links here:
http://www-10.lotus.com/ldd/bpmpblog.nsf/dx/search.htm?opendocument&q=performance

Notes/Domino Best Practices: performance
http://www-1.ibm.com/support/docview.wss?rs=463&uid=swg27008849

White Paper: Performance basics for IBM Lotus Notes developers

http://www-1.ibm.com/support/docview.wss?rs=463&context=SSKTMJ&dc=DA400&uid=swg27012441&loc=en_US&cs=UTF-8&lang=en&rss=ct463lotus

JYR

Subject: Poor database performance

Views ! How many do you have?

How many are categorized? (max 2)

How many levels of categorization do you have?

What are the view refresh interval?

http://www-01.ibm.com/support/docview.wss?uid=swg27002624

Subject: Defrag.NSF

Anderson, do yourself and your server a favour, grab a 30 day trial copy of Defrag.NSF 1.38 and run it on your Domino server.

Regards,

Grant

Subject: Defrag drive / database

Technote #1229817:

http://www-01.ibm.com/support/docview.wss?rs=899&context&uid=swg21229817

Subject: Get Free DominoDefrag

Project →

http://www.openntf.org/projects/pmt.nsf/ProjectLookup/DominoDefrag

See Spanish Lotus User Group DominoDefrag Presentation Review →

http://www.slug.es/blogslug.nsf/dx/defragging-domino-servers-v12.pdf/$file/defragging-domino-servers-v12.pdf

Subject: agree - get the free defrag tool

hiwe use the free defrag tool called DominoDefrag. Its a project on OpenNtf and you can download from:

http://www.openntf.org/internal/home.nsf/project.xsp?action=openDocument&name=DominoDefrag