Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL Server 2000 table statistics Expand / Collapse
Posted Tuesday, December 17, 2013 3:38 PM

Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 19, 2014 9:57 AM
Points: 5, Visits: 49
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?


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

Stephen Walsh
Post #1523905
Posted Tuesday, December 17, 2013 11:55 PM



Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
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

Post #1523960
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse