June 28, 2012 at 4:58 am
Apologies for opening up a new thread on this, but it basically follows on from this topic.
I also have been asked to find Owner/Size/Last Accessed for ALL of the SQL databases in our enterprise. It's a mixture of 2000/2005/2005 but mostly 2005. Now having tested many of the scripts out there most use the DMV sys.dm_db_index_usage_stats, but when I run any script it returns almost the exact date/time of when the script is executed, so I am wondering if this is correct.
Some instances have Northwind and pubs dbs installed (yes, I know!) I know they are not being used but why would they return a recent date? Is it because I am accessing the database by running a script to find when it is last accessed so it returns script execution time/date? For the 2008 instances I can run an audit, but any way of getting accurate date for the 2000/2005 instances? Or is the data being returned accurate and I'm just being an idiot? :crazy:
TIA
qh
June 28, 2012 at 6:04 am
This is an article Kim linked to in her connect item to demonstrate some of the current, limited, set of options: When was my database / table last accessed? by Aaron Bertrand
The article does not discuss Trace, but that is also an option.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2012 at 6:38 am
Much appreciated.
Rgds,
qh
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply