Shyam, Try taking a SQL log and check the queries that are run by the plugin over the different tables when the console is opened. That should give you answers to fields that may be used in the queries after the where clause to check if they all have been indexed.
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Shyam Attavar Sent: Wednesday, January 20, 2010 2:42 AM To: arslist@ARSLIST.ORG Subject: Performance improvement in Overview Console ** Dear Listers, We are on ITSM 7.1.0 and are wondering if any of you have seen performance issues using the overview console. We have a situation where some of our users are members of multiple (12 - 20) groups and when they launch the Overview Console, the table field takes over a minute to load all the tickets for all the groups that the users belong to. I realize that the table field is pointing to an OOB plugin and I am not sure the details of the plugin are readily available. Does anyone out there know the details of the plugin and related details that may help answer the following questions: a.. The fields used in the plugin to pull the data from mulitple groups - is that based on Assigned Group Name or Assigned Group ID, so that we can index the appropriate fields. b.. Incident form already has 15 fields indexed. So, the insert/update performance maybe less than ideal. Any experiences with having more than 15 fields with index on the Incident form? c.. Have any of you indexed the Group Name fields on the underlying forms that provide the data to the Overview Console and the associated performance impact for seraching/inserting/updating? d.. What other considerations would be useful for improving the table field data load performance? ITSM 7.1 Patch 6 on ARS 7.1.0 Patch 6 on RHEL Oracle 10gR3 on RHEL Thanks in advance, -- Shyam _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
