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?

LVL 9
dduserAsked:
Who is Participating?
 
imran_fastConnect With a Mentor Commented:
in the filters section in the text data in the like put %tableName%
0
 
aprestoCommented:
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()
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Hi dduser,

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

Aneesh R!
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
Aneesh RetnakaranDatabase AdministratorCommented:
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
0
 
dduserAuthor Commented:
Hi Aneesh,

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

Kaushal
0
 
Anthony PerkinsCommented:
>>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:
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi49
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Grade "C"  !!!!!!!!!
I think you need to go thru the EE rules ...
0
 
aprestoCommented:
Agreed, theres anonther one to the blacklist!
0
All Courses

From novice to tech pro — start learning today.