|
|
|
|
Detecting Tables with no recent activity
Is there an efficent way to determine which tables in a SQL Server database
have had no activity reccently. This includes inserts, updates, deleted
and/or selects.
Are there any tools or techniques to find these tables?
All help appreciated!
Fri, 14 Jan 2005 01:05:03 -0800
"=?Utf-8?B?VGltIE8=?="
|
Re: Detecting Tables with no recent activity
Tim O wrote:
> Is there an efficent way to determine which tables in a SQL Server
> database have had no activity reccently. This includes inserts,
> updates, deleted and/or selects.
>
> Are there any tools or techniques to find these tables?
>
> All help appreciated!
Not inherently, as far as I know. The system tables do not track changes
to underlying objects. You can easily implement some very simple
triggers on the tables you are trying to track using something like the
following. This implementation tracks changes to a table at most once
each day. Using the Ignore_dup_key option on t
Fri, 14 Jan 2005 13:17:40 -0500
"David Gugick"
|
|