<div>
if you remove the mail-sending code from the process, and just allow it to run through the cursor doing everything else (if anything), how long does it take? Answering that question will narrow the field and tell us whether the bottleneck is in the mail-sending bit or not.
</div>


<div>
I remove the @message param an it is still just as slow, <br />
<br />
To keep things simple i am working from the code attached above and i am not using a cursor,<br />
<br />
it takes 15sec to send one email.
</div>


<div>
<div class="content wysiwyg-content">
It takes 15sec to send a single email using this stored procedure, <br />
i'm looking to send out over 2000 emails using a cursor,<br />
This would take over 8hours, <br />
whilst with the xp_sendmail its practically instant,<br />
Can you see why this would be?<br />
I've attach my code below (i am sending from my exchange server on my network)<br />
&nbsp;<br />

<pre><code id="code-124051">declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
	@FROM			= N'autoemail@meteorelectrical.com',
	@FROM_NAME		= N'Automated Email',
	@TO			= N'eoin.conway@meteorelectrical.com',
	@subject		= N'Hello HTML SQL Server SMTP Mail',
	@message		= N'&lt;HTML&gt;&lt;H1&gt;this is some content for the body part object&lt;/H1&gt;&lt;/HTML&gt;',
	@type			= N'text/html',
	@server 		= N'EXCHANGESRV'
select RC = @rc
</code></pre>
</div>
</div>


It takes 15sec to send a single email using this stored procedure, 
i'm looking to send out over 2000 emails using a cursor,
This would take over 8hours, 
whilst with the xp_sendmail its practically instant,
Can you see why this would be?
I've attach my code below (i am sending from my exchange server on my network)
 

if you remove the mail-sending code from the process, and just allow it to run through the cursor doing everything else (if anything), how long does it take? Answering that question will narrow the field and tell us whether the bottleneck is in the mail-sending bit or not.

I remove the @message param an it is still just as slow, 

To keep things simple i am working from the code attached above and i am not using a cursor,

it takes 15sec to send one email.

Performance Issue with XP_SMTP_SENDMAIL

It takes 15sec to send a single email using this stored procedure, 
i&#39;m looking to send out over 2000 emails using a cursor,
This would take over 8hours, 
whilst with the xp_sendmail its practically instant,
Can you see why this would be?
I&#39;ve attach my code below (i am sending from my exchange server on my network)
 

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.