First and foremost check your log files to see what may be going on.. Having said that here are a few tips to check certain things that could reduce your performance to the level its at..
Check the size of the transaction log file, and flush it. SQL server 2000 onwards does manage it automatically, with auto growth enabled, but maybe something is choking it? Make sure the disks where the log and data files of the AR System database reside have a healthy amount of free space.. Also check your disk space on the AR Server, sometimes log files if enabled and left enabled can grow large enough to fill up the disk, and this can choke the AR Server as it does require a significant of free disk space to run.. Hope this helps.. Cheers Joe From: LJ LongWing Sent: Tuesday, April 05, 2011 9:55 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: 7.6.4 Upgrade ** Rafael, I recommend turning on API/Filter/SQL logging on the server and analyzing the timings of each call with something like AR Workflow Analyzer…it’ll tell you what api/sql calls took the longest and you can analyze from there to find out why…..the message in general just means that the client asked for a process and the server took longer than 2 min’s to respond….that’s ALL it means…it’s up to you to figure out why it took so long. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rodriguez, Rafael J x23718 Sent: Tuesday, April 05, 2011 7:14 AM To: arslist@ARSLIST.ORG Subject: 7.6.4 Upgrade ** Hello list, I have recently upgraded to 7.6.4 from 7.5 Patch 7. Now when I try to submit I get the following timeout message: ARERR [92] Timeout during database update -- the operation has been accepted by the server and will usually complete successfully NOTE: The request does get created but I keep getting this. Has anyone experience this? ARS: 7.6.4 Server: Win 2008 DB: SQL 2008 Rafael _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"