I read this email a minute after replying to your other one... select top 20 schemaid, nextid, name from arschema where nextid > 10000 order by nextid asc;
is likely to give you a list of top 20 tables that have a record count of more than 10000 (unless you have deleted in some and not reset the nextid) Increase 20 to 30 in case you see that the 20th table has a significantly large number of rows. Look at all the searches that happen on all these tables, and see if any of the searches are not optimized by way of searching a non indexed field.. Joe ________________________________ From: Tim Rondeau <timothy.rond...@phaseforward.com> To: arslist@ARSLIST.ORG Sent: Friday, October 2, 2009 10:18:34 AM Subject: Re: Performance Issues with 7.1 Patch 7 ** Everyone I don’t think it actually was email. I think the email errors, just because DB was too busy. Anyone have any other issues with the DB with this patch on windows? Thanks Tim From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rodriguez, Rafael J x23718 Sent: Friday, October 02, 2009 9:54 AM To: arslist@ARSLIST.ORG Subject: Re: Performance Issues with 7.1 Patch 7 Email ** Tim as per BMC's recommendation for performance tunning for email engine, please check the following setting in your emaildeamon.properties file and make the neccessary changes. You will experience a HUGE performance boost. Change the following entries in the emaildeamon.properties file from 100 to 200: com.remedy.arsys.emaildaemon.IncomingConnectionRecycleSize=200 com.remedy.arsys.emaildaemon.IncomingMessagesQueueSize=200 com.remedy.arsys.emaildaemon.OutgoingConnectionRecycleSize=200 com.remedy.arsys.emaildaemon.SendEmailSetSize=200 Also change the following line item from true to false which will force email polling to seconds from Minutes. com.remedy.arsys.emaildaemon.MailboxPollingUnitIsMinutes=false ________________________________ From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tim Rondeau Sent: Thursday, October 01, 2009 11:13 PM To: arslist@ARSLIST.ORG 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"_ This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"