Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
 Posted - 2003-09-25 : 12:35:55
|
| I'd like to perform a profiler trace of a specific stored procedure on a busy database. I don't want all the noise, just the data on a specific procedure in a specific database.filtering on objectID doesn't seem to work. Any ideas on how this can be accomplished?-ec |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-25 : 13:08:10
|
| Why doesn't filtering of a specific ObjectID work? You could use ObjectID or ObjectName to get the desire results. If there is too much noise, you'll probably have to remove some of the event classes. Which event classes are you using? I usually remove the Security Audit and Sessions event classes cuz I rarely care about that stuff when tracing. Those event classes create too much noise for me.Tara |
 |
|
|
Blastrix
Posting Yak Master
208 Posts |
Posted - 2003-09-25 : 13:44:54
|
| If all else fails you can always use the TextData filter. I have never seen that fail to get the necessary criteria.Steve |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2003-09-25 : 16:22:20
|
quote:
Originally posted by tduggan
Why doesn't filtering of a specific ObjectID work? You could use ObjectID or ObjectName to get the desire results. If there is too much noise, you'll probably have to remove some of the event classes. Which event classes are you using? I usually remove the Security Audit and Sessions event classes cuz I rarely care about that stuff when tracing. Those event classes create too much noise for me.Tara
Tara/Steve,ObjectID and ObjectName didn't work for me. For some reason the objectid doesn't show up in the profiler trace. I am probably doing something wrong though, I'll have to troubleshoot that later.The textdata filter worked for me though. Thanks for the suggestions.-ec |
|
|
|
areeba
Starting Member
3 Posts |
Posted - 2010-12-28 : 04:56:10
|
| object name do not work properly |
|
|
|
areeba
Starting Member
3 Posts |
Posted - 2010-12-28 : 04:57:41
|
| can any one tell me how to trace specific stored procedures through profiler in sql server 2008..........especially how we will define object name |
|
|
|
AIJAZ
Starting Member
1 Post |
Posted - 2012-01-24 : 12:44:09
|
| I am using SQL Server 2008 R2 profiler and ti is running against R2 database but I am not able to filter the trace for specific 3 tables. Even though I am giving only three Object IDs in the column filters but it is displaying all the queries running in that database. Database filteration works fine but not the table base filteration. I also tried by giving only table names in the ObjectName field but nothing worked. For example I want to see the queries only against Table A, Table B and Table C but when I am running query against Table D the trace is also capturing that data. I have placed only three Object IDs in the ObjectID field. Any one have any idea? |
|
|
|
|
|
|
Profiler trace of a specific stored procedure