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
Author
Message
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?

Thanks!

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


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 40,427, Visits: 36,877
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 2008, 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