Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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: Today @ 9:27 AM
Points: 43,445, Visits: 40,580
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
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