I have noticed the databse being busy errors even when you have search related problems on large forms due to either indexing or just that the form has so many records that unqulified searches has that thread crawling...
Currently I am already on 7.5 How many records in your email message form? select count(*) from T64; should give you that result without causing a performance hit on the db as it reports that number from the statistics.. Joe ________________________________ From: Tim Rondeau <timothy.rond...@phaseforward.com> To: arslist@ARSLIST.ORG Sent: Friday, October 2, 2009 12:16:00 AM 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"