Home Forums SQL Server 2008 SQL Server 2008 - General I know which *file* is being hammered -- how do I find out *who* is doing the hammering? RE: I know which *file* is being hammered -- how do I find out *who* is doing the hammering?

  • If it's caused by one, or a handful, of procedures I would expect to see a large number for total_physical_reads in sys.dm_exec_query_stats.

    select top 50 t.text, s.total_physical_reads

    from sys.dm_exec_query_stats s

    cross apply sys.dm_exec_sql_text(s.sql_handle) t

    order by s.total_physical_reads desc