Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning using dm_exec_sessions to count reads? RE: using dm_exec_sessions to count reads?

  • January 31, 2008 at 12:50 pm

    #773910

    One of the easiest ways to count reads is using profiler. Start up a session, trace T-SQL:Stmt_completed and/or T-SQL:BatchCompleted and filter on your login name and/or machine name.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass