Can a SQL implementation REALLY be set up? Is there a step by step document somewhere that explains it? We tried to do the SQL, but, we were unsuccessful.
Tim Davis DBA/Network Engineer Teksolvers, Inc ----- Original Message ----- From: "Phillip B. Holmes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 25, 2002 3:56 PM Subject: RE: Re[2]: [IMail Forum] SQL & IMAIL Yes. The traffic is minimal. I have implemented many of those fixes on my own. I am probably going to split it off that server today unless Ipswitch comes up with another solution. An ODBC trace was going to be my next step. Respectfully, <cf_developer> Phillip B. Holmes Media Resolutions Inc. Macromedia Alliance Partner http://www.mediares.com [EMAIL PROTECTED] 1-888-395-4678 ext. 101 972-889-0201 ext. 101 </cf_developer> /* Please send support requests to [EMAIL PROTECTED] */ -----Original Message----- From: [EMAIL PROTECTED] [mailto:IMail_Forum-owner@;list.ipswitch.com] On Behalf Of Sanford Whiteman Sent: Friday, October 25, 2002 2:29 PM To: Phillip B. Holmes Subject: Re[2]: [IMail Forum] SQL & IMAIL > I'm dealing with Ipswitch now. I am confident this is a bug in the > ODBC component of Imail. You're going to have to put a lot of controls in place to establish that. With SQL on the same box, you must make sure that: - You fix the memory allocation for SQL - You give SQL its own disk(s) - You use indices wherever possible - Your DSN uses the Shared Memory Net-Library - You experiment with fiber mode for lowest resource consumption by SQL (this can sometimes have opposite effects) Running ODBC traces and PerfLogs will also help you isolate the problem. Be aware that, IMO, a known "limitation" of IMail's ODBC connector in that it isn't self-tuning for local DBs is not a bug per se. You also haven't mentioned (or measured?) your usage volume and patterns, which makes it hard to say what else is happening at noon. -Sandy To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
