December 7, 2012 at 11:40 am
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.
December 7, 2012 at 1:24 pm
Database mail doesn't have a very large impact on a SQL Server. It does use Service Broker so it's not zero impact, but it's still lightweight while having the advantage of not loosing e-mails if they can't be delivered. Using it with SQL Agent jobs notifications is a very common practice.
The DBA can control who has the ability to use the database mail commands, using roles in the MSDB database, so security can be managed.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply