|
|
|
SSC-Enthusiastic
 
Group: General Forum Members
Last Login: Sunday, November 01, 2009 12:52 PM
Points: 116,
Visits: 336
|
|
Comments posted to this topic are about the item Mastering SQL Server Profiler - Part 5: Data Columns
Brad M. McGehee
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.red-gate.com
http://www.simple-talk.com/community/blogs/brad_mcgehee/default.aspx
http://www.sqlservercentral.com/blogs/aloha_dba/default.aspx
|
|
|
|
|
Valued Member
Group: General Forum Members
Last Login: Tuesday, September 29, 2009 3:09 AM
Points: 56,
Visits: 30
|
|
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?
|
|
|
|
