SQL DBmail taking ages to send emails

We send around 300 emails out at 4pm every day however there is something i suspect on my exchange server that limits the amount SQL is allowed to send to it within a certain period.

I have set SQL to keep retying until the emails send but thats just a work around.

Is there a setting i can change on my exchange server to allow SQL to send more emails at once? We are using exchange 2016 with sql 2012.

Thanks in advance for any help.
LVL 6
CaptainGibletsAsked:
Who is Participating?
 
AmitConnect With a Mentor IT ArchitectCommented:
Create new relay connector and test it. Or you can enable pipe line tracing to troubleshoot this further. How to do it:
https://technet.microsoft.com/en-us/library/bb125018(v=exchg.150).aspx
0
 
AmitIT ArchitectCommented:
Any error you see?
0
 
CaptainGibletsAuthor Commented:
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2016-09-21T16:57:11). Exception Message: Cannot send mails to mail server. (Service not available, closing transmission channel. The server response was: 4.4.2 Message submission rate for this client has exceeded the configured limit).
)

however if i run Get-ReceiveConnector | select identity,messageratelimit i get the attached.

My 2 sql connetors depeding on what server i point them to both have "unlimited"

message rate limit
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
AmitIT ArchitectCommented:
How is CPU usage on Exchange server. Total how many servers you have?
0
 
CaptainGibletsAuthor Commented:
2 exchange servers, there cpu usage is at around 5% on server db mail profile points to.
messageratelimit.png
0
 
AmitIT ArchitectCommented:
How about mail flow for normal users? Do you see any delay. I suggest you to create separate relay connector for application mail flow. Then test again.
0
 
CaptainGibletsAuthor Commented:
the delay is only for the SQL server.
0
 
AmitIT ArchitectCommented:
Hi CaptainGiblets,

Did you created the relay connector, I suggested? Or issue still persist
0
 
AmitIT ArchitectCommented:
Creating relay connector is best option.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.