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 |
|
Hariarul
Posting Yak Master
160 Posts |
 Posted - 2007-09-17 : 09:23:06
|
| Hi experts,There is a stored procedure storedprocedure1 which takes 5 seconds to execute and give the output from the Query Analyser. Now, we are doing a performance testing on the application by simulating 100 concurrent users. Whenever the user limit exceeds 30 , the same stored procedure storedprocedure1 takes 2.50 minutes to execute and give the output from the Query Analyser. Also the pages calling the procedure crashes with time out expired errors.Any suggestions / help to handle this scenario would be appreciated.Thanks in advance,Hariarul |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-09-17 : 09:34:02
|
| Is there a blocking issue where resources are blocked by one process for longer duration? check using sp_who2 proc.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
Performance of Stored procedures.