views - XPages performance - 2 apps on same server, 1 runs and 1 doesn't

Question

We have been having a bit of a nightmare this last week with a business critical XPage application, all of a sudden it has started crawling really badly, to the point where I have to reboot the server daily and even then some pages can take 30 seconds to open.

The server has 12GB RAM, and 2 CPUs, I am waiting for another 2 to be added to see if this helps.

The database has around 100,000 documents in it, with no more than 50,000 displayed in any one view. The same database set up as a training application with far fewer documents, on the same server always responds even when the main copy if crawling.

There are a number of view panels in this application - I have read these are really slow. Should I get rid of them and replace with a Repeat control?

There is also Readers fields on the documents containing Roles, and authors fields as it's a workflow application.

I removed quite a few unnecessary views from the back end over the weekend to help speed it up but that has done very little.

Any ideas where I can check to see what's causing this massive performance hit? It's only really become unworkable in the last week but as far as I know nothing in the design has changed, apart from me deleting some old views.

Answer 1

Try to get more info about state of your server and application.

Hardware troubleshooting is summarized here: http://www-10.lotus.com/ldd/dominowiki.nsf/dx/Domino_Server_performance_troubleshooting_best_practices

According to your experience - only one of two applications is slowed down, it is rather code problem. The best thing is to profile your code: http://www.openntf.org/main.nsf/blog.xsp?permaLink=NHEF-84X8MU

To go deeper you can start to look for semaphore locks: http://www-01.ibm.com/support/docview.wss?uid=swg21094630, or to look at javadumps: http://lazynotesguy.net/blog/2013/10/04/peeking-inside-jvms-heap-part-2-usage/ and NSDs http://www-10.lotus.com/ldd/dominowiki.nsf/dx/Using_NSD_A_Practical_Guide/$file/HND202%20-%20LAB.pdf and garbage collector Best setting for HTTPJVMMaxHeapSize in Domino 8.5.3 64 Bit.

This presentation gives a good overview of Domino troubleshooting (among many others on the web).