Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Parallel processing limitation? Expand / Collapse
Posted Wednesday, November 20, 2013 1:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 14, 2014 12:01 PM
Points: 3, Visits: 10
We use a SQL assembly to make web calls. We have 1 assembly with a few dozen functions, all use web calls.

Recently we ran into an issue where one web call was locked up and the entire assembly was locked up and we couldn’t make any function calls. I’m having trouble finding the answer to my question online. My question is, does SQL run these functions in parallel, or can only one function run at a time in the assembly?

Please help. Is there some sort of setting or limitation that would allow / prevent the same function from being called multiple times at once?

For an example, I have an assembly with multiple functions. User A calls Function 1. Function 1 (lets say) takes 3 seconds. If User B calls Function 1, does user B’s function not fire until User A’s is finished? Note, we have no issues if User B calls Function 2 while User A is firing Function 1.
Post #1516183
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse