Vaibhav has provided the correct must have Overview performance hotfix.. However you need to check the people record of the users and based on the application permission they have, you need to correct the application preference record.. By default it has "Yes" for all the application under Overview Console...
Check out this KA369356 for the hotfix. Example: If a user has only Change User Permission.. he should not be interested for SRM, Asset, Proble, Release, Incident.. We highly recommend you to set "No" to all unwanted application in the overview console through application preference settings.. 90% of the overview performance issues are resolved with this configuration, as Remedy perform a table scan when they open the overview console... Hope this helps. Regards, Kunal Thanks, Kunal. On Tue, Feb 5, 2013 at 3:51 AM, vaibhav wadekar <wadekar.vaib...@gmail.com>wrote: > ** > > conquery.jar > > ITSMCommonUtils.jar > > These are multi-threaded versions of the existing jar files so these need > to replace the existing ones located in the "pluginsvr\qry" directory (i.e. > C:\Program Files\BMC Software\ARSystem\pluginsvr\qry. > > You can test by extracting patch 04 installer and put this jar to your > system to see if the problem resolved. > > Regards/Vaibhav > > > On Mon, Feb 4, 2013 at 1:58 PM, ravi rai <ravira...@hotmail.com> wrote: > >> ** >> Kathy, >> Check with BMC Support. we faced this in 7604 SP2 and there was issue >> with Overview console. >> Overview console was single threaded. They provided a Jar file fix for >> the same >> >> >> Ravi >> >> >> ------------------------------ >> Date: Mon, 4 Feb 2013 13:52:12 -0800 >> From: remedyr...@gmail.com >> Subject: Re: Critical: Server Hung >> To: arslist@ARSLIST.ORG >> >> >> ** >> Kathy, how many rows are in the table referenced by the console? I've >> seen this happen in some versions where the form doesn't get cleared, and >> the SQL queries bog the system down. >> >> Rick >> >> >> On Mon, Feb 4, 2013 at 1:50 PM, Kathy Morris <kathymorris...@aol.com>wrote: >> >> ** >> >> Hi,**** >> >> ** ** >> >> AR System 7.6.03 **** >> >> ITSM 7.6.04 SP1. **** >> >> ** ** >> >> The incident management console hangs and hoses the system when users >> access the Incident Management Overview console.**** >> >> My understanding is that thru a row-level access query, users see the >> incidents for the group they are member of.**** >> >> If users are a part of many groups, however this can cause problems.**** >> >> How can we prevent this query from crashing the system to the point where >> our database is unresponsive.**** >> >> Are any others experiencing this performance issue?**** >> >> Any ideas on what we can do to get our system to a stable state?**** >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
