Solved

SQL DBmail taking ages to send emails

Posted on 2016-09-21
9
37 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
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 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
 
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Learn to move / copy / export exchange contacts to iPhone without using any software. Also see the issues in configuration of exchange with iPhone to migrate contacts.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
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.

856 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