How many job servers are enough?

[hal999]

I have 10 now and they are all being used, so it still bogs down at times, is there a practical limit? Also what about the other servers, should I increase their numbers as well?
We get about 3000 report requests a day, managed/url.
Thanks in advance.

 

[MJRBIM]

Depending on the version of CE you are using there is a sizing guide that includes formulas for how many of each service are required to meat defined volumes.

You've got to work through the exercises, but it is pretty useful.

You should be able to get the sizing guide from you BO Tech Rep.

 

[hal999]

Found it on their site, thanks, we set it up with 3 job servers, 3 RAS servers, 2 page servers, 2 cache servers, and configured them as recommended, but it still fails after just 10 or 15 reports, the viewer comes up blank and we have to reboot, all job servers show up as running in the perf mon at all times (?), no errors in the logs, just stops working, cpu is 0 to 2%. Our box is dual Xeon with 2 gigs of ram, and it runs 8.5 fine with no extra servers. Maybe we got a demo version by mistake?

 

[Turkbear]

Before throwing even more resources at this, check the Event logs for any error messages - That setup should be able to handle that load with no problems unless all 3000 requests come in at the same time..Check the setting for maximum records returned and other limits set in the CMC for the servers to be sure you are not hitting some default limitations.

 

[hal999]

Thanks for your response. Nothing unusual in the logs. We applied all service packs and hotfixes, servers are numbered and configured according to the sizing docs, to no avail. Viewers come up blank after a few on-demand requests, no the 3000 is spread out over 24 hours, that is not excessive..? Our reports are very simple, nowhere near the 20000 record limit, and have worked no problem in 8.5 for 2 years under the same load. Called tech support but they were able to offer no useful suggestions. Unsure what else to do at this point.

 

[Turkbear]

Hi,
Just a few ideas:

If you have access to the datasource database, check the sessions to see if they are failing somehow.
( BTW, what database and connection method?)
When the blank page appears, see if the progress indicator is still active, if so then the data has not been retrieved, if not, then CE thinks the data has finished being returned - check for a database connection timeout.

Depending on the viewer user, try a right-click and View Source to see any hidden error messages.

If you can, run the Sql used by one of the reports directly
instead of in Crystal..See what is returned and how long it takes..

Hope you can find the problem...

 

[hal999]

Oracle via ODBC. The SQLs return almost immediately from CR or the dev environment. These reports have been running for years and are very simple, stored procs build the tables for the reports, all they do is read the output, it seems to be a # of concurrent request problem for on-demand in CE 10.
Thanks.

 

[Turkbear]

Hi,
OK..That gives me an idea ( it happens on some of our SP based reports):
When the blank page appears, try a refresh ( the Lightning bolt not the browser's)..Sometimes ths SP does not complete its work when the report asks for the data, so Oracle returns the data as it exits at the time of the request and since your SP dynamically creates the records, they may not be there then.
Just a thought...

 

[hal999]

Ok, thanks, we've been running these reports in CE or equivalent since v6, the data is there, it's either a configuration problem or a bug in CE 10, it returns the data in the viewer for a few users but when it is hit hard it stops responding, we are back on 8.5 until we resolve this and they are running fine again, it is not Oracle, but thanks.