Shawn, Have you checked your Escalations that might be designed to run on Monday mornings? Check these and check the queries and actions defined on these. They may be running bad queries on large tables or queries that use fields that are not indexed. Check the queries in both the Run If conditions as well as the Set/Push field if conditions not just on the Escalations but also on filters that might fire as a result of these Escalations.
Other than this your guess that there might be a user or a group of users issuing bad queries is also a good guess. API logging might also yield some useful results on operations taking longer to complete. Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Shawn Stonequist Sent: Monday, October 22, 2007 10:40 AM To: arslist@ARSLIST.ORG Subject: View Thread ID Details? Greetings List!! I'm wondering if there is anyway that can be used to view specific thread IDs. I ask because it seems every Monday, between 8am & 10am, our ARServer slows significantly. We've held off doing various "Monday Morning" reports & backups, but without any improvement. Our DB believes that the issue is being caused by a thread, but can't tell which one. I ran our "Thread Logging" in the System Config, but I only got ID's and when they started (2, but only just after we received the complaint about the Server's performance). Unfortunately, this log doesn't say *what* these threads were doing. It is my hope that, by finding out what these threads are doing (even if I have to start the Thread Logging on the previous Friday, weekends are low-to-no activity anyway) we can determine what is causing this issue- errant search? user with a bad query? automated system? etc. Huge thanks in advance to all!!! Shawn Stonequist Remedy 6.3 EMNS No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.5/1085 - Release Date: 10/22/2007 10:35 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
