June 29, 2012 at 1:45 am
Hi,
I'l like to get the DBs status on a Server. Means, I need to know what are the DBs are being used, what are not being & if any are in use, I need to know when it was used last time and how frequently it’s been used in the past several month.
June 29, 2012 at 2:22 am
Sounds like you need to build a custom monitoring solution to fit your needs on that, as that information isn't readily available in SQL.
You could check sys.dm_db_index_usage_stats and that will tell you what indexes have been used in user operations. Convert the database_id into the DB Name, and get the max datetime from a seek scan lookup update field.
The only caveat to that is that DMV is cleared upon each SQL server restart so you cannot trust it completly to be a true representation of activity
June 29, 2012 at 4:03 am
Thank you for the reply...
I already got the info. through 'dm_db_index_usage_stats' & it displayed only Last_Read & Last_Write dates of all the DBs. But we can't get the exact details with only these two statistics. I am working on this, if you've any other alternative which atleast solve our prob. please suggest me...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply