Tim, How many records on are on the email messages form? Kevin Begosh, RSP Remedy Development ACE-IT IS&GS Defense 301-791-3540 Phone 240-291-2467 Cell kevin.beg...@lmco.com
From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tim Rondeau Sent: Thursday, October 01, 2009 10:16 PM To: arslist@ARSLIST.ORG Subject: Re: Performance Issues with 7.1 Patch 7 Email ** Joe, Looking at it now, I don't think it was email. I think the errors in the log because database was too busy. Do you have 7.1 patch 7, we are running on windows? Seen any performance issues. Tim From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Friday, October 02, 2009 12:02 AM To: arslist@ARSLIST.ORG Subject: Re: Performance Issues with 7.1 Patch 7 Email ** Tim, If the unprocessed emails in that form are not really important, then I would suggest to truncate the T64 and H64 and the email attachment tables T H and B table.. and the other relationship tables Then once you have the ball rolling again, make sure that a new email after being processed is being auto deleted. I do not remember offhand if its an escalation that deletes it periodically or if a filter deletes it after having processed the email. But whatever it is - if it fails to delete, you need to look into why. Maybe your error logs would tell you something? Joe ________________________________ From: Tim Rondeau <timothy.rond...@phaseforward.com> To: arslist@ARSLIST.ORG Sent: Thursday, October 1, 2009 11:12:48 PM Subject: Performance Issues with 7.1 Patch 7 Email ** Running 7.1 patch 7 and noticing slowness which really brings remedy to a hault. The table is T.64 which is AR SYSTEM Email Messages. Anyone have performance issues with this version. Thanks Tim _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"