Brandi,
You have a series of private queues listed, but I don't see any indication what the fast and list queues are set to. Do you have everyone on private queues? If folks are running reports that have a query that takes a bit of time, they tie up that thread until their results come back. No-one else can use that thread until theirs is complete. So to the users, the system is hung while it's actually working. I've had similar situations before (granted on an Oracle db) and had to look at the Remedy logs in conjunction with a DBA looking at what is happening in the database. Hope this helps some From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Brandi Barbour Sent: Tuesday, November 24, 2009 6:02 PM To: [email protected] Subject: Process Hanging ** All, We have our production server that has been hanging for about a month now. I have been working with support to figure it out but as of yet we have not found the underlining issue. So I am hoping someone else has seen this problem. ARS 7.1.0 ITSM 7.0.3 SQL 2005 on remote server Windows 2003 We turned on and configured SLM and about or right at that time our system became slower and it started hanging up. The arerror.log only shows the following: Tue Nov 24 16:25:15 2009 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Nov 24 16:25:15 2009 0xc00000fd Tue Nov 24 16:25:15 2009 390635 : AR System server terminated -- fatal error encountered (ARNOTE 21) in the arthread log it shows: <THRD> /* Tue Nov 24 2009 10:52:12.5620 */ Thread Trace Log -- ON (AR Server 7.1.00 Patch 002 200802011900) <THRD> /* Tue Nov 24 2009 14:04:27.7550 */ Thread Id 1936 (thread number 24) on LIST queue died. <THRD> /* Tue Nov 24 2009 14:04:27.7550 */ Thread Id 1904 (thread number 24) on LIST queue restarted. <THRD> /* Tue Nov 24 2009 14:05:19.9140 */ Thread Id 3420 (thread number 38) on FAST queue started. Always a LIST queue that dies; We have increased threads: Private-RPC-Socket: 390601 1 1 Private-RPC-Socket: 390603 2 2 Private-RPC-Socket: 390620 12 20 Private-RPC-Socket: 390626 2 3 Private-RPC-Socket: 390635 12 20 Since we have 4 processors (well really 2 with 2 core) The Filter-Max-Total was changed since we have the ITSM suite. Filter-Max-Total: 500000 Filter-Max-Stack: 10000 I have changed any Custom escalations that may have some sort of hit on the system to either in off hours or to at least less frequent. Now the problem seems to be anytime we have someone run a report or what most likely is happening is 2 people are running reports the system hangs. The user tool hangs up and the process for arserver.exe has a memory usage of either over 800,000K or just under that. The actual service does not stop however you can not do anything until the service is restarted. As this is a fairly new system it now has more users then ever and more actions are being taken. However with it crashing around 6 times a day it is not useful. Turning on SLM may be just a coincedence however we have a lot of Service Targets. Has anyone seen this and the memory usage going that high? Support wants me to limit the search to 1000. But we have way more that many tickets in one day and Management will not allow that to happen. Any help would be appreciated. Brandi _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
