Đã Đóng

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?

Kĩ năng: .NET, ASP, IIS, Plesk, SQL

Xem nhiều hơn: 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

Về Bên Thuê:
( 1 Nhận xét ) Toronto, Canada

ID dự án: #1728352

13 freelancer đang chào giá trung bình $194 cho công việc này


hello! it can be resolved.

$250 USD trong 6 ngày
(180 Nhận xét)

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

$155 USD trong 1 ngày
(26 Nhận xét)

I can help you. Thank you.

$200 USD trong 2 ngày
(13 Nhận xét)

Hi .Net Expert Here. Please check PMB.

$200 USD trong 10 ngày
(1 Nhận xét)

Please see private message

$250 USD trong 2 ngày
(2 Nhận xét)

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

$250 USD trong 7 ngày
(1 Nhận xét)

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

$200 USD trong 5 ngày
(0 Nhận xét)

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

$190 USD trong 1 ngày
(0 Nhận xét)

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 trong 7 ngày
(0 Nhận xét)

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

$165 USD trong 3 ngày
(0 Nhận xét)

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 trong 2 ngày
(0 Nhận xét)

Hi, Kindly refer PM. Regards, Ananya

$100 USD trong 3 ngày
(1 Nhận xét)

Hello, We can fix this issues. Thanks K

$200 USD trong 1 ngày
(0 Nhận xét)