SQL 2008 Profiler

Question

SQL 2008 Profiler

mpsathiskumar

SSC-Addicted

Points: 400
More actions
November 19, 2010 at 1:14 am

#228904

Hi All,
I have one web application with SQL 2008 DB. I need to get the trace for our application all pages. In this case multi users access the application all pages.
I want separate SQL 2008 profiler individual user trace with different machine with any of the filter option.
Any one can help to me for this? And tell me which is the filter condition for this?
Thanks & Regards,
Sathiskumar.P

Viewing 7 posts - 1 through 7 (of 7 total)

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

ps. One Orange Chip Points: 29423 More actions · Answer 1

mpsathiskumar (11/19/2010)
I want separate SQL 2008 profiler individual user trace with different machine with any of the filter option.

What do you want to trace? What do you mean by individual user trace? What do you want to filter the trace on (which column)?

Pradeep Singh

mpsathiskumar SSC-Addicted Points: 400 More actions · Answer 2

Hi,

I need "NTUserName" filter option, but it always displayed as empty.

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 3

It's only populated if the user logged in using Windows authentication. If they're using SQL authentication that will be blank and the LoginName will just display the SQL Login name.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ps. One Orange Chip Points: 29423 More actions · Answer 4

Gail, just checked and its showing NTUsername for my user. i am connected using a local userid/pwd.

Login name it's showing as machinename\username

Pradeep Singh

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 5

If login name has the form machineName\LoginName, it's a windows authentication connection. SQL Authentication will show the Login just as the login name (no machine prefix) and NTUsername will be blank

Windows authentication:

SQL Authentication:

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ps. One Orange Chip Points: 29423 More actions · Answer 6

Thanks Gail. I cross verified this one.

Pradeep Singh