Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

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

Starting Member

1 Posts

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

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 !

Bustaz Kool
Flowing Fount of Yak Knowledge

1834 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  
 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.03 seconds. Powered By: Snitz Forums 2000