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 <anandsagar....@bt.com>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: > arslist@ARSLIST.ORG] *On Behalf Of *Longwing, Lj > *Sent:* Wednesday, June 26, 2013 6:15 PM > *To:* arslist@ARSLIST.ORG > *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 <kiranpatil....@gmail.com> > 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 <frexp...@yahoo.fr> 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_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
