Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 380
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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