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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 SQL CLR, HttpWebRequest, and Connection Throttling
 Reply to Topic
 Printer Friendly
Author  Topic Next Topic  

jbullington
Starting Member

1 Posts

Posted - 12/01/2011 :  15:03:24  Show Profile  Reply with Quote
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 - 07/17/2017 :  16:20:35  Show Profile  Reply with Quote
Ever find a solution for this?
Go to Top of Page
   Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000