We are using SQL Server 2008 Database Mail to send emails to our website visitors. I don't know whether SQL Server sends mail one by one by picking up from the queue or it will use threads to send emails in simultaneous fashion.
If Database Mail uses threads, is there any way to increase number of threads to run concurrently?
Best Answer
Taken from Books Online: Database Mail
Database Mail use Service Broker technology:
The actual email delivery is handled by your SMTP server and so this will bear the brunt of the workload and should be provisioned according to capacity/email traffic requirements.
See Planning for Database Mail