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 |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2009-01-08 : 09:46:42
|
| Hi,I plan to test my web application by simulating a load on it, which will then test the web app code, the ADO, and then the SQL.I was wondering specifically if theres a good way to test insert SPROC performance? Specifically I am referring the the thread I had going here [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=116424[/url]Of course maybe its better that I just do it via the web application.Any input appreciated !Thanks again,mike123 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-08 : 09:49:10
|
You can timetest your call to the database just as you can timetest your sql-code.Dim aa = Now<call sp 1,000 times>print "Seconds " & (now - a )
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2009-01-08 : 09:56:16
|
| that will work perfectly! thank you again! :)mike123 |
|
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2009-01-08 : 09:56:16
|
| that will work perfectly! thank you again! :)mike123 |
|
|
|
|
|
|
performance testing inserts