That’s a normal count.. What I meant by high water mark is not the actual record count. It has very little to do with the record count but more to do with insert transactions on that table. Insert transactions continuously raises the water mark on a table, and deletes does not drop it. So on high transaction tables where there are high number of insert and delete transactions, it’s a good idea to keep a periodic eye on the HWM of that table..
Just something you might want to check on as you may possibly be running short on disk space where that table resides.. Joe From: Boyd, Rebecca Sent: Monday, October 10, 2011 10:12 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re: Server Slow Down ** So, I have 364 records in CAI:Events and 3,353 records in SYS:Action. I take it this is not a good thing? On Mon, Oct 10, 2011 at 6:56 PM, Schon, Stuart <[email protected]> wrote: ** Check the CAI Event table for a stuck record, I have seen that as an issue several times leading to the plugin being unable to start. It should be empty. Any record there is transitory like sys:action Stuart Schon Team Leader Fujitsu Australia Limited 2 Julius Avenue, North Ryde NSW 2113, Australia T +61 2 9113 9435 M +61 458 592 245 [email protected] au.fujitsu.com From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe Martin D'Souza Sent: Tuesday, 11 October 2011 06:04 To: [email protected] Subject: Re: Server Slow Down ** So although the SYS:Action table has workflow to delete the processed records that are no longer needed on that table using as in that example, Application-Delete-Entry "SYS:Action" 000000000407386, it has no way to lower the high water mark caused by the continuously growing table.. Over time that table is likely to occupy a lot of disk space although the number of entries in the table may be quite low. I’m guessing that may be one of the problem. Ask your DBA to check into that and see if that’s the problem’.. Joe From: Boyd, Rebecca Sent: Monday, October 10, 2011 2:52 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Server Slow Down ** Everyone, I recently had an issue where performance became very poor and didn't learn about the problem in time to capture any logs. However, I saw the following repeated in the arerror.log: 390620 : The AR System Plug-In server is not responding. Cannot connect to the system at this time. Contact your AR System Administrator for assistance. (ARERR 8939) Failure during an attempt to perform an application command (ARERR 4554) Application-Delete-Entry "SYS:Action" 000000000407386 ARS 7.5.00 Patch 003 ITSM 7.5.01 patch 001 SLM 7.5.00 patch 001; SRM 7.6, patch 2 Windows 2008 Enterprise Oracle 11g Any ideas of what was happening or where to look should this happen again? -- Rebecca Boyd Application Administrator Wake Forest University _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ -- Rebecca Boyd Application Administrator Wake Forest University _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
