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.
| 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 increaseMachine.Config processModel tuningMachine.Config httpRuntime tuningMachine.Config system.net connectionManagement tuningHowever, 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.0SQL Server 2008 R2 EEWindows Server 2008 R2, IIS 7.5sp_configure clr_enabled = trueAssembly / SP set to EXTERNAL_ACCESSSP was built WITH ENCRYPTIONThank 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? |
 |
|
|
|
|
|
|
|
SQL CLR, HttpWebRequest, and Connection Throttling