PFB my inline comments:-
Is your reporting server on a separate machine from your application
server? If not, can it be moved? Yes its a different one.
Do you have any scheduled reports that are running during peak hours? If
so, can they be moved to off-hours? Yes they are during peak as well as off
peak hours.
Do you have any reports that are running large, non-indexed queries? If so,
can the queried fields be indexed? please suggest how to check it.
Check Remedy docs for "database tuning" - this has had had excellent coverage
of reporting issues previously. Please share any link if you have it.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
