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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 t-sql for top transactions by age

Author  Topic 

Hommer
Aged Yak Warrior

808 Posts

Posted - 2013-03-29 : 12:43:51
Hi,

Any one knows a sql script that will produce the similar result as the standard report "Top Transactions by Age"?

Thanks!

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2013-03-29 : 13:13:33
I don't have a script BUT...
You could start Profiler to see what SQL statements are running and then initiate the Top Transactions By Age report and see what is getting executed.

=================================================
There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber
Go to Top of Page

Hommer
Aged Yak Warrior

808 Posts

Posted - 2013-03-29 : 13:21:21
Thank you!

Also I found Activity monitor, which gave me more than I need.
Go to Top of Page
   

- Advertisement -