|
Home > Archive > MS SQL Server Tools > April 2005 > Profiler counting table selects?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Profiler counting table selects?
|
|
|
| SQL 7.0
Is there a way to count the number of times a table is
accessed with a Select statement? This select is from a
third party application not a stored proc or QA.
Thanks,
Joe
| |
| Mike Epprecht \(SQL MVP\) 2005-04-27, 8:24 pm |
| Hi
SQL Server Profiler/Trace is your only way. Setup the trace and let it run
over a period of time.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Joe" < anonymous@discussion
s.microsoft.com> wrote in message
news:07b201c54b76$aa
8c6940$a601280a@phx.gbl...
> SQL 7.0
>
> Is there a way to count the number of times a table is
> accessed with a Select statement? This select is from a
> third party application not a stored proc or QA.
>
> Thanks,
> Joe
| |
| David Gugick 2005-04-28, 3:24 am |
| Mike Epprecht (SQL MVP) wrote:[color=darkred
]
> Hi
>
> SQL Server Profiler/Trace is your only way. Setup the trace and let
> it run over a period of time.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "Joe" < anonymous@discussion
s.microsoft.com> wrote in message
> news:07b201c54b76$aa
8c6940$a601280a@phx.gbl...
To add to Mike's response, filter by application since you already know
where the call is originating. You may be able to also filter on
TextData for the SQL:StmtCompleted and RPC:Completed events and only
include those events if the table name appears in the text.
--
David Gugick
Imceda Software
www.imceda.com
| |
|
| Perfect! Thank you very much...
>-----Original Message-----
>Mike Epprecht (SQL MVP) wrote:
trace and let[color=darkred]
message[color=darkre
d]
a[color=darkred]
>
>To add to Mike's response, filter by application since
you already know
>where the call is originating. You may be able to also
filter on
>TextData for the SQL:StmtCompleted and RPC:Completed
events and only
>include those events if the table name appears in the
text.
>
>--
>David Gugick
>Imceda Software
>www.imceda.com
>
>.
>
|
|
|
|
|