Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Posts
    3

    Unanswered: Finding the Top 20 most Used/Active tables in a Sql 2000 DB

    Hi,

    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?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Save the trace to a table and join to it with a like on INFORMATION_SCHEMA.Tables

    Text LIKE '%'+TABLE_NAME+'%'
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    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.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •