Re: Statistic Generator
- From: "David Gugick" <davidg-nospam@xxxxxxxxxx>
- Date: Thu, 28 Apr 2005 12:38:11 -0400
About your only option, short of implementing auditing in your SPs and adding triggers to the tables (to monitor i/u/d access) is to use Profiler or server-side tracing and watch activity, say over a 24-hour period. If you trap the SP:Starting event, you'll get a list of the ObjectIDs of all procedures accessed in the database. You can resolve the names against the system tables or use the object_name() function within the context of the database. Tables are more difficult to monitor. If you are completely SP-based, then you can just resolve the tables from the SP code. If your apps run dynamic sql, then you'll have to look at SQL:StmtStarting and RPC:Starting events and resolve the table names from there.
-- David Gugick Imceda Software www.imceda.com
"ECathell" <ecathell@xxxxxxxxxxxxxxxxxxxx> wrote in message news:OF38r9$SFHA.3012@xxxxxxxxxxxxxxxxxxxxxxx
We have a database solution that was created by a 3rd party vendor. Over time we have replaced their applications with our own in-house applications, however not all of our programs have been upgraded so some of the tables and stored procedures may still be in use. Is there a tool or table that would show me access or usage dates so that I could see when a certain sp was executed last? Or when a certain table was last accessed?
Thanks Eric
--
--Eric Cathell, MCSA
.
- References:
- Statistic Generator
- From: ECathell
- Statistic Generator
- Prev by Date: Perfmon Counters Missing
- Next by Date: RE: osql and 'real' csv format
- Previous by thread: Statistic Generator
- Next by thread: Perfmon Counters Missing
- Index(es):
Relevant Pages
|
