Databasemail, SQL server, stored procedures, IIS, plesk and mailenable

We run a jobs website. We are sending out newsletters to our subscribers. There are around 15000 subscribers. We have dedicated servers with no limits & we are not using smtp of web service provider.

Most of the times when we send out the email, the system stops working & we are forced to restart the system.

The sequence of events:

1. The website executes a stored procedure with search terms & email sent the the database

2. The stored procedure does the search and sends out email to databasemail.

3. Databasemail sends the emails to Mailenable (our SMTP server).

I think plesk (which we use for website management) & IIS may also be active participant in this sequence.

After couple of thousand emails are queued in databasemail, the server goes down. This happens most of the times, but at times the mail gets delivered and we get confirmation in the website.

We are monitoring the server - it has 16GB RAM, hexacore processor & it says, even during the email time that only upto 40% is being used. I don't think it is a hardware issue.

We are not sending emails all at once - stored proc populates databasemail table which is queued - databasemail sends mails to smtp server (mailenable) which again queques the emails and sends it at its own pace (about 10 to 15 minutes to send the mails out)

Let us know if you will be able to resolve this issue?

Keahlian: .NET, ASP, IIS, Plesk, SQL

Lihat lebih lanjut: database mail stored procedure, databasemail mailenable, website procedures, t sql jobs, service processor, server monitoring jobs, net 3.5 jobs, jobs newsletters, database processor, couple jobs, t-sql with, t-sql in, processor jobs, hardware jobs, t-sql;, stored, stored procedures, smtp server, server plesk is, Procedures, ProC, iis server, asp send mail smtp, mailenable asp, sql search asp

Tentang Pemberi kerja:
( 1 ulasan ) Toronto, Canada

ID Proyek: #1728352

13 freelancer menawar dengan rata-rata $194 untuk pekerjaan ini


hello! it can be resolved.

$250 USD dalam 6 hari
(180 Ulasan)

Hi, .NET developer with 7+ years of experience is ready to help you. Please, check PMB for more details. Thanks.

$155 USD dalam 1 hari
(26 Ulasan)

I can help you. Thank you.

$200 USD dalam 2 hari
(13 Ulasan)

Hi .Net Expert Here. Please check PMB.

$200 USD dalam 10 hari
(1 Ulasan)

Please see private message

$250 USD dalam 2 hari
(2 Ulasan)

Hello Sir, Please check my personal message for detail answer of your problem thanks

$250 USD dalam 7 hari
(1 Ulasan)

Contact me.I can help you out with its solution.

$200 USD dalam 5 hari
(0 Ulasan)

Hi, I would like to resolve your issue. Thanks.

$190 USD dalam 1 hari
(0 Ulasan)

Hey, We can do this work in better way. Please check PM to more detail. I hope you will give us to chance. Thanks, Hancy

$200 USD dalam 7 hari
(0 Ulasan)

Hey, We have expert team regarding to your project. Please check PMB for detail bid !!! Thanks.

$165 USD dalam 3 hari
(0 Ulasan)

i'm working as a software developer for asp.net and i solved a lot of problems regarding stored procedures and email logic.

$160 USD dalam 2 hari
(0 Ulasan)

Hi, Kindly refer PM. Regards, Ananya

$100 USD dalam 3 hari
(1 Ulasan)

Hello, We can fix this issues. Thanks K

$200 USD dalam 1 hari
(0 Ulasan)