profiler : how to filter my PC events

  • 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
  • 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 2 posts - 1 through 3 (of 3 total)

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