Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
paulaAnca
Starting Member
1 Post |
 Posted - 2014-02-03 : 16:05:20
|
| 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
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-02-04 : 18:10:49
|
| 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) |
 |
|
|
|
|
|
Database Mail limitations in SQL Server 2012