I too have a good experience with the RRR tools. Very helpful in archiving data.
Vikrant Sent from my Xperia™ smartphone Misi Mladoniczky <[email protected]> wrote: Hi, If you are on the new (blue) license model, an extra AR Server does not cost you anything from a license perspective. I have used RRR|Chive successfully to keep tables synchronized between servers. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > 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 > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
