Suljettu

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?

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

Näytä lisää: 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

About the Employer:
( 1 review ) Toronto, Canada

Projektin tunnus: #1728352

13 freelanceria on tarjonnut keskimäärin 194 $ tähän työhön

shmai

hello! it can be resolved.

250 $ USD 6 päivässä
(180 arvostelua)
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 1 päivässä
(26 arvostelua)
4.9
codetrance

I can help you. Thank you.

200 $ USD 2 päivässä
(13 arvostelua)
4.3
BRIGHTSOFTINFO

Hi .Net Expert Here. Please check PMB.

200 $ USD 10 päivässä
(1 arvostelu)
3.2
AGmonks85

Please see private message

250 $ USD 2 päivässä
(2 arvostelua)
3.0
techswastik

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

250 $ USD 7 päivässä
(1 arvostelu)
3.0
zulqarnain0502

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

200 $ USD 5 päivässä
(0 arvostelua)
0.0
TechSawy

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

190 $ USD 1 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
0.0
joyxat

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

165 $ USD 3 päivässä
(0 arvostelua)
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 2 päivässä
(0 arvostelua)
0.0
NavigaOnline

Hi, Kindly refer PM. Regards, Ananya

100 $ USD 3 päivässä
(1 arvostelu)
0.0
assuranceES

Hello, We can fix this issues. Thanks K

200 $ USD 1 päivässä
(0 arvostelua)
0.0