asked on

SQL Profiler - Tracing

I want to run SQL Profiler Trace event only on a particular table of database not on entire database. What should i apply in filter to do this?

Also is there any function through which i can know exact number of Inserts, Updates, Selects, Deletes which is happening on particular table or Average number would also do?

apresto

Not sure if you can trace a particular table but if you trace a specified database and save it into a table you can then query that table for the table you need:

to get dbId - Select Db_Id()

Aneesh

Hi dduser,

you can filter this by specifying the objaect name in the filter section

Aneesh R!

Aneesh

dduser,
> exact number of Inserts, Updates, Selects, Deletes

for this you have to check the log. use some log viewers like lumigent log explorer or Apex log

dduser

ASKER

Hi Aneesh,

I tried to give the same in Object Name but it didn't work.

Kaushal

Anthony Perkins

>>I tried to give the same in Object Name but it didn't work.<<
If you are wondering why you are not getting any feedback, you may want to re-read the guidlelines at this link:
https://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi49

ASKER CERTIFIED SOLUTION

imran_fast

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Aneesh

Grade "C" !!!!!!!!!
I think you need to go thru the EE rules ...

apresto

Agreed, theres anonther one to the blacklist!