Đã Đó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 thêm: database mail stored procedure, databasemail mailenable, website procedures, service processor, server monitoring jobs, jobs newsletters, database processor, couple jobs, processor jobs, hardware jobs, stored, stored procedures, smtp server, server plesk, procedures, proc, iis server, asp send mail smtp, mailenable asp, sql search asp, plesk iis, asp sql search, resolve server, search server, server issue

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

Mã Dự Án: #1728352

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

shmai

hello! it can be resolved.

$250 USD trong 6 ngày
(180 Đánh Giá)
7.0
sharpcodernet

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 Giá)
4.9
codetrance

I can help you. Thank you.

$200 USD trong 2 ngày
(13 Đánh Giá)
4.3
BRIGHTSOFTINFO

Hi .Net Expert Here. Please check PMB.

$200 USD trong 10 ngày
(1 Đánh Giá)
3.2
AGmonks85

Please see private message

$250 USD trong 2 ngày
(2 Đánh Giá)
3.0
techswastik

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

$250 USD trong 7 ngày
(1 Đánh Giá)
3.0
zulqarnain0502

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

$200 USD trong 5 ngày
(0 Đánh Giá)
0.0
TechSawy

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

$190 USD trong 1 ngày
(0 Đánh Giá)
0.0
ntechinfotech

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 Giá)
0.0
joyxat

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

$165 USD trong 3 ngày
(0 Đánh Giá)
0.0
mmarguta

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 Giá)
0.0
NavigaOnline

Hi, Kindly refer PM. Regards, Ananya

$100 USD trong 3 ngày
(1 Đánh Giá)
0.0
assuranceES

Hello, We can fix this issues. Thanks K

$200 USD trong 1 ngày
(0 Đánh Giá)
0.0