Have you looked into Transactional Replication at the database level? This could be configured to give you near real-time reports. If you don't need near real-time reports replication could be scheduled off hours. This will pull all reporting off the production server, which will improve performance.
If you want to archive old data off the system then there are a number of db tools out there that can do that or your dba should be able to write some stored procedures to handle that. I would say keep data on the production and report server for the audit timeframe and archive everything else off, so if you are required to keep the last 3 years worth of data, keep that on production and your report server and archive everything else. If there is no use for the data you may decide to scrap it all together. Less face it tickets on Windows 95 and solutions are probably not useful to anyone, so why keep them or archive them. You can also limit the number of records returned in a search and turn off unqualified search capabilities. This should also prevent large searches from slowing down your production server. In addition, there are a number of performance tweaks you can do to the systems. I think if you archive too frequently you may lose some of your ability to tap into some useful information on your system. You would force your users into searching for data in multiple locations, which could slow down their response/resolution time to their customers. Brian From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Hari Vishwakarma Sent: Monday, February 13, 2012 1:33 PM To: [email protected] Subject: How to create an archival server in remedy in windows platform!!! ** Hi All, I want to create an archival server which will offload my production server load & improves my production server performance Can anyone suggest what are all the prerequisites for the required archival server.And what need to be kept in mind while configuring this. Also will it require any short of customizations for achieveing an archival server. Please suggest to achieve the same. -- Best Regards, Hari shankar Vishwakarma Mobile:- +91-9833675872 E-mail:- [email protected] _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
