I used sql profiler to record the long running sql while doing performance test. The performance test simulated 100 curcurrent users. When the test finished, I catched some long running sql(some are select sql and some are update sql) in the sql
profiler and executed them in the Management Studio, all of them finished execution in less than 1 second. I am curious about this. I know under 100 curcurrent users operation, both Operating System and Sql Server have less resource to execute a given
sql, so I thought they would finish execution in about 2 or 3 seconds rather than 8 seconds.
I did the same performance test again and during the test, i executed those sql in the management studio. I become even more curious. Thoes sql still executed in less than 1 second. Why?
I am new to performance test. Please help me. Thank you.
View Complete Post