我们正在使用sql Server 2008
Database Mail向我们的网站访问者发送电子邮件.我不知道sql Server是通过从队列中拾取来逐个发送邮件,还是会使用线程以同时方式发送电子邮件.
解决方法
摘自在线书籍:
Database Mail
To minimize the impact on sql Server,
the component that delivers e-mail
runs outside of sql Server,in a
separate process. sql Server will
continue to queue e-mail messages even
if the external process stops or
fails. The queued messages will be
sent once the outside process or SMTP
server comes online.
Database Mail provides background,or
asynchronous,delivery. When you call
sp_send_dbmail to send a message,
Database Mail adds a request to a
Service Broker queue. The stored
procedure returns immediately. The
external e-mail component receives the
request and delivers the e-mail.