SQL Profiler - Cathing up special trans with SQL Profiler...

SQL Profiler - Cathing up special trans with SQL Profiler...

Post by FatihM » Thu, 03 Jul 2003 22:04:23



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 KE
 
 
 

SQL Profiler - Cathing up special trans with SQL Profiler...

Post by Russell Fi » Fri, 04 Jul 2003 22:45:58

You need to set a:

Transaction Event
SQL Transaction Event Class

Be sure to include the Duration column in your data.
http://www.yqcomputer.com/

Using the Profiler Filter you can filter for GreaterThan or Equal to 120000
milliseconds.
http://www.yqcomputer.com/

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

Russell Fields



2000.
last

 
 
 

SQL Profiler - Cathing up special trans with SQL Profiler...

Post by FatihM » Fri, 04 Jul 2003 23:03:26

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

Thanks Russell...



http://www.yqcomputer.com/
_mon_perf_2r21.asp
120000
http://www.yqcomputer.com/
_mon_perf_2r21.asp