You know...I had all of these same problems - but on Solaris with a remote Oracle database. While I doubt you are having the same problem (CLOB's needed to be changed to in-row storage) the real clue was seeing large gaps in the log files where absolutely nothing happened. On the other hand, we also had a bunch of problems with the Java plug-in server running and generally messing stuff up. The Java plug-in server is not needed in 7.1 (unless you are using the SLM Data Collector or some custom stuff) - you may want to comment it out of the armonitor.cfg file. Beyond that - we still get occasional 91/92 errors, and they are usually network related.
William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Gadgil, Abhijeet Sent: Monday, May 25, 2009 1:01 PM To: arslist@ARSLIST.ORG Subject: Re: Performance Tuning ARS 7.1 ** Tempdb is a ala temporary tablespace in sql server. AR installer does not create this. When SQL Server is installed the setup program creates tempdb database. Tempdb is a system database used by SQL Server to store temporary tables and temporary stored procedures, for sorting, subqueries, and aggregates with GROUP BY, ORDER BY, for cursors and so on. Tempdb database contains only temporary objects, so if you want to create a permanent object, do not create it in the tempdb database. Regards, Abhijeet ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Robert Molenda Sent: Saturday, May 23, 2009 6:47 PM To: arslist@ARSLIST.ORG Subject: Re: Performance Tuning ARS 7.1 ** We have been experiancing random ARERR 92 / 8939's at several custom locations - generally a restart of ARS clears the issue - this is occuring on multiple 7.1 patch versoins. Since this is the 'tempdb' and not ARSystem - I am curious as to what ARS would be doing in the tempdb - guess I need to enable profiler and check the activity... One question - is what is the transaction logsize of tempdb? is it attempting to grow (and grow)?? I will pass this 'tip' on to my team(s) for them to try at a few customer locations just to double check... Robert Molenda On Thu, May 21, 2009 at 11:43 AM, Leonard Nelson <leo.nel...@gmail.com> wrote: Hello All We just launched ARS 7.1 two weeks ago. Things have been running fairly well until last week when we started to see the error "ARERR 92 Timeout during database update -- the operation has been accepted by the server and will usually complete successfully : server.com <http://server.com/> " With BMC guidance we increased the tempdb size from an initial 8MB to 1GB. The ARERR 92 error appeared to be resolved until earlier this week when we started seeing error "ARERR 382 The value(s) for this entry violate a unique index that has been defined for this form : HPD:Help Desk entry:INC000000008832 fields: " and error "ARERR 8939 The AR System Plug-In server is not responding. Cannot connect to the system at this time. Contact your AR System Administrator for assistance. : RPC: Timed out" I suspect that ARERR 92 and ARERR 382 are related, so earlier this morning I increased the tempdb size from 1GB to 5GB. This appears to have resolved these errors. However, I'm not sure if ARERR 8939 is related to this issue but restarting the arplugin.exe process appears to have resolved this issue. Our AR server is running on a Windows 2003 server R2 with 8GB RAM and the database backed is SQL 2005 running on a similar server. I'm curious if anyone else has encountered similar issues and what recommendations people have for improving performance of a system. Clearly, we are learning some new ways of tuning our system, so any tips would be greatly appreciated. Leo ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> Platinum Sponsor:rmisoluti...@verizon.net <mailto:sponsor%3armisoluti...@verizon.net> ARSlist: "Where the Answers Are" -- If it were not for the gutter, my mind would be homeless! _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"