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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
