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 * _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
