Average Transaction Time in SQL Server

Hi Experts,

I would like to understand how to gather the average transaction time in SQL Server 2005.
I see that there is a counter Transaction/Sec but not the avg. transaction.

Can you please help me with this....

Thanks,
LVL 8
dba2dbaAsked:
Who is Participating?
 
25112Connect With a Mentor Commented:
or gather Transaction/Sec in a excel spreadsheet and then calculate average with a new formula...
0
 
25112Connect With a Mentor Commented:
can you profile and save a trace and then calculate it?
select avg(duration) from tracetable where textdata = 'your query goes here'
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.