Kali, The other thing to consider is if you are running these queries during peak production hours on your transactional DB (where users are submitting/modifying/querying data using Remedy AR web/user tool). We are currently in process of creating a "reporting DB" which is using DB level replication technologies to create a mirror DB. At that point, Analytics would be reconfigured to query the mirrored instance and taking the load off the production transactional DB.
Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Monday, May 03, 2010 9:42 AM To: arslist@ARSLIST.ORG Subject: Re: BMC Analytics/Dashboard Performance with ITSM 7.6 BMC Analytics uses Business Objects which connects directly to the database, bypassing the ARS layer. Therefore, you should use any database tools available to you to analyze and correct performance issues... Guillaume ________________________________ From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Kali Obsum [kali.ob...@macquarie.com] Sent: Friday, April 30, 2010 5:19 AM To: arslist@ARSLIST.ORG Subject: BMC Analytics/Dashboard Performance with ITSM 7.6 ** Hi, Has anyone encountered any performance issues with BMC Analytics/Dashboard if it connects to an ARS Server 7.5 DB that has a large size? Is there a point when ARS Server 7.5 DB reaches a certain size that will cause slowness in generating reports using BMC Analytics/Dashboard? Thanks! Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ********************************************************************** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"