We help IT Professionals succeed at work.

SQL DBmail taking ages to send emails

130 Views
Last Modified: 2016-10-25
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.
Comment
Watch Question

AmitIT Architect
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
Any error you see?

Author

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
AmitIT Architect
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
How is CPU usage on Exchange server. Total how many servers you have?

Author

Commented:
2 exchange servers, there cpu usage is at around 5% on server db mail profile points to.
messageratelimit.png
AmitIT Architect
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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.

Author

Commented:
the delay is only for the SQL server.
IT Architect
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
AmitIT Architect
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
Hi CaptainGiblets,

Did you created the relay connector, I suggested? Or issue still persist
AmitIT Architect
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
Creating relay connector is best option.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions