Princy, You might want to check the qualification in the table fields and optimize those so there are no table scans and the queries make use of available indexes.
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Princy Sent: Sunday, June 20, 2010 2:23 PM To: [email protected] Subject: Performance issues with BMC AR Server 7.1 Hi All, We are facing lot of performance issues with the Remedy Server, which is making it very slow to access. Found in other posts that the "Refresh On Entry Change" option if enabled is the cause for most of the performance degradation issues. And on incidents form, for most of the tables this option is enabled. Would like to know if disabling this option would increase the performance. Another issue we are facing is that few users (with Admin permissions) when access the system, they find it fast. But other users like problem engineer/service desk user when access the system, it is very slow and unusable. Could some one please throw light on this issue? Thanks. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
