Ravi, Where do you see this recommendation? Unless you are running a sandbox or demo virtual machine, running AR and DB on the same machine isn't recommended.
Sent from my iPhone On Nov 1, 2012, at 12:30 PM, ravi rai <[email protected]> wrote: ** Vikrant You have mentioned REMOTE SQL 2008 DB. That might be the cause. Setting a remote DB is not recommended for ARS setup. There are more than 10-12 known issues and defects on reporting for SP1 and SP2 Using report cause CPU spike, Does not account maxGetList, large report generation cause out of memory error, Null pointer exception, downloading report is very slow etc etc list is very big..... You might want to check the Release doc specifically around reports. Thanks Ravi Rai > Date: Thu, 1 Nov 2012 02:38:17 -0400 > From: [email protected] > Subject: ARS 7604 Custom App and Reporting Issues > To: [email protected] > > hi Everyone, > > We are facing some issues in crystal report for one of our client. The crystal report is a call details report with about 30 fields in it which included about 10 formula fields. > > The issue we are facing is that it takes a lot of time to extract a single report and at a time we can only extract report for a time span of 30 days if we increase the time span it just gets stuck and we get nothing the user tool just gets stuck. > > The application is a complete custom application and we are not using anything OOTB apart from foundation part(people form, user form etc). > The AR architecture is such that we have only 1 application server (ARS 7.6.0.4 SP2) which is our reporting server as well. Then we have a remote SQL 2008 DB and a stand alone MT ARS 7.6.0.4. > > The configurations of the above servers is as below > > ARS/Reporting Server = 32GB RAM 100Gb HDD 2.6Ghz dual core 2 processors. > SQL or DB server = 16GB RAM 500GB HDD 2.6Ghz dual core 2 processors. > MT Server = 16GB RAM 100GB HDD 2.6Ghz dual core 2 processors. > > Now there are few things that we plan to configure to improve performance on the system and would like some opinion on the same from you guys so as to what more can be done on the same. > > Things we plan to do : > > 1) Threads and queues to be configured : Gradually increase the number of threads from the default value (not sure about the number) > 2) Indexes : To set 6-7 fields as indexes on the form on which the reports runs. > 3) Disable unwanted escalation : Don't know if this will help but will try to disable most of the unwanted OOTB escalations which we do not use. > 4) MT JVM memory check : Its already set to max = 1024 MB not sure how much can we increase it more. > 5) Check for DB side configuration : This is something new we are trying to find out things that we can configure on DB side to get better performance. > > Also we think this all infrastructure being on cloud would make a difference as well am I right? > > Thanks in advance for the replies. > > Regards, > Vikrant > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
