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_fastCommented:
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
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.