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 |
|
samsun125
Yak Posting Veteran
63 Posts |
 Posted - 2009-02-10 : 05:30:12
|
| Hi all,I have one query ,my stored procedure name is emp_spi want to execute means i will use this below statementexec emp_sp(i.e 1 hit)that query execution time i will take response time in sql profiler.what i want to do is i want to take response time for 2000 concurrent hits.for sequential hits i done using while loop, but i want concurrent hitsany body tell me how to do.RegardsRamaDevi. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-10 : 05:36:15
|
Open 2000 query windows and includeWAITFOR TIME '20090210 20:00'EXEC emp_spthen all 2000 query windows will execute at 8 PM this evening.Or use a web-based stress tool from Microsoft.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
Posted - 2009-02-10 : 05:47:09
|
| [code]try this tool, not yet triedhttp://www.sqlstress.com/Walkthrough.aspx[/code][code]"There is only one difference between a dream and an aim.A dream requires soundless sleep to see,whereas an aim requires sleepless efforts to achieve..!!"[/code] |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-10 : 06:24:32
|
quote:
Originally posted by PeterNeo
[code]try this tool, not yet tried
Not even reachable.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Query?????????????