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 |
|
Chinni
Yak Posting Veteran
95 Posts |
 Posted - 2008-10-01 : 12:46:43
|
| I have two stored procedures....(with same logic)....how can i know which one has good performance.......when i run the SP each time they are showing different execution time....Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-01 : 12:53:18
|
| Analyse the execution plans for two stored procedures and see which one has more costlier queries.Also you can analyse using profiler the duration taken by each and also CPU usage and reads. |
 |
|
|
|
|
|
SP performance