December 17, 2013 at 3:38 pm
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]
December 17, 2013 at 11:55 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply