Post reply

Table Indexes

  • September 26, 2005 at 9:19 am

    #91329

    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

    #593034

    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

    #593037

    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

    #593055

    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

    #593056

    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

    #593060

    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

    #593061

    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