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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Event Classes And SQL profiler

Author  Topic 

rajantonyv
Starting Member

12 Posts

Posted - 2002-12-06 : 13:23:48
Hello,

I had a question regarding the event classes category in SQL Profiler. I am trying to use TSQL event class category and I am trying to find out the code for each SQL statement. For example, I am using SQL profiler to see the number of times an insert, update, select, and delete statement ran. But inside the file or table where the profiler stores this information these DMLs are represented as integer values rather than any text. Is there anyway I can find out what these integer values/code represent which DML statement. I know 31 stands for Select Statements.

Thanks for your help,

Raj


Rajesh Antony Vattakunnel

Argyle
Yak Posting Veteran

53 Posts

Posted - 2002-12-08 : 09:04:14
SQL 2000
---------
A description of all events:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ta-tz_1c4p.asp

A nice script to create a table with events:
http://vyaskn.tripod.com/code/events_eventclass.txt

A nice article on identifying problems using Profiler
http://vyaskn.tripod.com/analyzing_profiler_output.htm

SQL 7
------
Run xp_trace_geteventnames in QA.

There might be a similar SP in SQL 2000 but I haven't found it.

/Argyle

Edited by - Argyle on 12/08/2002 09:22:46
Go to Top of Page
   

- Advertisement -