locked
Performance and Security Issues with Database Mail on the 2008 R2 server RRS feed

  • Question

  • Hello --

    We are planning on implementing Database Mail on our server with the initial intention of having it send notifications to the administrators on the results of the various backups that are done on the system. The planned configuration would have email notifications sent on the success or failure of the Full and Differential backups, while notifications would be sent on the failure of the Log file backups.

    There were questions over what impact such a configuration would have on the performance of the server, as well as any security implications there would be if the mail service was deployed for use. Does anyone have any feedback or insight into this?

    Thanks.

    Friday, December 7, 2012 6:37 PM

Answers

  • Hi Kaplan,

    In security side, execute permissions for sp_send_dbmail default to all members of the DatabaseMailUser database role in the msdb database. However, when the user sending the message does not have permission to use the profile for the request, sp_send_dbmail returns an error and does not send the message. When you consigure db mail, you create a profiler and also say who are allowed to use this mail profile. It means if you deploy least permission to every user in SQL Server, there should be any security problem.

    In performance side, SQL Server database mail is a part of SQL Server Agent. We send the mail automatically by using SQL Server Agent. The performance of SQL Server Agent always depends on the job you run. We can use Performance Objects which allow you to use Performance Monitor, a Windows tool, to identify what the SQL Server Agent service is doing in the background. For example, you can identify how many active jobs the SQL Server Agent service is currently running to identify those jobs that are blocked.

    Please refer to:

    http://msdn.microsoft.com/en-us/library/ms189100(v=sql.105).aspx

    TechNet Subscriber Support

    If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.


    Iric Wen
    TechNet Community Support

    • Marked as answer by Iric Wen Monday, December 17, 2012 6:43 AM
    Monday, December 10, 2012 9:38 AM