Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Heavily updated table list

Author  Topic 

Sarat
Constraint Violating Yak Guru

265 Posts

Posted - 2002-07-23 : 12:29:06
Hi,
Is there a table which tells us the most used/updated table-list?
Or
do we use sysindexes info and figure-out the most used ones?
Thanks,
Sarat.


Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-07-23 : 12:35:51
The answer to that question would have to be based on a given 'workload'. To capture a 'workload' use SQL Profiler.

<O>
Go to Top of Page
   

- Advertisement -