Solved

SQL DBmail taking ages to send emails

Posted on 2016-09-21
9
28 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.
0
Comment
Question by:CaptainGiblets
  • 6
  • 3
9 Comments
 
LVL 42

Expert Comment

by:Amit
ID: 41809261
Any error you see?
0
 
LVL 6

Author Comment

by:CaptainGiblets
ID: 41810253
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
 
LVL 42

Expert Comment

by:Amit
ID: 41810671
How is CPU usage on Exchange server. Total how many servers you have?
0
 
LVL 6

Author Comment

by:CaptainGiblets
ID: 41810688
2 exchange servers, there cpu usage is at around 5% on server db mail profile points to.
messageratelimit.png
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 42

Expert Comment

by:Amit
ID: 41810842
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
 
LVL 6

Author Comment

by:CaptainGiblets
ID: 41810844
the delay is only for the SQL server.
0
 
LVL 42

Accepted Solution

by:
Amit earned 500 total points (awarded by participants)
ID: 41810850
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
 
LVL 42

Expert Comment

by:Amit
ID: 41832053
Hi CaptainGiblets,

Did you created the relay connector, I suggested? Or issue still persist
0
 
LVL 42

Expert Comment

by:Amit
ID: 41858228
Creating relay connector is best option.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how the fundamental information of how to create a table.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now