My first question is, Which system is having the cpu hit 100%? If it is the db then indexes should help. If it is the application server then you have either too much data being sent back or too much workflow firing on all the records.
I would first check to see how many records you have in the table. Second I would look into the query. What is calling it, and why does it have C8 = N'BR-CHK-CONFIG' as part of the qualification. I am concerned initially about the N being outside the quotes. I would also run the query against the db directly and see how long that takes and how many rows it is returning. HTH, Brian Goralczyk On Wed, Jan 22, 2014 at 4:03 AM, Carl Wilson <[email protected]> wrote: > ** > > Hi, > > I would verify the indexes that are present on Application Pending form to > ensure that the field 'C501' has an index. > > Also, you may want to check the number of records in this form and delete > entries that are not required (by default, processed records should be > removed). > > > ------------------------------ > > > > Kind Regards, > > > > *Carl Wilson* > > > > http://www.missingpiecessoftware.com/ > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Jennifer Varkey > *Sent:* 22 January 2014 06:59 > *To:* [email protected] > *Subject:* Re: CPU utilization sometimes goes upto 100% > > > > ** > > sorry, i missed the server details; > > ARS/ITSM/RKM 7.5 on Windows 2k8 > > RAM is 12 GB. > > > > The databse is SQL 2k8 on another separate machine, having 12 GB RAM. > > > > On Wednesday, 22 January 2014, 12:24, Jennifer Varkey < > [email protected]> wrote: > > > > Hello All, > > > > In my SQL logging each of the following statements are taking over 4 hours; > > > SELECT T8.C1 FROM T8 WHERE ((T8.C8 = N'BR-CHK-CONFIG') AND (T8.C501 = > N'SG-Check-Config')) ORDER BY C1 ASC > SELECT T8.C1 FROM T8 WHERE ((T8.C8 = N'BR-CHK-CONFIG') AND (T8.C501 = > N'SG-Check-Config')) ORDER BY C1 ASC > SELECT T8.C1 FROM T8 WHERE ((T8.C8 = N'BR-CHK-CONFIG') AND (T8.C501 = > N'SG-Check-Config')) ORDER BY C1 ASC > SELECT T8.C1 FROM T8 WHERE ((T8.C8 = N'BR-CHK-CONFIG') AND (T8.C501 = > N'SG-Check-Config')) ORDER BY C1 ASC > > During such time, the CPU utilization becomes very high, almost reaching > 100%. > > > > The T8 table is "Application Pending". > > > > The co-rresponding API logging (against the form "Application Pending") > does not show the same delay or lag. We ran the log files using the > arloganalyzer. > > > > The field T8.C8 is "Category" field and the field T8.C501 is "Command" > field. > > > > The category "BR-CHK-CONFIG" refers to BRIE (SLM). > > > > Could someone please help us out on why these are taking so much time and > why the CPU is going so high? > > > > Thanks and Regards, > > Sonia. > > > > _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"
