Brian, If you look into docs, the N being outside of the ' indicates that the string is going to be an nvarchar....one thing this indicates to me is that the query is NOT Remedy generated, but maybe a direct sql statement or something....but I'm not 100% sure.
On Wed, Jan 22, 2014 at 6:48 AM, Brian Goralczyk <bgoralczyk.w...@gmail.com>wrote: > ** > 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 <carlbwil...@gmail.com>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: >> 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_ >> _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"
