Update

Question

Update

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

6pravin9@gmail.com SSC Enthusiast Points: 191 More actions · Answer 1

Another USe case.

I have multiple parameterized SP for our Application.

When I Executes those SP individual it will returns output within 1 Sec. But when we are running Test Load with multiple user around 100 or 200 users same time , Same SP Response Time is Over 3-4 Sec.

responce

If i Execute same SP with same Parameter Individual response time is less then 1 Sec.

This reply was modified 4 years, 4 months ago by 6pravin9@gmail.com.

kaj SSCommitted Points: 1605 More actions · Answer 2

6pravin9@gmail.com wrote:

Another USe case.
I have multiple parameterized SP for our Application.
When I Executes those SP individual it will returns output within 1 Sec. But when we are running Test Load with multiple user around 100 or 200 users same time , Same SP Response Time is Over 3-4 Sec.
If i Execute same SP with same Parameter Individual response time is less then 1 Sec.

Sorry, but I'm feeling a disconnect here. Is this related to the initial question - other than by being used by the same application - or is this something completely unrelated? If unrelated, please create a new question.

If this use case is related to the initial question, then please add some context, like what are these stored procedures of yours doing? Etc., etc. The more information you provide, the better response you will get.