Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 SQL CLR, HttpWebRequest, and Connection Throttling

Author  Topic 

jbullington
Starting Member

1 Post

Posted - 2011-12-01 : 15:03:24
Good day!

I have inherited a fairly complex MSSQL database. Used within the code are CLR Assembly DLLs that are called from within stored procedures.

Within these CLR Assembly DLLs, we are reaching out to a 3rd party web service via the .Net 2.0 HttpWebRequest object from the SQL server. ( While I understand that this is not the appropriate way to do this, please keep in mind that this was inherited and we are in the process of fixing this. )

Here is the quandary we are currently experiencing:

The SQL CLR is currently throttled to two (2) outbound communication threads (as verified by netstat). Is there any way to increase the number of outbound threads from the SQL server, either via the .Net configurations or by some other method, including altering the assembly?

Things we have attempted already:

IIS Worker Thread increase
Machine.Config processModel tuning
Machine.Config httpRuntime tuning
Machine.Config system.net connectionManagement tuning

However, no matter what changes are done in the .Net configuration or in IIS, I cannot increase the number of outbound threads. I've spent hours Google'ing the internets to try to find an answer as it relates to HttpWebRequests, SQL CLR, Assemblies, permission types, anything that can help...

Some other stats you may request:

Code written in .NET Version 2.0
SQL Server 2008 R2 EE
Windows Server 2008 R2, IIS 7.5
sp_configure clr_enabled = true
Assembly / SP set to EXTERNAL_ACCESS
SP was built WITH ENCRYPTION

Thank you in advance for any information you might be able to provide. If you need anything else, please feel free to ask.

J.R.

mbourgon
Starting Member

6 Posts

Posted - 2017-07-17 : 16:20:35
Ever find a solution for this?
Go to Top of Page
   

- Advertisement -