Hi ,
How can i actually use the filter for profiler
i have set up the profiler with a filter using the object_name ( as like
"tb_transaction" w/o the quotes) and i have also bring out the object_name
column and make it into a group
however, it seems not to be work. i have tested with statements like "select
* from tb_transaction" and "select * from tb_customer" and both statements
were shown in the profiler and the column object_name is always empty
appreciate ur kind advice
tks & rdgs
Message posted via http://www.droptable.comHi
Object_name is not always recorded, using the object_id and database_id will
give you better results.
John
"maxzsim via droptable.com" wrote:
> Hi ,
> How can i actually use the filter for profiler
> i have set up the profiler with a filter using the object_name ( as like
> "tb_transaction" w/o the quotes) and i have also bring out the object_name
> column and make it into a group
> however, it seems not to be work. i have tested with statements like "sele
ct
> * from tb_transaction" and "select * from tb_customer" and both statements
> were shown in the profiler and the column object_name is always empty
> appreciate ur kind advice
> tks & rdgs
> --
> Message posted via http://www.droptable.com
>|||Hi ,
I have just tried using the object id method
1. the object id column is still blank
2. the profiler shows whatever SQL statement that i have executed on all the
tables including the object that i specially wanted it to be filtered
kindly advise
tks & rdgs
John Bell wrote:[vbcol=seagreen]
>Hi
>Object_name is not always recorded, using the object_id and database_id wil
l
>give you better results.
>John
>
>[quoted text clipped - 11 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200604/1|||Hi
Object_name and object_id are not recorded for this type of event/statement.
If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
record the object_id of the stored procedure (not the table being accessed)
See the topic "TSQL Data Columns" in Books Online for information of the
columns captured and what they mean.
You will need to search your source code to find references to a given table
.
John
"maxzsim via droptable.com" wrote:
> Hi ,
> I have just tried using the object id method
> 1. the object id column is still blank
> 2. the profiler shows whatever SQL statement that i have executed on all t
he
> tables including the object that i specially wanted it to be filtered
> kindly advise
> tks & rdgs
> John Bell wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200604/1
>|||> You will need to search your source code to find references to a given tab
le.
... or capture the execution plan. It might include the SQL statement (I do
n't recall right now...).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:A8427BCF-906D-46E3-857E-8CE37AC1B666@.microsoft.com...[vbcol=seagreen]
> Hi
> Object_name and object_id are not recorded for this type of event/statemen
t.
> If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
> record the object_id of the stored procedure (not the table being accessed
)
> See the topic "TSQL Data Columns" in Books Online for information of the
> columns captured and what they mean.
> You will need to search your source code to find references to a given tab
le.
> John
> "maxzsim via droptable.com" wrote:
>|||Hi ,
Below is from BOL on the object_name & object_id :
Object ID 22 System-assigned ID of the object.
ObjectName 34 Name of the object being referenced.
Is there a way to monitor all the activities performed on a particular table
?
i find it actually quite diffcult to know the object_id of a SP as there
could be many many SPs which would require me to first know what are the
activities being performed on a table in order to zoom in on a particular SP
else i might be trying on all SPs and the worst case is the one that i am
looking for is the last SP .
would appreciate if you could further advise
tks & rdgs
John Bell wrote:[vbcol=seagreen]
>Hi
>Object_name and object_id are not recorded for this type of event/statement
.
>If you had a stored procedure then SQL:StmtStarting and SQL:StmtCompleted
>record the object_id of the stored procedure (not the table being accessed)
>See the topic "TSQL Data Columns" in Books Online for information of the
>columns captured and what they mean.
>You will need to search your source code to find references to a given tabl
e.
>John
>
>[quoted text clipped - 19 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200604/1|||Hi
There is no easy way to do that, if you do use stored procedures then it
does not necessarily guarantee that a table is being accessed as it could
have branched code. For instance you could use
SP:StmtStarting/SP:StmtCompleted and search the textdata column (which is
easier if it is loaded into a table where you can use patindex) but this
would not be a definitive answer if you have not called every stored
procedure with every combination of parameters/data that will execute all
branches. There is also the possibly of the textdata being truncated.
John
"maxzsim via droptable.com" wrote:
> Hi ,
> Below is from BOL on the object_name & object_id :
> Object ID 22 System-assigned ID of the object.
> ObjectName 34 Name of the object being referenced.
> Is there a way to monitor all the activities performed on a particular tab
le ?
>
> i find it actually quite diffcult to know the object_id of a SP as there
> could be many many SPs which would require me to first know what are the
> activities being performed on a table in order to zoom in on a particular
SP
> else i might be trying on all SPs and the worst case is the one that i am
> looking for is the last SP .
> would appreciate if you could further advise
> tks & rdgs
> John Bell wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200604/1
>|||tks for your advice
appreciate it ..
John Bell wrote:[vbcol=seagreen]
>Hi
>There is no easy way to do that, if you do use stored procedures then it
>does not necessarily guarantee that a table is being accessed as it could
>have branched code. For instance you could use
>SP:StmtStarting/SP:StmtCompleted and search the textdata column (which is
>easier if it is loaded into a table where you can use patindex) but this
>would not be a definitive answer if you have not called every stored
>procedure with every combination of parameters/data that will execute all
>branches. There is also the possibly of the textdata being truncated.
>John
>
>[quoted text clipped - 32 lines]
Message posted via http://www.droptable.com
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment