Application Name from Profiler

Question

Application Name from Profiler

VastSQL

SSC-Dedicated

Points: 36097
More actions
April 4, 2018 at 12:11 am

#328133

Hi Experts,
Trace result is giving application name in hexdecimal values like below. How to find the exact application name. These are application accessing SQL Server.
A98B8513-AFA3-4464-A403-114A3377A682
A6799C43-A9BE-4B86-9CFF-19565F263684
Thanks in Advance

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Those are the application names, at least it's what the app is putting into the connection string when connecting. Trace doesn't obsfucate or hash application name.
Add in the username column, and the host name, and you'll at least know where the app is connecting from, but from there it's going to have to be some investigation to identify what app is giving that na,e

p.s. Why are you using Profiler on SQL 2014????

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

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 2

GilaMonster - Wednesday, April 4, 2018 2:04 AM
Those are the application names, at least it's what the app is putting into the connection string when connecting. Trace doesn't obsfucate or hash application name.
Add in the username column, and the host name, and you'll at least know where the app is connecting from, but from there it's going to have to be some investigation to identify what app is giving that na,e
p.s. Why are you using Profiler on SQL 2014????

Thanks Gail.

Was trying to collect the TSQL batch starting and batch completed for a small duration to calculate the IO.

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

Ok, why are you using Profiler on SQL 2014?

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

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 4

GilaMonster - Wednesday, April 4, 2018 2:33 AM
Ok, why are you using Profiler on SQL 2014?

you mean to say use extended events?

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

VastSQL - Wednesday, April 4, 2018 3:08 AM
GilaMonster - Wednesday, April 4, 2018 2:33 AM
Ok, why are you using Profiler on SQL 2014?
you mean to say use extended events?

Yes.

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

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 6

GilaMonster - Wednesday, April 4, 2018 5:54 AM
VastSQL - Wednesday, April 4, 2018 3:08 AM
GilaMonster - Wednesday, April 4, 2018 2:33 AM
Ok, why are you using Profiler on SQL 2014?
you mean to say use extended events?
Yes.

Thanks Gail. Will use the same .

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

Note, it's going to return the same application names, because that's not profiler hashing or anything like that. It's the application passing that guid as the application name in the connection string.
SQL doesn't know what applications are connecting to it. It only knows what the applications say that they are.

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