Home Forums SQL Server 2005 Administering How can i find which tables are read/write intensive within sql server 2005 RE: How can i find which tables are read/write intensive within sql server 2005

  • Thank you for that... I 'll definately read up on those articles.

    In the meantime what is your opinion on the following query?

    select sum(reads) as Reads, sum(writes) as Writes

    from DB_NAME

    where TextData like '%TABLENAME%'

    (this would be querying an output from trace data gained from profiler)

    Would that be right in this context? Thanks