Post reply

profiler : how to filter my PC events

  • June 16, 2012 at 7:06 am

    #262414

    Scenario:

    My PC as a client running a web application of WebServer1 which access SqlServer1 using a credential internally.

    Question:

    how can i filter my PC events.

    HostName shows WebServer1

    LoginName shows 'Credential that Webserver1' uses.

    so, NTUserName is empty

    when i choose, NTDomainName, gives error 'The trace Event ID is not valid' when i run it.

    Appreciating your help

  • June 16, 2012 at 7:32 am

    #1501954

    Unless the webserver passes something to SQL to identify the originator of the request, you can't in this case. As far as SQL (and hence profiler) is concerned, the connections came from the web server, it has no knowledge whatsoever of what connected to the web server.

    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

  • June 16, 2012 at 7:38 am

    #1501956

    GilaMonster (6/16/2012)

    Unless the webserver passes something to SQL to identify the originator of the request, you can't in this case. As far as SQL (and hence profiler) is concerned, the connections came from the web server, it has no knowledge whatsoever of what connected to the web server.

    Thanks a Lot GilaMonster.

Viewing 3 posts - 1 through 2 (of 2 total)

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