Usage statisitcs

19 May 2005 11:16 PM

Scott Elgram

Hello,
Ok, so maybe the information I want isn't here but I would think it
should be. I am running two MS SQL 7.0 servers that have been running with
very little maintenance for some time now. There are tons of tables and I
get a very distinct feeling a lot of them are not even being used anymore.
I'd like to do some spring cleaning of sorts but I can't figure out which of
all these tables are in use and which are not.
Is there a function in SQL 7 enterprise manager or whatever where I can
see information like when a table was last queried, updated, etc....?

--
-Scott

20 May 2005 1:11 AM

Mike Hodgson

Nope. The best you could do would be to use Profiler to watch the SQL
being executed on the server (including statements executed from within
T-SQL batches & stored procs) and filter the "Text" column to look for
any references to the tables you suspect aren't being accessed any
more. Of course, that won't guarantee that someone won't try to access
one of the tables a few minutes after you finally stop Profiler but if
you leave it running long enough it should give you a fairly good idea.

Show quoteHide quote

>Hello,
> Ok, so maybe the information I want isn't here but I would think it
>should be. I am running two MS SQL 7.0 servers that have been running with
>very little maintenance for some time now. There are tons of tables and I
>get a very distinct feeling a lot of them are not even being used anymore.
>I'd like to do some spring cleaning of sorts but I can't figure out which of
>all these tables are in use and which are not.
> Is there a function in SQL 7 enterprise manager or whatever where I can
>see information like when a table was last queried, updated, etc....?
>
>
>