SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Database Mail limitations in SQL Server 2012
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

paulaAnca
Starting Member

Canada
1 Posts

Posted - 02/03/2014 :  16:05:20  Show Profile  Reply with Quote
Hello,

I have a problem with my client, who want to passe from Lotus Notes App to SQL Server/.NET App and want to use Database Mail for sending massive number of mails (over 5000 mails, in one shot, in asynchronous processing). I don't have a dedicated production server for this specific application and I don't want performance problems. Just help me with some infos for Database Mail limitations (or SMTP limitations) and performance impact. I need proofs that this is not a good ideea, use SQL Server for sending thousand of mails. Or this is ?
Thanks all !
Paula

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1677 Posts

Posted - 02/04/2014 :  18:10:49  Show Profile  Reply with Quote
Database Mail doesn't actually send any emails; it just defines an interface to an SMTP account. It seems odd to take emails out of an email application, send them to a SQL server so that they can be sent back to an email service. It's not what SQL SErver was made for. Having said that, it doesn't seem that Lotus Notes was made to send emails either. We use it here and we hate it.

===============================================================================
There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber (1894-1961)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000