July 10, 2001 at 9:12 am
I am curious how does SQL Server handle simultaneous calls to the same stored procedures.For example I have a stored procedure GetResults which is simulatneously fired by 1000 clients then how will the server handle this.Will it wait for the first one to complete execution send results back and then fire another or it will see to it that all 1000 clients are given separate processes of the stored procedure and the results returned with no delay.Thanks for all the help.
July 10, 2001 at 11:01 am
They should all execute independently, assuming that running one doesn't cause another to be blocked by locking of the data. Not impossible, but I think 1000 at once would be pretty rare - and might generate a pretty big usage spike.
Andy
July 19, 2001 at 3:38 am
The stored procedure is executed simultaneously and independently, and they doesnt block each other locking of the data.
July 19, 2001 at 9:06 am
Are you saying that there can be NO blocking with simultaneous execution of the same sp?
July 19, 2001 at 11:35 am
patilds,
I'm a little confused by your statement as well. I would think that there could be a blocking issue.
K. Brian Kelley
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply