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:arslist@ARSLIST.ORG] On Behalf Of Jennifer Varkey Sent: 22 January 2014 06:59 To: arslist@ARSLIST.ORG 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 <sonia_m...@yahoo.co.uk> 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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"