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?

  • May 13, 2013 at 9:29 am

    #1614657

    By "sp_whoisactive", we most often mean Adam Machanic's stored procedure:

    http://sqlblog.com/files/default.aspx - current version is 11.11.

    You can also run sp_who2 and save the output, run it again, and see the difference in disk IO.

    Alternately, watch what _time_ it's spiking so much, and run a trace (or Profiler, if you it doesn't hit your performance too much) during that time!