Quick response - Some first things to check/try
1. Is your reporting server on a separate machine from your application server? If not, can it be moved? 2. Do you have any scheduled reports that are running during peak hours? If so, can they be moved to off-hours? 3. Do you have any reports that are running large, non-indexed queries? If so, can the queried fields be indexed? Check Remedy docs for "database tuning" - this has had had excellent coverage of reporting issues previously. On Wed, Feb 3, 2016 at 2:04 AM, Abhishek Anand <abhi.masc...@gmail.com> wrote: > Hi Team, > > We are facing a major issue with the AR/Web Reporting as both are > impacting the server performance. > Also we are on 8.1.02 and please suggest that how can we fine tune it and > improve the server performance without impacting the reporting. > > Early response will be highly appreciated. > > Cheers, > Abhi. > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > -- Kelly Logan Senior Consultant Rapid Technologies, Inc. <http://www.raptek.com> Office: 313-651-7169 Cell: 313-645-4552 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
