When I run a trace in profiler, it hits several hosts - for example, DB Server, App Server, Web Server etc.
1)Is it recommended to just filter out the server you want to monitor performance for? can co-relation between performance of different hosts beneficial for cross-reference?
2)If a user is running the application, i want to just filter his activity. Will all activity generated from his desktop always have his loginname only, or will the service account's login be displayed for his activity, some times? I want to accurately see the performance of the activity generated by him only..