Solved

SQL Profiler - Tracing

Posted on 2006-07-08
8
377 Views
Last Modified: 2012-06-21
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
Comment
Question by:dduser
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 23

Expert Comment

by:apresto
ID: 17064375
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
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17064386
Hi dduser,

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

Aneesh R!
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17064389
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
Independent Software Vendors: 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!

 
LVL 9

Author Comment

by:dduser
ID: 17064407
Hi Aneesh,

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

Kaushal
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 17068596
>>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
 
LVL 28

Accepted Solution

by:
imran_fast earned 500 total points
ID: 17071106
in the filters section in the text data in the like put %tableName%
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17239563
Grade "C"  !!!!!!!!!
I think you need to go thru the EE rules ...
0
 
LVL 23

Expert Comment

by:apresto
ID: 17239785
Agreed, theres anonther one to the blacklist!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question