December 10, 2002 at 10:25 am
Often, I look at a database\table(s) and wonder when the data was last updated. Other than inserting a field to track this info is there any way I can tell?
TIA,
Bill
December 10, 2002 at 10:28 am
December 11, 2002 at 7:58 am
I concur
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
December 11, 2002 at 8:38 am
You might try a tool like log explorer:
http://www.lumigent.com/products/le_sql/le_sql.htm
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
December 12, 2002 at 8:59 am
If you wanted to see if a database is still be used, you could create a Agent job, that records the @@Total_Write and @@Total_Read for a database along with the date and time the job executed. Storing this over a period of time might be a simple way to get a feel for usage.
Likewise, for tables, to track inserts if the tables have identity columns, you could capture the max for each table and store that. I wouldn't use count here, but I would use it to track deletes. Updates are tougher. I supposed that subtracting the inserts and deletes from the database @@Total_Writes might give the number of updates that occured for a period. Not a complete accurate way, but a free solution to indicate activity.
hth
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply