Tracking Down a Problem User How do I track down a user that may be running a relatively quick query, but running it excessively?  For examples, they may:


be running a report over and over and over again
have a book set on their keyboard
have a refresh interval set very low


Other users may be running the exact same queries and reports, but their load on the system is minuscule.

I know how to track down problem queries, waits, etc., but I'm looking for a cumulative user-specific problem.
Apart from sp_whoisactive as mentioned in earlier answer, i can suggest running extended events for the type of query you want to track.

You can use the events and action as mentioned in the log Tracing Query Performance with Extended Events

I really like the extended events for the amount of data you can capture out and its not that expensive depending upon how much you capture.

Additionally you can use sp_blitzwho Forget sp_Who and sp_Who2:
sp_BlitzWho tells you what’s really happening.