Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 383
  • Last Modified:

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?

0
dduser
Asked:
dduser
1 Solution
 
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
 
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
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
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
 
imran_fastCommented:
in the filters section in the text data in the like put %tableName%
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.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now