Post reply

Performace hit on server when using sp_send_dbmail

  • February 20, 2012 at 6:37 pm

    #391602

    We are moving our site and database onto a new system. Historically we ran some run jobs everynights that would email summary informations to certain users. We run send about 50 email a night.

    The question came up as to what kind of performance hit do we get when sending emails using sp_send_dbmail

  • February 20, 2012 at 7:37 pm

    #1449460

    none.

    no performance impact, because the mail command is asynchronous...the mail is queued to the service broker, and it processed outside of the transaction;

    On a recent email campaign, i queued about 2000 emails to the service broker, and the TSQL portion of it was near instantaneous, even though it was a cursor for individualized mail.

    looking at my mail sent history, it looks like the broker service itself took around 15 minutes to send out those emails, and there were some later retries for the items that did not make it the first time.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply