Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 749
  • Last Modified:

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,
0
dba2dba
Asked:
dba2dba
  • 2
2 Solutions
 
25112Commented:
can you profile and save a trace and then calculate it?
select avg(duration) from tracetable where textdata = 'your query goes here'
0
 
25112Commented:
or gather Transaction/Sec in a excel spreadsheet and then calculate average with a new formula...
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now