Craig, I would suggest cleaning those out, as each time your email process polls the mailbox, it has to go through 1.5m email records to see which ones have not yet been sent. This is extra taxing on the database.
Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Craig Carter Sent: Thursday, July 10, 2008 8:06 AM To: arslist@ARSLIST.ORG Subject: Re: Baffling Email Problem Jackie, I'd be interested to hear more about your "... all kinds of problems" statement since we've always saved all sent messages so we know what is being communicated to our customers. We currently have 1,458,000 emails in our Email Messages form and the only problem we've encountered is slower search time when searching that form. Although I've selectively deleted groups of messages in the past (like bounced notifications back to agents), it's not been enough of a slowdown yet to automatically archive them. We're on v7.0.1P5 using SQL Server 2005 Enterprise. //SIGNED// Craig Carter Software Engineer, RSP -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Thursday, July 10, 2008 6:45 AM To: arslist@ARSLIST.ORG Subject: Re: Baffling Email Problem Yes, I understand that messages can be configured to be deleted after they are sent. They are and have been configured to *not* be deleted when sent. Sorry, I considered that a given in my original post. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jackie Morris Sent: Thursday, July 10, 2008 7:22 AM To: arslist@ARSLIST.ORG Subject: Re: Baffling Email Problem ** You never answered the question of whether you were deleting the message after it was sent. You can send the message, query the Message Form and still not see it because it went out already. Most times, in our environment, its that fast. Change it to save the message, restart the email engine and then see if you find the message. Just don't leave it like that for an extended period. Too many messages in the message form can cause all kinds of problems. Jackie Easylink Services Corporation 732-652-3611 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser Sent: Wednesday, July 09, 2008 6:18 PM To: arslist@ARSLIST.ORG Subject: Re: Baffling Email Problem ** Did you change your Default Outgoing Mailbox setting for the mailbox you are trying to use? Is it enabled (although that wouldn't keep the messages from getting to Messages form) Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach Kaiser Norm E CIV USAF 96 CS/SCCE <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 07/09/2008 02:11 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Baffling Email Problem ** Hello everyone: Here's something you don't see every day. For some reason, a Remedy server of a site I support cannot find its AR System Email Messages form! The system has about 12 filters that each generate a notification based on ticket status changes. What's weird isn't that the notifications aren't going out-it's that the notifications never get created in the Messages form. It's like the filters generating the notifications are just skipping the notification action. Anyone seen this before? ARS 6.3 patch 21 Windows 2003 Microsoft SQL 2003 Thanks, Norm __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"