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 |
|
liptonIcedTea
Starting Member
26 Posts |
 Posted - 2008-06-12 : 02:24:08
|
| Hi,I've got a stored procedure and a view that do the same thing and i would like to figure out which one does what faster. I use SQL Server... what are some ways for me to figure out which is better in terms of performance? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-12 : 02:27:40
|
| which one does what faster?didnt get that.Can you explain? |
 |
|
|
liptonIcedTea
Starting Member
26 Posts |
Posted - 2008-06-12 : 02:33:28
|
| sorry what i meant is that i just wanna run both the stored proc and view over a number of scenarios, and figure out which solution is faster in each scenario. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-12 : 03:06:22
|
quote:
Originally posted by liptonIcedTea
sorry what i meant is that i just wanna run both the stored proc and view over a number of scenarios, and figure out which solution is faster in each scenario.
use query execution plan to see how query engine is working on both scenario. Also you can use Profiler to take the trace and compare execution times. |
|
|
|
liptonIcedTea
Starting Member
26 Posts |
Posted - 2008-06-13 : 00:23:58
|
| i can't use execution plan for Views |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-14 : 18:06:54
|
| Why? |
|
|
|
|
|
|
Performance Analysis