September 26, 2005 at 9:19 am
Is there information in a sys table or somewhere in SQL Server can you tell the last date that indexes were created on a specific table?
September 26, 2005 at 9:25 am
sysindexes holds information about indexes, and There is not date in the table.
sp_helpindex authors displays no date information either.
September 26, 2005 at 9:33 am
The only information about indexes is if you create a unique index or primary key. Then the creation date information would be available in sysObjects.
September 26, 2005 at 10:04 am
If you have Lumigent's Log Explorer, you can set it to alert you when there are database changes. I have it on our production server and find it useful from time to time. There may be other products that do this too. It would be nice if Yukon included more statistics about object usage (last used, last modified ...)
September 26, 2005 at 10:10 am
Can you imagine the overhead with 10K TPM??????
Might be usefull, bu that would have to be in a trace flag or something...
September 26, 2005 at 10:17 am
Sorry, What's TPM ?
Back in my AS/400 days, I had all sorts of information about objects that was very useful. It kept track of objects usage & changes along with the associated users.
September 26, 2005 at 10:19 am
Transactions per minute.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply