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 |
|
malathic
Starting Member
6 Posts |
 Posted - 2006-02-14 : 05:24:32
|
| Hi!I have a trace files of a stored procedure. It has the duration event also. We tuned the SP and now we have the trace file of that execution also along with the duration.There are lot of stored procedures called from with the SP. Is there any way to find the total duration, like the summation of the duration of the batch itself,using the 2 trace files alone...Please, help.. Thanks in advance....... |
|
|
mmarovic
Aged Yak Warrior
518 Posts |
Posted - 2006-02-14 : 06:11:23
|
| Import the trace into sql server table and use aggregate functions. |
 |
|
|
malathic
Starting Member
6 Posts |
Posted - 2006-02-14 : 06:16:04
|
| Thanks... Thats what I did... I thought there would be some other way to do it...Thanks a lot |
|
|
|
|
|
|
Esitmate total duration of stored procedure