var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Finding the Top 20 most Used/Active tables in a Sql 2000 DB
I have a legacy sql 2000 database with numerous stored procedure and tables.
I need to find out the top 20 most used/accessed tables in the database
Any one know how i could do this type of trace with profiler?
Save the trace to a table and join to it with a like on INFORMATION_SCHEMA.Tables
Text LIKE '%'+TABLE_NAME+'%'
ur codings are working excelent.
For such requirement we have scheduled a job to capture dbid from sysprocesses table every 1 minute and append to a file for further assessment, better than using PROFILER in this case.