May be I have not described the issue correctly. :) But all the recomendations are helpfull and very much appreciated. Will be replying to the recomendations as soon as I have some time and may be ask few more questions :) Have a good evening.
________________________________ De : Steve Kallestad <[email protected]> À : [email protected] Envoyé le : Mercredi 26 juin 2013 15h58 Objet : Re: performance issue ** Confio Ignite does wonders. It does the basics like recommending indexes where needed, but it also provides configuration advice and tracks down environment specific issues. There's a free trial and it getting it going is pretty quick and easy. It's good to do some simultaneous SQL Logging if you are trying to track down a particular user that's causing problems with bad queries, crazy reports, or whatnot. The purchase price is reasonable if I remember correctly, but you can really get a ton of good information out of the free trial. They also have a free real-time monitor that lets you see when problem queries and bottlenecks are hitting the db. It's one of the best tools for tracking down performance issues that I've seen. http://www.confio.com/ and http://www.ignitefree.com/ On Wed, Jun 26, 2013 at 6:43 AM, Anandsagar Sah <[email protected]> wrote: ** >Frex, > >You/your DBA need to analysis column usages from select queries for particular table to identify which columns needs indexing. There is a tool available ( http://remedyloganalyzer.com/ ) which will help you to identify this + other performance gap. > >Thanks & Regards, >Anandsagar > >From:Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Longwing, Lj >Sent: Wednesday, June 26, 2013 6:15 PM >To: [email protected] >Subject: Re: performance issue > >** >Frex, >I would recommend, as others have, getting your DBA involved (assuming you have one). The DBA can help identify queries that need indexing, and if necessary, they should be able to move these tables to another....oh what's the word...I want to use tableset, but that's not right....basically moving these tables (at the db level) to another hard drive so that queries to them don't have an IO impact on the rest of the db. > >On Wed, Jun 26, 2013 at 6:37 AM, Kiran Patil <[email protected]> wrote: >** >Hi Flex, > >Do you use BMC Analytics and does analytics has seperate db which I would say mirror or production database. >If Analytics has seperate db which is in synch with Production db then you can design schedulers to purge transactional data from production server as analytics db already will have hostorical data. > >Regards >Kiran Patil > > >On Wed, Jun 26, 2013 at 4:56 PM, Frex Popo <[email protected]> wrote: >** >Hi everyone, > >In addition to a reporting server, we have some 10 forms in a primary server with large volume of data. Adhoc AR Reports and searches are executed on the data nearly every day and this is causing some serious performance issues. >Any thought on how to resolve this? We were thinking about moving the data to a different database (thorough replication or nightly database copy) but we need either an additional server (perhaps DSO) but this will need an extra license. Enabling archiving at the form level is another option but we will still have to use the primary server and additional configuration needs to be done at the queues and thread level as well and plenty of table indexing. >Any pointer will be very much appreciated. > >BTW this is ARS7.1 > >Thank you >frex >_ARSlist: "Where the Answers Are" and have been for 20 years_ > > > >-- >Regards > >Kiran Patil >Cognizant Technology Solutions >Pune, India >Mob No: +91 989 037 7125 >_ARSlist: "Where the Answers Are" and have been for 20 years_ > >_ARSlist: "Where the Answers Are" and have been for 20 years_ >_ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
