Does Database Mail use a lot of resources

We asked one of our admins to enable Database Mail on one of our SQL servers so we could have the database send us an end of week report. His response was that he was concerned that it would consume too many resources on the server.

Now, we are only sending 1 email per week so it would seem unlikely it consumes any material amount of resources to send one email but I suppose he has a valid concern that maybe Database Mail reserves a minimum amount of resources just being enabled. I can't find any MS articles indicating whether or not Database Mail consumes many resources just being enabled. If anyone has any experience with this, your feedback is appreciated.
dthansenAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

viennatechCommented:
The actual mail process does not take up much in the way of resources.  A connection to a mail server and some minimal network traffic.  
The actual report generation/code/queries might be more of a burden but these can usually be timed/tuned to your environment to run during off production hours.
0
Scott CSenior EngineerCommented:
There won't be any article on how much resources are consumed because every system is different and the amount of resources consumed will be different.

If you have a testing environment, set it up there and see how much is used and go from there.

https://msdn.microsoft.com/en-us/library/hh245116.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
There will be more a security issue than a resource issue. That's a reason for the Database Mail being disabled by default.
0
John EsraeloDatabase / SQL DeveloperCommented:
I use db mail daily, actually 3 times a day and can get up to 100s of notifications.  just fine
unless, you are sending notifications that are several times a minute to 100s of users.
in that case, you may check and observe the server reactions, logs, activities..
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.