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 |
|
iamsmahd
Yak Posting Veteran
55 Posts |
 Posted - 2005-03-05 : 05:05:27
|
| Hi all.I wanna to compare the performance of my stored procedures.....I was told that It's possible by using SQL profiler...Now my question is::how can I use it an compare the performance of my S.P. ?any example or tutorial pleaseThank you very much |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-03-05 : 07:15:07
|
| Try running the profiler and see what it can do.It can easily give the start and end times of SP calls - but that might be better from logging in the SPs themselves.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-05 : 13:34:55
|
| There are several good articles on Profiler and performance tuning at www.sql-server-performance.com and http://www.sqlteam.com/filtertopics.asp?TopicID=103 .MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Profiler