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 2005 Forums
 SQL Server Administration (2005)
 how 2 know the most requested tables

Author  Topic 

rtutus
Aged Yak Warrior

522 Posts

Posted - 2007-08-13 : 11:37:13
Is there a way to know the tables the mostly requested in a database
How please?

Because we want to copy indexes from DB2 to SQl tables, but since there re so many tables in the DB we want to start with the most requested tables by the applications

Thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-13 : 15:59:31
You need trace that in profiler or with third party auditing tools.
Go to Top of Page
   

- Advertisement -