Server web browsing slow

[Former Member]

Is there a set of instructions for how to performance tune the Crystal Server (2011) web and other services?  Im running on a pretty fast server, no other activity, memory 3GB free out of 12GB, yet i can wait for up to 30 -60 seconds navigating the web pages.  Maybe the repository itself needs tuning?  any guidance would be greatly appreciated.

[former_member191664 · Accepted solution]

"i can wait for up to 30 -60 seconds navigating the web pages."

Normally, when the web page rendering takes time to complete and your web application server, e.g. tomcat6/7, is running fine without CPU spiking and RAM is plenty, you might need to check

- CMS repository database.  The reason is that the CMS sends the SQL queries to CMS database to extract the folder/object list and then Tomcat/Java web server use that compiled list to render the web page to display on the user's browser.  Thus, if the backend database has bottleneck, the performance, the turnaround time, and the user experience suffer.

Note that

- Check out SAP KB 974781 - Oracle internal maintenance jobs on http://service.sap.com/sap/support/notes/974781 for Oracle tuning,

- you can add -maxobjectsincache 250000 to keep up to 250,000 in CMS cache; thus, to reduce the amount of CMS query by keeping as many objects in CMS cache.  However, the improvement is marginal.

- Check out the CMC -> Servers -> CMS, Metrics and find out the following.

Average Commit Response Time Since Startup (msec)

Average Query Response Time Since Startup (msec)

Longest Commit Response Time Since Startup (msec)

Longest Query Response Time Since Startup (msec)

You want to keep "Average Query/Commit Response Time Since Startup" as low as possible by squeezing any juice out from your CMS database.

- Check out What is the optimal configuration for Platform Search in BI4.x? on http://scn.sap.com/community/bi-platform/blog/2013/06/21/what-is-the-optimal-configuration-for-platf... to minimize the impact from the platform search to avoid it clocking your BI server.

- Separate CMS and Auditing databases

At last, you can tune up Tomcat6/7 web.xml for each deployed application with nocache to false (it means yes, cache), delay and prevent tomcat from compiling and loading the JSP and servlet at run time to reduce the tomcat memory usage and in turn to improve the tomcat performance, and/or separate static/dynamic content by using Apache web server with Tomcat if you find web server is the bottleneck.

Hope this helps,

Jin-Chong

[Former Member · Accepted solution]

Thanks for the tips, Jin-Chong.  I will try and report back later.

here are the metrics for the CMS...anything look funny?  seems like thats a lot more queries than i would expect - the server was rebooted just last Friday.

Common Server Metrics
Machine Name	xxxx
Name Server	xxxx
Registered Name	xxxx
Operating System	Windows Server 2008 6.1
CPU Type	AMD64
CPUs	2
RAM (MB)	12,287.492
Local Time	Tuesday, September 16, 2014 12:43:30 PM EDT
Disk Size (GB)	99.997
Used Disk Space (GB)	76.022
Version	14.0.4.738
Start Time	Friday, September 12, 2014 3:46:37 AM EDT
PID	5084
Host Name	xxxx
Host IP Address	xxxx
Request Port	49371
Busy Server Threads	1
Auditing Metrics
Current Number of Auditing Events in the Queue	1
Logging Service Metrics
Logging Directory	xxxx
Central Management Service Metrics
Connection to Auditing Database is Established	1
CMS Auditor	1
Auditing Database Connection Name	Crystal_Server_Auditing
Auditing Database User Name	srcadmin
Auditing Database Last Updated On	Tuesday, September 16, 2014 12:42:34 PM EDT
Auditing Thread Last Polling Cycle Duration (seconds)	180
Auditing Thread Utilization	0%
Clustered CMS Servers	xxxx
Number of Sessions Established by Concurrent Users	3
Number of Sessions Established by Named Users	0
Peak Number of User Sessions Since Startup	4
Number of Sessions Established by Servers	8
Number of Sessions Established by All Users	3
Failed Jobs	158
Pending Jobs	69
Running Jobs	0
Completed Jobs	1876
Waiting Jobs	0
Concurrent User Licenses	5
Named User Licenses	5
Build Date	2012/06/11:18:38:06
System Database Connection Name	Crystal_Server
System Database Server Name	xxxx;crystal_server;microsoft sql server;10.50.4033
System Database User Name	srcadmin
Data Source Name	Crystal_Server
Build Number	738
Product Version	14.0.3
Resource Version	14.0.3
Average Commit Response Time Since Startup (msec)	4
Average Query Response Time Since Startup (msec)	4
Longest Commit Response Time Since Startup (msec)	7509
Longest Query Response Time Since Startup (msec)	44144
Number of Commits Since Startup	243333
Number of Queries Since Startup	1837255
Number of User Logons Since Startup	75
Established System Database Connections	14
Currently Used System Database Connections	0
Pending System Database Requests	0
Number of Objects in CMS System Cache	6486
Number of Objects in CMS System DB	11505
Existing Concurrent User Accounts	10
Existing Named User Accounts	1

also am seeing errors in the event viewer, may be related?  Cannot write to cache folder F:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\Data\\CrystalReportsCachingServer\temp\xxxx.CrystalReportsCacheServer\parent\cache. This indicates a high request volume for the configured size of the cache. This problem can be solved by increasing the size of the cache.

[former_member191664 · Accepted solution]

1. Judging from the "Number of Objects in CMS System Cache=6486 and Number of Sessions Established by All Users=3", your BI4.0 SP04 (14.0.4.738) is a relative small system.
2. The "Average Query/Commit Response Time Since Startup=4" is excellent; however, the "Longest Query Response Time Since Startup=44144", which is a bit high, indicates that your CMS database SQLServer has some spike in turnaround time and can be tuned for optimization.
3. You can increase the "System Database Connections" to 50 from default 14 and see if this will give you marginal improvement in CMS queries turnaround time.  Note that is it odd that your "Used System Database Connections=0".
4. Since you are on BI4.0 SP04 (see Business Intelligence platform 4.0/4.1 and Crystal Server 2011/2013 - Version Information  on http://scn.sap.com/docs/DOC-31812), you may want to check out the release notes from BI4.1 SP03 and SP04 for the performance improvement over yours.
5. Increase CrystalReportsCacheServer's "Maximum Cache Size" to 1GB or more per instruction from event viewer's error.
6. Check out the 156 Failed Jobs from Instance manager to see what kind of job error(s) are there.

Hope this helps,

Jin-Chong