Avatar of CaptainGiblets
CaptainGiblets
Flag for United Kingdom of Great Britain and Northern Ireland asked on

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.
Microsoft SQL ServerExchange

Avatar of undefined
Last Comment
Amit

8/22/2022 - Mon
Amit

Any error you see?
CaptainGiblets

ASKER
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
Amit

How is CPU usage on Exchange server. Total how many servers you have?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
CaptainGiblets

ASKER
2 exchange servers, there cpu usage is at around 5% on server db mail profile points to.
messageratelimit.png
Amit

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.
CaptainGiblets

ASKER
the delay is only for the SQL server.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Amit

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Amit

Hi CaptainGiblets,

Did you created the relay connector, I suggested? Or issue still persist
Amit

Creating relay connector is best option.