Monitor Individual User resources used

  • Is there a way in SQL05 to monitor an individualusers performance/resources used?

    ie- I have a skilled user with read only access that I think may hit my prod server very hard..and want to monitor them to see what the performance impact may be.

  • The easiest way is to run a trace on this user (loginname = 'domain\user'), in the trace you'll have a cpu, read and write column. That'll give you a prety good idea on how much ressources he's using.

    If that's too heavy to run (traces might become too big) you can query the dmv sys.dm_exec_requests and sys.dm_exec_sessions to get a snapshot at the current situation (have to query often to get a general picture over time).

  • Thank you!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply