• Great series Brad. I've used Profiler a fair bit for a while but will certainly be utilising it a lot more after watching your series using what I've learnt.

    One thing I find frustrating is trying to "profile" events where the application uses a dedicated SQL login and the users are in a terminal server environment.

    This (as far as I can see) leaves the DBA almost blind as to who and where.

    The login name is shared among all users and the host is always the terminal server name.

    Do you have any ideas on how to dig deeper into the data columns to get past this abstraction?