Hi all,

Whereas using SQL7.0 and SP3.0 on Win2000, I use Profiler tool of SQL 2000.
I'd like to know how can I catch up and display the transactions which last
more than 2 minutes with Profiler?

Thanks in advance,

Fatih Mehmet KÖSE

You need to set a:

Transaction Event
SQL Transaction Event Class

Be sure to include the Duration column in your data.
http://msdn.microsoft.com/library/de..._perf_2r21.asp

Using the Profiler Filter you can filter for GreaterThan or Equal to 120000
milliseconds.
http://msdn.microsoft.com/library/de..._perf_2r21.asp

The links are to parts of the Profiler documentation in the BOL (and the
online MSDN).

Russell Fields

"FatihMK" <fatihk (AT) banksoft (DOT) com.tr> wrote

I had tried to use CPU Time event class, but the correct one is yours...

Thanks Russell...

"Russell Fields" <rlfields (AT) sprynet (DOT) com> wrote

_mon_perf_2r21.asp
_mon_perf_2r21.asp