SQL Server 2000 table statistics

  • I'm starting to review the design of a SQL Server 2000 database, and I'm trying to reduce the amount of time that I spend looking for tables that are used most often. Basically, I want to spend more time on the commonly used tables, and less time review the seldomly used tables.

    I came from a 2008 environment where table stats are stored (I believe) automatically. Is there any way to get stats for the tables to determine which ones are being used the most?

    Thanks!

    EDIT: I'm looking for historical data, and not on go-forward via table auditing.

    [font="Courier New"]_______________________________
    Stephen Walsh[/font]

  • No, there isn't. SQL 2000 doesn't keep track of any of that, even 2005 onwards only tracks usage since the last restart.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply